Q:

How do you unhide columns in Excel?

A:

Quick Answer

To unhide columns in Excel, open an existing worksheet, select a column adjacent to the hidden one, navigate to the Format menu, point to Hide & Unhide under Visibility, and then select Unhide Columns. You can also unhide a column of by changing the column width from the Format menu.

Continue Reading

Full Answer

  1. Open a worksheet

    From the Start menu or Applications folder, open Microsoft Excel, and then select the worksheet you want to edit.

  2. Select the hidden cells

    To show hidden columns, highlight the column that is either to the left or right of the column you want to unhide. To select the column, click on the column heading, or click on a cell in the column, and drag the mouse to the last cell. To show the first column, type "A1" into the Name box by the formula bar.

  3. Navigate to the formatting options

    Go to the Home tab, and click on Format, which is located in the Cells group.

  4. Make hidden columns visible

    From the Format menu, navigate to Hide & Unhide under Visibility, and then click on Unhide Columns. You can also unhide a column by changing its width after selecting Column Width under Cell Size in the Format menu.

Learn more about Software

Related Questions

Explore