Hide and Unhide the Rows

4. Try it: Hide the Row

Select Row 3.

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

Click on Hide Row.

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

Exam 77-882: Microsoft Excel 2010 Core

3. Formatting Cells and Worksheets

3.4. Hide and unhide rows and columns: Hide and Unhide Rows