Insert rows

How to insert rows in Microsoft Excel?
How to insert more than one row at a time?

To insert rows, select the cells above which you want to insert rows. Go to the INSERT menu and select ROWS. Alternatively, you can RIGHT CLICK->INSERT->ENTIRE ROW to insert a row.
If you want to insert row in a single click, you should

• Select the entire row
• RIGHT CLICK ->INSERT

If you want to insert more than one row in a single click just follow the above steps ,by selecting a range of cells, rather than a single cell.

If you insert a row it is normally inserted above the cell. So if you insert a row from B2 it would be inserted above B2.

You can also repeat inserting rows by pressing CTRL+Y. But to use this option you must have insert row from the Insert menu.

Also see,
Insert columns
Delete rows
Delete columns