As you can see, this leaves a few rows that have blanks in column A but data in other rows. We’ll repeat the filtering for blanks in columns B and C to get rid of those rows: Now, select the filtered rows, and click Delete > Delete Sheet Rows in the Home tab.
Select ” Blanks” and click OK. Excel has now selected all of the blank cells in the column. Now carefully right-mouse click on one of the empty cells, and choose Delete from the menu. Then select Entire row, and click the OK button.
If you want to quickly and easily remove all blank rows in selection, active sheet, selected sheets or the whole workbook without any wrong deletion，you can try the Delete Blank Rows tool of Kutools for Excel, which can handle jobs with one click without VBA code and helper column.
How to delete all blanks in Excel Office 365?
Click on ‘Special’. “Go to special” dialog box appears, click the ‘Blanks’ radio button and press OK. You can see all the blank cells selected immediately, where you’ll see all the blank cells or rows will be highlighted. Now on the Home tab, In the cells section, click on Delete and then choose Delete Sheet Rows.
In the Go To Special dialog, check Blanks option. Click OK, now all blank cells in the selection have been selected. Click Home tab, in the Cells group, click Delete > Delete Sheet Rows. Now the rows with blank cells have been removed.
How to remove empty rows with go to special in Excel?
Now please do as below steps to remove empty rows with Go To Special rows: 1. Select the range you want to remove blank rows, click Home tab, then in Editing group, click Find & Select > Go To Special. Click OK, now all blank cells in the selection have been selected. Click Home tab, in the Cells group, click Delete > Delete Sheet Rows.
How do I remove a row in Excel without losing data?
In the “Cells” section of the “Home” tab, click “Delete” and then select “Delete Sheet Rows” from the drop-down menu. All the blank rows are removed and the remaining rows are now contiguous.
How do I remove a row from a table in Excel?
Right-click on any of the selected cells and click on ‘Delete Row’ In the dialog box that opens, click on OK. At this point, you will see no records in the dataset. Click the Data tab and click on the Filter icon.