How to Delete Rows in Excel

Jun 18, 2020 ยท 3 minute read

There are different methods for deleting rows in excel.

If your table was small and the number of the rows of the table were limited you can easily delete your desired rows by select and delete them.

How to Delete Rows in Excel

  • Select your desired row

  • Right-click on it.

  • Delete the row.

delete single row

If the empty rows or your desired rows are not near each other.

  • Select the first one

  • Press Ctrl and then select other rows.

  • For deleting the cells you can right-click on it and press “Delete” key.

  • Or click on the Home tab, click on the “Delete” and select “Delete Sheet Rows”.

delete rows

  • First Method

Sometimes your table has a lot of rows and columns and you have some empty rows in your table, If you want to find them manually it may take a long time, for deleting them you can follow these steps;

How to Select Blank Rows in Excel

1- Select the table.

2- Click on the Home tab.

3- Click on Find and Select.

4- Click on Go to.

5- Click on Special.

6- Choose Blank and click Ok.

find

7- Right Click on one of the rows and select “Delete”.

  • You can also click on the Home tab and click Delete and select “Delete Sheet Rows”.

del

8- Select “Shift cells up” and Press OK.

delete row

  • Second Method

Sometimes you have some blank cells in your row, but all of them are not empty. for finding empty rows in this kind of table you can follow these steps;

How to Select Blank Rows in Excel with Filter

1- Select the table by selecting the column name at the top of the sheet.

2- Click on Data tab

3- Click on the Filter.

4- At the first column click on the arrow.

filter

5- Deselect all of the items.

6- Select the Blank and press Ok.

deselect

7- In the new table, you can see some column which they have cells that are not empty.

  • Click on the arrow on that column and deselect the cells.

  • Click on Blank and press Ok.

  • Now you have empty rows in your screen.

select

8- Right Click on the row and select Delete Rows.

9- Click on Data tab and press Filter key.

10- Now you can see your table without any empty rows.

delete

  • Third Method

How to Select Blank Rows in Excel with Formula

The other method for finding empty rows in your table is using the formula.

1- In the blank column near your table write this formula;

=CountA(B3,C3,D3)

In this Formula B3,C3,D3 are the address of the cells in your desired row.

If the row has more cells you should enter the address of those cells in the formula too.

counta

2- Specify this formula for other cells of the column.

3- Select the table.

4- Click on the Data tab and click on the Filter.

5- Click on the filter arrow of the column which you specify your formula to their cells.

6- Deselect all the items.

filter cell

7- Select the Zero number and click on Ok.

8- Now you can see empty rows of your table in the screen, select them.

filter r

9- Click on the Home tab and click Delete and select “Delete Sheet Rows”.

  • You can also right-click on the selected rows and select Delete key.

delete bl

10- Click on the filter arrow of the column which you specify your formula to their cells.

11- Click on the Select All and press Ok.

12- Now you can see your table without any empty rows.

deselect tab

excel row delete