Excel shortcut: Ctrl-0 and Ctrl-Shift-0 to hide or unhide columns (note: issues under Windows Vista, 7 and 8)

Ctrl-0 hides all columns in the currently selected cells.

Ctrl-Shift-0 unhides any columns that are hidden within the currently selected cells.  Any columns that were previously unhidden within the selection are not changed.

There is an issue when running Windows Vista, Windows 7 and Windows 8 that means the operating system intercepts the Ctrl-Shift-0 shortcut so it does not work in Excel.  Click read more to see how to overcome this.



The following thread has the solution for Windows 7: http://superuser.com/questions/183197/whats-the-keyboard-shortcut-to-unhide-a-column-in-excel-2010

In Windows 8 the solution is a little different, so I list it here for completeness:

1. Control Panel
2. Clock, Language and Region
3. Language
4. Advanced Settings
5. Change language bar hot keys (in the "Switching input methods" section)
6. On the Advanced Key Settings tab, make sure "Between input languages" is selected and press the Change Key Sequence... button
7. Set the Switch Keyboard Layout radio button to Not Assigned