How to insert row(s) in an Excel Spreadsheet

Question

How to insert row(s) in an Excel Spreadsheet

Phillip Richcreek 1,080

Previously I used the built-in help feature to add a row to an Excel spreadsheet. It works fine, but it doesn't tell you how to do it, it just does it!
I expect that I will need to do it many times in the future.
Please help.

0 comments

1 answer

Your answer

Answer 1

To insert rows in an Excel worksheet, use any of these methods.

On Windows (desktop Excel)

Select a cell in the row where a new row is needed.
On the ribbon, go to Home > Insert > Insert Sheet Rows.
- This inserts a row above the selected row.
To delete a row, select a cell in that row and go to Home > Delete > Delete Sheet Rows.

Alternatively:

Right-click the row number on the left where a row should be inserted.
Select Insert to insert a row above.
To remove a row, right-click the row number and select Delete.

In Excel for the web

Right-click the whole row above which a new row is needed.
Select Insert Rows.

To insert multiple rows:

Select the same number of existing rows as the number of new rows needed, directly above where they should appear.
Right-click the selection and choose Insert Rows.

References:

Insert or delete rows and columns in Excel