Step 5: To view the other rows that have data, let’s remove the filter we applied. And then click on the Delete dropdown list on the top ribbon and then finally hit the Delete Sheet Rows option. You can identify this by the blue number marking on row headers. Step 4: Now you will be shown only those rows that are blank. Step 3: As next, check the checkbox corresponding to only Blanks and then hit the OK button. Click on this dropdown arrow to apply the filter.

Step 2: Now you will have a dropdown arrow associated with the column you chose. This button is present at the top right corner of your Excel window.įrom the dropdown list, click on the Filter option. Now, find and click on the button that says Sort & Filter. Step 1: Firstly, click on a column header that has blank rows present. In this method, we are going to filter out your columns based on blanks rows and then delete the results that we obtain. Step 5: There you are! All your blank rows are now gone! Or you can click on the Delete button at the top ribbon as shown in the screenshot below. To delete them, either you can right click somewhere and hit the Delete option. Step 4: If you now look at the excel sheet, you can see that all the blank rows are selected automatically. Step 3: Choose the radio button corresponding to Blanks and hit the OK button.

Step 2: In the Go To window, click on the button named Special. As next, towards the right corner of the window, find and click on the Binocular icon for Find and Select and choose Go To from the dropdown menu. Step 1: Firstly, make sure you are at the HOME tab of your excel sheet. But today, we are going to use it to hunt down the blank rows in your excel and to delete them all at once. The Go To Special feature is useful for many purposes. That’s it, all of the selected rows would now be deleted. Once all the rows to be deleted are selected, simply right click and click on the Delete option. You can even select other unwanted rows, they need not be blank to be deleted. Keep the CTRL key pressed and c lick on the heads of the blank rows that you want to delete. To manually delete the blank rows, firstly, hold down the CTRL key. But if there are only a couple of blank rows to be deleted, then manual deletion sure is something you can consider. We know no one like anything manual and that it’s all automation these days. Solution 1: By Manually Selecting and Deleting Blank Rows

Solution 5: Using Find and Replace Functionality.

Solution 2: Using Go To Special Feature.

Solution 1: By Manually Selecting and Deleting Blank Rows.

Easy way to delete empty rows in excel