Unhide Columns in Excel

This tutorial covers how to quickly unhide columns in an Excel using just the keyboard.

Before you can unhide columns, it is necessary to hide columns in Excel.

The key combination for adding the time is:

 Ctrl  + Shift  + 0   (zero key)  

Note: For Vista and Windows 7 users, this keyboard shortcut may not work unless first you change an existing Windows shortcut key assignment in Control Panel.

See this Microsoft Knowledge Base article for details.

Or, you can quickly unhide columns with a right click of the mouse.

Example: Use Shortcut Keys to Unhide Columns of Data in Excel

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

1. To unhide one or more columns, drag select at least one cell in the columns on either side of the hidden column(s).
   
   
2. Press and hold down the Ctrl and the Shift keys on the keyboard.
   
   
3. Press and release the " 0 " key - the zero ( 0 ) key - without releasing the Ctrl and Shift keys.
   
   
4. 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