What's the keyboard shortcut to unhide a column in Excel 2010?
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):
- Open Control Panel -> Change keyboards or other input methods (Under Clock, Language and Region)
- Click the Change Keyboards button on the Keyboards and Languages tab
- On the Advanced Key Settings tab, select the Between input languages action and click Change Key Sequence
- 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...
The shortcut for unhiding columns is: Alt+H, O, U, L