Excel 2010

How to Display a Hidden First Row in Excel

Excel is such a great program and it makes it so easy to hide and unhide rows in our worksheets, using the menus.

What isn‘t very easy is displaying a hidden row if that row happens to be the first visible row in your worksheet. (i.e., if you hide rows 1 through 5 of your worksheet, Excel will obey your instructions). If you decide later that you would like to unhide any of these rows, however, it is not very intuitive as to how you should go about that!

Follow the steps below to learn how to unhide the top rows of your worksheet when they are hidden:

  1. Click F5 to display the Go To dialog box.

Go To

  1. In the Reference field at the bottom of the dialog box, enter the number of the row range that you would like to unhide. (i.e., if you would like to unhide rows 3 through 4, key in 3:4). By the same token, if you would like to unhide row 1, you would key in 1:1.
  2. Click on OK. The rows you specified are now selected. You will not see it on your screen but they are.
  3. From the Format menu, select Row and then Unhide.