Unhide Columns in an Excel Worksheet
Related Tutorial: Hide Columns in Excel
To unhide columns in a worksheet is Microsoft's term for displaying columns that were previously hidden.
To unhide a single column
For example, you want to unhide column C.
- Place your mouse pointer in the column header and drag select to highlight columns B and D.
- Right click on the selected columns.
- Choose Unhide from the menu.
- The hidden column and the column letter will be visible.
To unhide column A in the worksheet in Excel 2007 / 2010
- Type the cell reference A1 in the Name Box and press the Enter key on the keyboard.
- Click on the Home tab on the ribbon.
- Click on the Format icon on the ribbon to open the drop down list.
- Choose Hide & Unhide > Unhide Columns from the drop down list.
- Column A will become visible.
To unhide column A in the worksheet in Excel versions 97 to 2003
- Type the cell reference A1 in the Name Box and press the Enter key on the keyboard.
- Click on the Format menu.
- Choose Column > Unhide in the menu.
- 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.
- In the column header drag select to highlight columns A to G.
- Right click on the selected columns.
- Choose Unhide from the menu.
- The hidden columns and the column letters will be visible.





