Microsoft Excel is one of the most commonly used applications to store data in table forms. It can store almost all kinds of information, and it is really easy to analyse and record numerical and statistical data using the Office 365 tool.

This article discusses how to delete rows in Microsoft Excel and how to delete blank rows using the following three methods.

Delete single row

Delete multiple rows

Delete multiple blank rows using filters

Also read: How to delete a sheet in Excel?

How to delete an entire row in Excel?

To delete an entire row in Excel, follow the steps below:

Step 1: Right-click on the row number you want to delete.

This is an image of delete entire row ss1

Step 2: In the drop-down menu, click the Delete option to delete that entire row.

This is an image of delete entire row ss2

How to delete multiple rows?

To delete multiple rows in Excel, follow the steps below:

Step 1: Select all the rows you want to delete.

This is an image of delete multiple rows ss1

Step 2: Right-click on the rows you have selected and then click on the Delete option in the drop-down menu.

Alternatively, you can press Ctrl and – (minus button) simultaneously to open the Delete box.

This is an image of delete multiple rows ss2

Step 3: In the Delete box, click on the Entire row option and then click on the OK option to delete the selected rows.

This is an image of delete multiple rows ss3 1

Both of the above method can be used to delete the blanks rows and rows with data and as well.

How to delete multiple blank rows using filters?

To delete multiple blank rows in Excel, follow the steps below:

Step 1: Select the whole table from your first-day row to your last data row, you can either do that with your mouse or press the Ctrl+Home button simultaneously and then press the Ctrl+Shift+End button simultaneously to select the whole table.

This is an image of delete rows through filters ss

Step 2: Click on the Data tab and then click on the Filter option.

This is an image of delete rows through filters ss1

Step 3: Click on the Arrowhead in your first cell and then in the filters deselect the Select All option.

This is an image of delete rows through filters ss2

Step 4: Now, checkmark the Blank option and then click on the OK button to apply the filters.

This is an image of delete rows through filters ss3

Step 5: It will now show you the blank cells, rows and columns only. Select all the blank cells, press the Ctrl+Home button simultaneously and then press the Down Arrow button to go to the first data row, after that press the Ctrl+Shift+End button to select all the blank cells.