Select the same number of existing rows as the number of rows you want to insert
Right-click the selected rows
Click Insert
Use the keyboard shortcut Ctrl + Shift + +
Select entire rows before using the shortcut
Drag to select multiple row headers, then right-click and choose Insert
Use the Home tab
Click Insert in the Cells group
Choose Insert Sheet Rows
For non-adjacent rows, insert rows one at a time
To insert multiple blank rows between data, select the same number of rows below the insertion point before inserting