Unhide/Hide column in Excel

Note: This tutorial can be used with all versions of Excel up to and including Excel 2007.

To unhide columns in a worksheet is Microsoft's term for displaying columns that were previously hidden.

Unhide Columns in an Excel Worksheet

To unhide a single column

For example, you want to unhide column C.

1. Place your mouse pointer in the column header and drag select to highlight columns B and D.
2. Right click on the selected columns.
3. Choose Unhide from the menu.
4. The hidden column and the column letter will be visible.

To unhide column A in the worksheet in Excel 2007

1. Type the cell reference A1 in the Name Box and press the Enter key on the keyboard.
2. Click on the Home tab on the ribbon.
3. Click on the Format icon on the ribbon to open the drop down list.
4. Choose Hide & Unhide > Unhide Columns from the drop down list.
5. Column A will become visible.

To unhide column A in the worksheet in Excel versions 97 to 2003

1. Type the cell reference A1 in the Name Box and press the Enter key on the keyboard.
2. Click on the Format menu.
3. Choose Column > Unhide in the menu.
4. Column A will become visible.

To unhide multiple columns in the worksheet - all versions of Excel

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

1. In the column header drag select to highlight columns A to G.
2. Right click on the selected columns.
3. Choose Unhide from the menu.
4. The hidden columns and the column letters will be visible.