How to Add or Remove Rows in Excel

One of the most critical tasks in Excel is adding or removing rows from tables. You can add or remove rows using a few simple steps.

In this guide, I am using the Office 365 version of Excel (build 2203). Other versions of Excel will have similar instructions.

How to Add Rows

For this guide, I will make a simple spreadsheet to which I will add and remove rows. The data I’m using shows the monthly sales of different items.

  1. We have a table consisting of four rows. Each row contains the name and monthly sales amount of the listed items.

    A table in excel
    A table consisting of 4 rows and 5 columns
  2. Select a row from the vertical bar. The vertical bar has the rows listed in numerical order. Select a row from the vertical bar and right-click on it to add or remove rows.
    A table in Excel
    Select a row from the vertical bar.

    Once you have found where you wish to add the new row, right-click and select Insert.

  3. The new row is added above the cell you selected.

    Table in Excel
    The new row is added above the selected row

How to add Multiple Rows

You will often need to add multiple rows in excel to complete your table.

  1. Select where you want the new rows to be added. In this case, we want new rows to be added at the third and fifth positions. Next, hold down the CTRL key on Windows (Command on Mac) and highlight the rows by left-clicking on them.
    Excel table
    Select the rows where you want the new rows to be added

     

    Excel table
    Select the consecutive rows you wish to add

    3. Right-click and select Insert to add your new rows.

    Image showing Excel table
    Select Insert to add rows
    Table in Excel
    Your new rows are added.

    Consecutive rows will be added similarly:

    Table in Excel
    Consecutive rows are added

How to Delete Rows

The process of deleting rows is similar to adding them. First, highlight the rows you wish to delete and then select Delete.

  1. Select the row you want to delete. Once you have highlighted a row, right-click and click Delete.
    Table in Excel
    Select the row to be deleted

    The deleted row will be replaced by the row below it.

    Table in Excel
    The deleted row is replaced by the row below it

How to Delete Multiple Rows

  1. Select consecutive rows by holding the left mouse button and highlighting the rows you wish to delete. Or you can highlight specific rows by holding CTRL (Command on Mac) and selecting individual rows.
    Table in Excel
    Select the rows to be deleted

    Deleted rows will be replaced by the rows below them.

    Table in Excel
    Deleted rows are replaced.

Was this article helpful?

Leave a Comment