Hide Columns in Excel

An Excel Keyboard Shortcut

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

Related article: Unhide Columns in Excel.

Example of How to Hide Columns using a Keyboard Shortcut

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

1. Enter the following data into cells D1 to F1: January, February, March.
   
   
2. Click on cell E1 with the mouse to highlight it.
   
   
3. Press and hold down the Ctrl key on the keyboard.
   
   
4. Press and release the zero " 0 " key without releasing the Ctrl key.
   
   
5. Column E should now be hidden from view - along with the data (February) it contains in cell E1.

Note: The data in E1 has not been deleted. It can still be referenced in such things as formulas and charts even though it has been hidden.

Other Keyboard Shortcuts

• Adding the Current Time
• Select Non-Adjacent Cells in Excel
• ALT - TAB Fast Switching in Windows