Excel Shortcut To Unhide Columns Not Working - 2569

One of these four shortcut keys stops working in Windows versions of Excel:
Ctrl+9 to hide rows
Ctrl+Shift+9 to Unhide rows
Ctrl+0 to hide columns
Ctrl+Shift+0 to unhide columns
If the last one is not working for you, it is because the Windows shortcut to switch language is assigned to Ctrl+Shift. This video shows the Control Panel setting to make Ctrl+Shift+0 or Ctrl+Shift+) start unhiding columns again.

Transcript of the video:

The Excel shortcut key to Unhide columns stopped working.
We have these great 4 keyboard shortcuts.
If you want to hide rows, that is Ctrl+9.
And then Ctrl+Shift+9 to unhide.
To hide columns, Ctrl+Zero and then Ctrl+Shift+0 to unhide.
But that is not working.
It's not Excel's fault.
You have to go into the Control Panel.
Go into Typing.
Down here to Advanced.
Keyboard Settings.
And then Input Language Hotkeys.
Right there, see the Windows is hijacking Ctrl+Shift.
Change the key sequence.
Choose to change to Not Assign, Not Assign.
Click OK, click OK.
Close the Control Panel.
And now Ctrl+Shift+Zero will unhide.
It's all good again. Well, thanks to Steve on the Excel team for figuring that one out, and thanks to you for stopping by.
We'll see you next time for another netcast from MrExcel.