Right-click anywhere in the area you just highlighted.

For example, if you need to add five rows, drag your cursor down until you have five rows highlighted.

Without releasing your click, drag your cursor down to highlight the number of rows you need to add.

Doing this will highlight the whole row on the sheet.Click and hold your mouse on the number to the left of the row where you want to add more rows.Rather than right-clicking and inserting the row then repeating the process over and over to insert more than one row, you can do add multiple rows at once in a few easy steps. It also makes you more efficient to add more than one row at a time. You can add the rows above or below the area you are using to insert them. When you insert more than one row you have a lot more control as to where the rows go. You also cannot control if it is above or below the cell you selected.

Now when you do it this way you do not have the option of adding more than one row. Your new row will show up above the cell you selected.Right-click on the cell where you want to add information.It would be easier to insert a new row right where you want the additional information to go. But that’s certainly not the most efficient way to do it. You could just add the data at the bottom and then reorganize your sheet. Sometimes you need to add information to your sheet.

How to add multiple rows in excel