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.
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.
Step 2: In the drop-down menu, click the Delete option to delete that entire row.
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.
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.
Step 3: In the Delete box, click on the Entire row option and then click on the OK option to delete the selected rows.
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.
Step 2: Click on the Data tab and then click on the Filter option.
Step 3: Click on the Arrowhead in your first cell and then in the filters deselect the Select All option.
Step 4: Now, checkmark the Blank option and then click on the OK button to apply the filters.
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.
Step 6: Right-click on the selected cells and then click on the Delete Row option in the drop-down menu.
Alternatively, you can also press Ctrl and – (minus button) simultaneously after selecting all the blank cells.
Step 7: Click the OK button in the dialog box that appears.
Step 8: Click on the Data tab and then click on the Clear option beside Filter to clear the filters.
Step 9: It will delete the blank rows for your data, but some partially empty rows will not be removed.
