How To Insert Rows In Excel?

Select the row below where you want the new row

Right-click the selected row

Click Insert

Or select the row and press Ctrl + Shift + +

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

Right-click the selection

Click Insert

Or go to Home

Click Insert

Click Insert Sheet Rows

To insert a row using the keyboard, use Alt + H + I + R

To insert a row in a table, right-click a cell in the table

Click Insert

Choose Table Rows Above or Table Rows Below

Suggested for You

Trending Today