Unhide top row

Ever hide one or more rows at the top of your worksheet and scratch your head when you want to unhide them? Just press the F5 key and manually enter a cell address for one of the hidden rows.

Then, click on the Format icon and choose Hide & Unhide > Unhide Rows from the Cells group on the Home tab.

If you have hidden several rows, say, 1 through 5, go to cell A1 using the steps above and unhide it. Then, just select the rows surrounding the hidden rows, 1 and  6, on the left side, right-click and choose Unhide.

Leave a Reply

Your email address will not be published. Required fields are marked *