To unhide rows in Excel, open the Excel worksheet, select the first hidden row on the worksheet, navigate to the Home tab, select Format, move the mouse pointer to Hide & Unhide, and press Unhide Rows. You can also unhide a row by changing the size of the cell.
- Open the Excel worksheet
Open Microsoft Excel. Click on File from the menu, and then select Open. Browse your computer to find the worksheet, click on the file, and press the Open button.
- Select the first hidden row
Go to the Name box, which is next to the Formula bar, and type "A1" in the box. Another way to select the first row is to go to the Home Tab, and press Find & Select in the Editing group. Click Go To, then type "A1" in the Reference box, and click OK to confirm.
- Navigate to the Home menu
Click on the Home tab, and select Format, which is located in the Cells group.
- Unhide the rows
From the Format menu, go to Visibility, then Hide & Unhide, and select Unhide Rows. You can also unhide a row by changing its height. From the Format Menu, select Row Height under Cell Size, and then type the desired value in the Row Height box.