Hiding Columns, Rows, and Cells in Excel (Redisplaying Columns)

1.      Select at least one cell from both of the columns around the hidden column(s) to be redisplayed
EXAMPLE: If column B is hidden, select a cell from both columns A and C.
HINT: If you cannot select the appropriate cells, you can use the Go To command.

2.      On the Home command tab, in the Cells group, click FORMAT

3.      From the Format menu, in the Visibility section, select Hide & Unhide » Unhide Columns
The column reappears.

Redisplaying Columns: Quick Menu Option

This option works well for redisplaying column A, since there are not columns on both sides of column A.

1.      Hold your cursor between column IDs on the right side of the hidden column
The cursor will change to an open, double sided arrow as shown here.

2.      Right click » select Unhide

Related Posts by Categories