Insert a Row

You can Hide and Unhide the Rows as well. This little example shows you how.

 

1. Try This: Insert a Blank Row

Select Row 3.

Go to Home-> Cells-> Insert.

Click on Insert Sheet Rows.

 

 

What Do You See? A new, blank Row 3 has been inserted between Row 2 and Row 4.

 

Keep going...

Home ->Cells-> Insert ->Insert Sheet Rows

Exam 77-882: Microsoft Excel 2010 Core

2. Creating Cell Data

2.1. Construct cell data: Insert Sheet Rows