Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

My SHIFT key doesn't appear to be broken, so this one's got me stumped: Looking online, I've been told the keyboard shortcuts for hiding and unhiding columns in Excel are CTRL + 0 and CTRL + SHIFT + 0, respectively.

The former of these works for me in Excel 2010, but for some reason the Unhide shortcut does nothing. Has that keyboard shortcut changed, or... what am I missing?

share|improve this question
add comment

6 Answers 6

up vote 13 down vote accepted

Well, I'll be danged. Googling "Excel Ctrl Shift 0" brought me to this thread on the ExtremeVBTalk forum. That thread eventually comes up with this Microsoft KB article, revealing that, in Vista (and apparently Win7 as well), CTRL + SHIFT is hooked by the Regional/Language settings to change keyboard layouts. That functionality probably assigns the number keys to different layouts, so Win7 is swallowing CTRL + SHIFT + 0 and trying to change my keyboard layout (I don't have any non-default layouts set) instead of passing the shortcut to Excel.

After following the resolution in that KB article, the issue is fixed, and unhiding columns via the keyboard 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)

As for Dan's answer, no idea why the official list changed; after this fix the keyboard shortcut does seem to work, and the problem was related to an operating system setting, not Excel version...

share|improve this answer
    
+1, Good answer to your own question. The fact you got it to work makes it a bit bizarre that they took it out of the list of shortcuts. –  Dan Aug 31 '10 at 21:44
    
It is a strange (and, given the question/answer here, ironic) oversight... –  Dan J Aug 31 '10 at 21:48
    
+1 - Good job figuring it out. I tried it on XP which explains why I couldn't replicate! –  JNK Sep 1 '10 at 0:08
    
And THIS is why we love Stack Exchange. Answers like this simply would not come out of the woodwork and into google search results more efficiently any other way. Thank you, Jeff Atwood! –  Peter Nore Mar 21 '12 at 15:12
add comment

The shortcut for unhiding columns is: Alt+H, O, U, L

share|improve this answer
    
Thank you!! You just saved me probably an hour of sleeping :) –  Philippe Jan 23 at 3:19
add comment

In this official list of 2010 shortcuts the only row/column hide/unhide shortcuts are:

CTRL+SHIFT+(    Unhides any hidden rows within the selection.
CTRL+9  Hides the selected rows.
CTRL+0  Hides the selected columns.

In this official list of 2007 the row/column hide/unhide shortcuts are:

CTRL+SHIFT+(    Unhides any hidden rows within the selection.
CTRL+SHIFT+)    Unhides any hidden columns within the selection.
CTRL+9  Hides the selected rows.
CTRL+0  Hides the selected columns.

It looks like they just simply took it out.

EDIT: Looks like it is still there see djacobson's answer.

share|improve this answer
add comment

I've just been playing with this under UK Vista and it seems the default shortcut without tweaking the keyboard language settings is ctrl + shift + - (effectively ctrl + _)

share|improve this answer
add comment

You have to select the hidden column before you can CTRL + SHIFT + 0 to unhide. Easiest way is probably to put a cell into the Name Box (box at top left that lists the cell notation), then to CTRL + SHIFT + 0.

share|improve this answer
    
Didn't work. However, entering a cell reference, hitting Enter, and then CTRL + 0 does hide the selected column. It certainly appears that the Unhide shortcut is failing to work wherever the Hide shortcut works... –  Dan J Aug 31 '10 at 21:07
add comment

In Excel 2010 there are shortcut keys for Hiding & Unhiding Rows / Column and they are working.

First check the settings:

  1. Open Control Panel -> Change keyboards or other input methods (Under Clock, Region and Language)

  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 try this

  • Hiding Rows CTRL+(
  • Unhiding Rows CTRL+Shift+(
  • Hiding Columns CTRL+)
  • Unhiding Column CTRL+Shift+)
share|improve this answer
1  
How does this materially add to the existing answers? –  Dan J Mar 14 at 18:59
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.