Remove empty rows that contain only blank cells
Using this method, a row is only considered blank if there are only empty cells in the row.
As you can see in this data set, only one row is completely blank, while the other two highlighted rows are partially blank.
This method removes the entire row 6 – but not row number 2 and 4.
Step 1) Select columns A, B, and C by dragging the cursor from A to C while holding down the left mouse button.
Step 2) Go to the Data tab and click the Filter button.
Now, you can see the filter buttons next to each of the column headers.
Step 3) Click the Filter button in column A. Then clear all the checkmarks by unchecking the (Select All) checkbox.
Step 4) Put a checkmark in the (Blanks) checkbox at the bottom and click OK.
Now, only rows that have empty cells in column A are visible.
Step 5) Repeat steps 3 and 4 for columns B and C.
This leaves only rows that are 100% empty.
Your file should look like this by now:
Step 6) Now select all the blank rows. Drag the cursor from the top visible row to the bottom visible row while holding down the left mouse button.
Step 7) In the Home tab, click the drop-down arrow below the Delete button and select Delete Sheet Rows.
Step 8) In the Data tab, remove the filter by clicking the Filter button again.
And your blank rows are gone! Well done🏆
Note that you deleted all rows that contained only blank cells.
The rows that are partially empty are still visible👀
If you want to remove them too, check out method 2 below.