Delete Blank Rows in Microsoft Excel

Blank rows can break filters, imports and reporting. Before deleting them, decide what “blank” means: a row can look empty but still contain a formula returning an empty string.

Safe method for a normal table

1. Make a copy of the workbook if the data is important.
2. Select the data range and turn on Data > Filter.
3. Choose a column that should always contain a value for a valid record, such as an ID or name.
4. Filter that column to (Blanks).
5. Select the visible row numbers, right-click and choose Delete Row.
6. Clear the filter and confirm the remaining row count.

Why not use Go To Special blindly?

Selecting every blank cell and deleting entire rows can remove valid records when only one optional field is empty. Filtering on a mandatory key column makes the rule explicit and easier to review.

If the sheet is generated from Power Query or another source, fix the blank-row logic in the query instead. Manual deletion will only last until the next refresh.