1. Home
  2. Computing & Technology
  3. Spreadsheets

Hide Columns in Excel
An Excel Keyboard Shortcut

By Ted French, About.com

Hiding Columns in Excel Using a Keyboard Shortcut

Hiding Columns in Excel Using a Keyboard Shortcut

© Ted French

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

More Spreadsheets Quick Tips
Explore Spreadsheets
About.com Special Features

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

Easy ways to connect two computers for networking purposes. More >

  1. Home
  2. Computing & Technology
  3. Spreadsheets
  4. Tips and FAQs
  5. Keyboard Shortcuts
  6. Hide Columns in Excel - Excel Keyboard Shortcuts

©2009 About.com, a part of The New York Times Company.

All rights reserved.