Excel makes it easy to hide and unhide rows using the menus. What isn’t so easy is displaying a hidden row if that row is above the first visible row in the worksheet. For instance, if you hide rows 1 through 5, Excel will dutifully follow out your instructions. If you later want to unhide any of these rows, the solution isn’t so obvious.
To unhide the top rows of a worksheet when they are hidden, follow these steps:
- Press F5. Excel displays the Go To dialog box. (See Figure 1.)
- In the Reference field at the bottom of the dialog box, enter the number of the row range that you want to unhide. For instance, if you want to unhide rows 2 through 3, enter 2:3. Likewise, if you want to unhide row 1, enter 1:1.
- Click on OK. The rows you specified are now selected, even though you cannot see it on the screen.
- Display the Home tab of the ribbon.
- In the Cells group click the Format tool.
- Hover the mouse pointer over the Hide & Unhide option and then click Unhide Rows.
Figure 1. The Go To dialog box.