Exam 77-420 Microsoft Excel 2013
1. Create and Manage Worksheets and Workbooks
1.4 Customize Options and Views for Worksheets and Workbooks: Hide Columns and Rows

Hide and Unhide the Rows

4. Try it: Hide the Row

Select Row 3.

Go to Home->Cells->Format ->Hide & Unhide.
Click on Hide Rows.

Look at the Row numbers. Do you see: 1, 2, 4 and 5? Row 3 is hidden.

 

Try This, Too: Unhide the Row

To see Row 3 again, select Rows 2 through 4

Go to Home ->Cells-> Format  ->Hide & Unhide.

Click on Unhide Rows.

 

What Do You See, Now? All of the Rows, including the hidden one, should be visible.

Home->Cells-> Format->Hide & Unhide->Hide Rows
graphic2
graphic1