1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Unhide Columns in Excel

Unhide Previously Hidden Columns of Data in Excel

By

Unhide Columns in Excel

Unhide Columns in Excel

© Ted French

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 using the mouse

You must select at least one column on either side of the hidden column.

For example, to unhide column C.

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

To unhide column A in the worksheet using the Name Box

Note: This method can also be used to unhide any single column in a worksheet - not just column A.

  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 using the mouse - all versions of Excel

You must select at least one column on either side of the hidden columns.

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

  1. Place your mouse pointer in the column header.
  2. Click and drag with the left mouse button to highlight columns A to H to unhide all columns at one time.
  3. Right click on the selected columns.
  4. Choose Unhide from the menu.
  5. The hidden columns and the column letters will be visible.

©2014 About.com. All rights reserved.