Note: This tutorial can be used with all versions of Excel up to and including Excel 2007.
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
- Right click on the column header of the column to be hidden.
- Choose Hide from the menu.
- 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.
- In the column header drag select to highlight all of the columns you want to hide.
- Right click on the selected columns.
- Choose Hide from the menu.
- 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.
- In the column header left click on the first column to be hidden.
- Press and hold down the CTRL key on the keyboard.
- Continue to hold down the CTRL key and left click on the rest of columns to be hidden.
- Right click on one of the selected columns.
- Choose Hide from the menu.
- The selected columns and column letters will be hidden from view.
