How To Insert More Than One Row In Excel?

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 Home tab, then click Insert, then Insert Sheet Rows

Press Ctrl + Shift + +

If prompted, choose Entire row

To insert multiple non-adjacent rows, repeat the insert process for each location

To insert rows above a selected row range, select the row headers first and then insert

Suggested for You

Trending Today