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.

22 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. Sessi said,

    on July 10th, 2015 at 7:30 am

    thanks so much, you’re a lifesaver.

Leave a Reply