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...