Unhide Columns in Excel

An Excel Keyboard Shortcut

This Excel tip shows you how to unhide columns in an Excel spreadsheet using a keyboard shortcut.

Example of How to Unhide Columns using a Keyboard Shortcut

Note: For help with this example, see the image to the right.

1. Before you can unhide columns, it is necessary to hide columns in Excel.
   
   
2. Once you have hidden one or more columns, drag select the columns on either side of the hidden column(s).
   
   
3. Press and hold down the Ctrl and the Shift keys on the keyboard.
   
   
4. Press and release the zero key ( 0 ) on the keyboard without releasing the Ctrl and Shift keys.
   
   
5. The hidden column(s) will reappear in the spreadsheet.
   
   

Other Keyboard Shortcuts

• Adding the Current Date
• Select Non-Adjacent Cells in Excel
• Adding the Current Time