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)Īs 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.What is the shortcut in Excel to unhide column A There are several dedicated keyboard shortcuts to hide and unhide rows and columns. On the Advanced Key Settings tab, select the Between input languages action and click Change Key Sequence Then, select Unhide and Excel will expose the hidden row or column.Then, choose Row or Column from the Format menu, and select Unhide.Click the Change Keyboards button on the Keyboards and Languages tab.Open Control Panel -> Change keyboards or other input methods (Under Clock, Language and Region).To summarize, the solution is (in Windows 7):

In order to unhide hidden rows in an Excel spreadsheet, we must first be able to find them. Here too, the keyboard shortcut, Shift Alt Right arrow, is also available. 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.Īfter following the resolution in that KB article, the issue is fixed, and unhiding columns via the keyboard in Excel 2010 works as expected. Select the desired columns, and from the Excel main horizontal menu, open the Data tab, and left mouse click the Group option. 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. Googling 'Excel Ctrl Shift 0' brought me to this thread on the ExtremeVBTalk forum.

Unhide first column in excel shortcut