About This Shortcut

Unhide any hidden columns that intersect the current selection.

Notes:

(1) May not work in Excel 2010 on Vista or Windows 7.

Discussion and fix is here: http://superuser.com/questions/183197/whats-the-keyboard-shortcut-to-unhide-a-column-in-excel-2010

(2) May not work in Excel 2007.

Windows 10 Change Key Sequence hotkey dialog box

See http://www.techrepublic.com/blog/microsoft-office/office-solution-keyboard-shortcuts-for-hiding-and-unhiding-columns-and-rows/

(3) In Windows 10, there is a conflict with a keyboard-switching shortcut.

you might resolve this by unassigning the keyboard layout hot key.

You may need to unassign the input language as well.

Windows 10 Change Key Sequence hotkey dialog box

This is a tricky setting to find.

You are looking for Advanced Keyboard tweaks, under Region and Language.

Update February 2022: Can’t get the above trick to work.

Windows 10 Change Key Sequence hotkey dialog box

Let us know if you find a solution.

The videos below demonstrate this shortcut.

Shortcuts to hide/unhide rows and columns

Windows 10 Change Key Sequence hotkey dialog box

Windows 10 Change Key Sequence hotkey dialog box

Video thumbnail for Shortcuts to hide/unhide rows and columns