How To Delete Empty Rows In Excel

3.7 min read|Last Updated: February 19th, 2021|Categories: excel|
table of content

Sure, Excel is a great tool for listing, calculating, and storing your data. However, sometimes blank rows and columns in your list make it harder to focus on data and might cause some errors in your calculations. In this blog, we’ll teach you how to delete blank rows in Excel, and also how to preserve those rows which have data but include blank cells too. We’ll follow the instructions on Excel 2016, but they will work on other versions of Excel too.

If you want to delete a row, any row, in Excel, you can simply right-click on one of the cells, and in the drop-down list that appears, click on “Delete.”

right-click on one of the cells, and in the drop-down list that appears, click on “Delete.”

Then choose “Entire row,” and the whole row will be deleted:

after clicking on delete, choose “Entire row,” to delete the entire row

You can delete multiple rows just like this. Select all the rows that you want to delete, right-click on the selected area, and hit “Delete,” or simply press the Ctrl and Minus button.

There are other ways for deleting blank rows and cells in Excel. First, we are going to explain one of the easiest ways of deleting blank rows in Excel, and then we will cover one of the complete but longer methods which is very useful. We have shown both processes step by step, so that you can easily follow it up.

The Quick way to Delete Blank Rows In Excel

You can do this easily by following these few steps:

Step 1: Click on the “Find & Select” button on the Home tab and select “Go To Special” in the list that appears.

<