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

1.      Select at least one cell from both of the rows around the hidden row(s) to be redisplayed
EXAMPLE: If row 5 is hidden, select a cell from rows 4 and 6.
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 Rows
The row appears.

Redisplaying Rows: Quick Menu Option

This option works well for redisplaying row 1, since there are not rows on both sides of row 1.

1.      Hold your cursor between row IDs where the hidden row is located
The cursor will change to an open, double sided arrow as shown here.

2.      Right click » select Unhide

Related Posts by Categories