1. Computing

Discuss in my forum

Hide Columns in Excel

An Excel Keyboard Shortcut

By , About.com Guide

Use Shortcut Keys to Hide Columns in Excel

Use Shortcut Keys to Hide Columns in Excel

© Ted French

This tutorial covers how to quickly hide columns of data in an Excel using just the keyboard.

Related tutorial: Unhide Columns in Excel.

The key combination for hiding columns is:

 Ctrl  + 0    

Example of How to Hide Columns using a Keyboard Shortcut

For help with this example, see the image above.

  1. Enter the following data into cells D1 to F1: January, February, March.

  2. Click on cell E1 (February) with the mouse to highlight it.

  3. Press and hold down the Ctrl key on the keyboard.

  4. Press and release the " 0 " - 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

©2013 About.com. All rights reserved.