Exam 77-420 Microsoft Excel 2013
1. Create and Manage Worksheets and Workbooks
1.3 Format Worksheets and Workbooks: Insert and Delete Columns and Rows

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.

 

graphic3

 

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
graphic2
graphic1