1. Computing

Hide Columns in Excel

How to Hide Columns of Data in Excel

By

Hide  Columns in Excel

Hide Columns in Excel

© Ted French

Related Tutorial: Unhide Columns in Excel

As with all things Microsoft, there is more than one way to hide columns in an Excel worksheet. These instructions show you how to hide columns by right clicking on the column header.

The column header is the gray bar along the top edge of the worksheet containing the column letters.

Hide Columns in an Excel Worksheet

When you hide a column in a worksheet, data in that column can still be used and referenced in the worksheet.

To hide a single column

  1. Right click on the column header of the column to be hidden.
  2. Choose Hide from the menu.
  3. The selected column and the column letter will be hidden from view.

To hide adjacent columns in the worksheet

For example, you want to hide columns C, D, and E.

  1. In the column header drag select to highlight all of the columns you want to hide.
  2. Right click on the selected columns.
  3. Choose Hide from the menu.
  4. The selected columns and column letters will be hidden from view.

To hide separated columns in the worksheet

For example, you want to hide columns B, D, and F.

  1. In the column header left click on the first column to be hidden.
  2. Press and hold down the CTRL key on the keyboard.
  3. Continue to hold down the CTRL key and left click on the rest of columns to be hidden.
  4. Right click on one of the selected columns.
  5. Choose Hide from the menu.
  6. The selected columns and column letters will be hidden from view.

©2014 About.com. All rights reserved.