How To Insert A Row In Excel?

Select the row below where you want the new row to appear

Right-click the selected row number

Click Insert

Or, select the row and press Ctrl + Shift + +

Or, go to the Home tab

Click Insert in the Cells group

Choose Insert Sheet Rows

To insert multiple rows, select the same number of existing rows first

Then use Insert to add the same number of new rows