Excel: Inserting Multiple Rows
Have you ever needed to insert more than one blank row into an Excel sheet?
To insert one row, just right click on the row you want to insert a row and choose the Insert option.
To insert multiple rows, highlight as many rows as you need to insert and then right click on one of the rows and choose insert. This will add as many rows as you have highlighted into the spreadsheet, starting at the first highlighted row.
This will work even if you have data that you need to insert into multiple rows, but you actually don’t have to highlight the same number of rows first. Let’s say you have 3 rows worth of data stored in the clipboard. All you have to do it right click on the row you want to insert the data and choose Insert. It will automatically insert however many rows worth of data you had.