To insert a new row, left-click in a cell above the row where you want to insert a new row. See Diagram below.
Click on the ‘Home’ tab
Click on the ‘Insert’ command
Click on the down arrow next to the ‘Insert’ command
A drop down box will appear
When it does click on the ‘Insert Sheet Rows’ command
Excel will insert a new row for you.
Lesson 18: How to insert a column