totn Excel 2011 Basics

MS Excel 2011 for Mac: Unhide row 1

This Excel tutorial explains how to unhide row 1 in Excel 2011 for Mac (with screenshots and step-by-step instructions).

Question: How do I unhide row #1 in a sheet in Microsoft Excel 2011 for Mac?

Answer: Select Edit > Go To from the menu at the top left of the screen.

Microsoft Excel

When the GoTo window appears, enter A1 in the Reference field and click on the OK button.

Microsoft Excel

Select the Home tab from the toolbar at the top of the screen. Select Actions > Format > Unhide Row.

Microsoft Excel

Row 1 should now be visible.

Microsoft Excel

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.