Windows Keyboard Shortcuts

Ctrl+0: Hide Columns in Excel (Ctrl+Shift+0 to Unhide Columns)

Posted in Microsoft Excel by estephen on July 11th, 2007

Similar to yesterday’s tip, you can press Ctrl+0 to hide the column where the cursor is located. Ctrl+A, Ctrl+Shift+0 unhides all the columns in the sheet.

Update on January 5, 2014:

This keyboard sequence is used for changing your language by Windows, preventing it from working in Excel. If you’re running an older version of Windows, see Guilherme’s comment below.

In Windows 7, try this to get this shortcut to work in Excel:

1. Run the Control Panel, and select Region and Language.
2. Select the “Advanced Key Settings” tab.
3. Select the “Between input languages” item, then press Alt+C to select the Change Key Sequence item.
4. Under “Switch Keyboard Layout” make sure that “Not Assigned” is selected, then select OK and OK.

That will fix ALL keyboard shortcut items that involve Ctrl+Shift.

27 Responses to 'Ctrl+0: Hide Columns in Excel (Ctrl+Shift+0 to Unhide Columns)'

Subscribe to comments with RSS or TrackBack to 'Ctrl+0: Hide Columns in Excel (Ctrl+Shift+0 to Unhide Columns)'.

  1. Narendra Rana said,

    on April 3rd, 2008 at 3:13 am

    Ctrl + Shift + 0 does not unhide the column in Excel 2007 (vista system). Is there any bug fix for this since I’m sure this shortcut has not been removed as it is still mentioned in the Shortcut keys list and in the tip of the day given on top of this page also. [ “Ctrl+0: Hide Columns in Excel (Ctrl+Shift+0 to Unhide Columns)
    Posted in Microsoft Excel by estephen on the July 11th, 2007 ” ]

  2. estephen said,

    on April 14th, 2008 at 1:39 pm

    Make sure you have the hidden rows/columns selected when you do this keyboard shortcut. Since they’re hidden, that’s a bit tricky. The best thing to do is go to a cell before the hidden part, then press Shift while you use the right arrow or down arrow key to go after the hidden part, then press Shift+Ctrl+0.

  3. estephen said,

    on April 14th, 2008 at 1:40 pm

    Or, as I said in the original post — press Ctrl+A to select everything first.

  4. Subashini said,

    on May 21st, 2009 at 1:25 am


    I have been facing the same problem for a while. I kept experimenting with a combination of keys and I just discovered that control shift and = would unhide the hidden columns.

  5. Titus Barik said,

    on June 2nd, 2009 at 6:53 pm

    I can confirm this as well. Something is causing Ctrl + Shift + 0 to get swallowed from within Windows Vista, and it affects any application that is using this key combination, not just Excel. Ctrl + Shift + 1 through Ctrl + Shift + 9 seem to work just fine however.

  6. geo said,

    on August 6th, 2009 at 6:24 am

    this is the fix thx to mikeray on Opera browser forums

  7. masood said,

    on March 5th, 2012 at 3:18 am

    I am facing the problem. ie: Ctrl+0: Hide Columns in Excel (Ctrl+Shift+0 to Unhide Columns) dost working

  8. Guilherme said,

    on July 24th, 2012 at 8:49 am

    I was facing the same problem, but i’ve found a solution.
    you´ll be able to use ctrl + shift + 0 to unhide columns in Excel 2010 works as expected. To summarize, the solution is (in Windows 7):

    1.Open Control Panel -> Change keyboards or other input methods (Under Clock, Language and Region)
    2.Click the Change Keyboards button on the Keyboards and Languages tab
    3.On the Advanced Key Settings tab, select the Between input languages action and click Change Key Sequence
    4.Under Switch Keyboard Layout, set the radio button to Not Assigned (or one of the other options, if you need this feature to be available)

    Now, works fine for me!

  9. DN said,

    on August 23rd, 2012 at 1:18 am

    Thanks Guilherme .. Soln works

  10. Sandhya said,

    on December 10th, 2012 at 11:25 pm

    Thanks Guilherme.. Great Help !!

  11. Ramesh said,

    on February 23rd, 2013 at 9:07 pm

    Thanks Guilherme… Excellent… A long irritation solved…

  12. SS said,

    on May 8th, 2013 at 6:34 am

    Guilherme - SOLID! Great help!

  13. Josh said,

    on July 18th, 2013 at 8:43 pm

    Ctrl + Alt + Down usually works for me

  14. mario said,

    on August 13th, 2013 at 5:57 pm

    is any affect from change the radio button?

  15. No Longer Frustrated said,

    on December 3rd, 2013 at 8:43 pm

    Thank you!!!

  16. Samta said,

    on February 21st, 2014 at 10:05 pm

    Thanks Guilherme…

    Very well explained. Ctrl+Shift+0 is working now :-)

  17. hira said,

    on March 27th, 2014 at 3:10 pm

    Thanks Guilherme… Excellent… A long irritation solved…

  18. Faraz Ahmed Qureshi said,

    on April 3rd, 2014 at 6:00 pm

    Excellent Till Date!

  19. Marwan said,

    on December 29th, 2014 at 3:20 am

    Brilliant Guilherme

    Thanks a million

  20. Vikas said,

    on January 22nd, 2015 at 11:39 pm

    how to do it on Windows 8

  21. Jessica said,

    on March 19th, 2015 at 11:59 pm

    Thanks Guilherme!!!!!!!!!!!!

  22. Ivey said,

    on March 29th, 2015 at 11:19 am

    Lo que yo quiero hacer como el abogado representando mis clientes es obligarles al banco
    de cumplir sus promesas.

  23. on March 30th, 2015 at 8:46 pm

    I do not know whether it’s just me or if perhaps everyone else experiencing issues with
    your website. It seems like some of the written text on your content are running off the screen. Can someone else
    please comment and let me know if this is happening to them too?
    This may be a issue with my web browser because I’ve had
    this happen previously. Appreciate it

  24. on April 3rd, 2015 at 2:33 am

    save electricity…

    Windows Keyboard Shortcuts » Ctrl+0: Hide Columns in Excel (Ctrl+Shift+0 to Unhide Columns)…

  25. on April 15th, 2015 at 12:14 am

    26. Thus.

  26. on April 15th, 2015 at 12:15 am

    SF353-160-39-1121351015+1315, PG232-71-50-001111011-65,0 PPG en route to the Gold Medal.8 points, its surprising they finished November above . The pairing is plus-8. PF250-00-00-225701111+20,3%46. and pretty much did what they had done two nights earlier on the glass. that is how the Celtics lost Game 7.

  27. on April 15th, 2015 at 12:15 am

    and he should get another chance to compete for an elusive league title in 2014. Tyler Glass (@irishfan10839) 34 7.68. “It can be hard for him sometimes because, I dont listen to the bad remarks.9423.336. fans thought, And Cooper was also someone who had won Olympic gold and bronze medals on Team USA. Roy drove to the basket with 10.

Leave a Reply