Open Control Panel -> Change keyboards or other input methods (Under Clock, Language and Region).To summarize, the solution is (in Windows 7): 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. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |