Question: How do I unhide row #1 in a sheet in Microsoft Excel 2016?
Answer: In this example, you can see that row 1 is hidden in the spreadsheet.
![Microsoft Excel](http://www.techonthenet.com/excel/rows/images/unhide_row1_2016_001.png)
To unhide row 1, select the Home tab from the toolbar at the top of the screen. In the Editing group, click on Find & Select button and select "Go To..." from the popup menu.
![Microsoft Excel](http://www.techonthenet.com/excel/rows/images/unhide_row1_2016_002.png)
When the GoTo window appears, enter A1 in the Reference field and click on the OK button.
![Microsoft Excel](http://www.techonthenet.com/excel/rows/images/unhide_row1_2016_003.png)
Select the Home tab from the toolbar at the top of the screen. Select Cells > Format > Hide & Unhide > Unhide Rows.
![Microsoft Excel](http://www.techonthenet.com/excel/rows/images/unhide_row1_2016_004.png)
Row 1 should now be visible in the spreadsheet.
![Microsoft Excel](http://www.techonthenet.com/excel/rows/images/unhide_row1_2016_005.png)
TIP: If you are unhiding rows 1-3 and the instructions above did not work. Try hiding rows 1-3 (even if they were hidden) and then try unhiding them again.
No comments:
Post a Comment