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

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.

23 thoughts on “Ctrl+0: Hide Columns in Excel (Ctrl+Shift+0 to Unhide Columns)”

  1. 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. 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. Hi,

    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.

  4. 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.

  5. 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!

Leave a Reply

Your email address will not be published. Required fields are marked *