Question: how to paste multiple rows in excel?
Answer: Select the row below where you want the new rows to appear.
Right click on the highlighted row and select "Insert" from the list. ... 
To insert multiple rows, select the same number of rows that you want to insert. ... 
Then, right click inside the selected area and click "Insert" from the list.