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.
- Open a worksheet
From the Start menu or Applications folder, open Microsoft Excel, and then select the worksheet you want to edit.
- 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.
- Navigate to the formatting options
Go to the Home tab, and click on Format, which is located in the Cells group.
- 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.