How to Delete Blank Rows in Excel — Review Every Row First

What counts as a blank row in Excel?

A blank row has no value in any column of your table. A row with a missing customer name but a valid order ID is not blank, so it stays. Excel treats a cell that holds only spaces as text, so a row that looks empty may not be blank. Exports and copied tables often contain empty rows between useful records. Some are padding and some are intentional separators, so the tool shows candidate row numbers before anything is deleted. Empty cells inside rows that still hold data are a different task, covered by the blank-cells guide linked below.

How to delete blank rows in Excel safely

1. Save a copy of the workbook, then select any cell in the data you want to clean.
2. Choose Data → From Table/Range to open the data in Power Query. A plain range is converted to a table first; select My table has headers if the first row contains column names.
3. In Power Query, choose Home → Remove Rows → Remove Blank Rows. It removes only rows in which every value is empty or null; inspect the preview before you load the result.
4. Choose Home → Close & Load. The result loads to a new worksheet by default and the original data stays the same, so you can compare the two.

Why Go To Special can delete rows that contain data

Be careful with Go To Special → Blanks → Delete Entire Row: Blanks selects empty cells, including cells inside otherwise populated rows. Deleting those entire rows can remove real data. If you do not use Power Query, a helper formula such as =COUNTA(A2:F2)=0 can identify fully empty rows across your actual data columns; review the TRUE rows before deleting them. COUNTA treats spaces and formulas returning an empty string as content.

How to delete thousands of blank rows at once

Deleting empty rows one by one does not scale. In Excel, Power Query’s Remove Blank Rows removes them all in one step. Without Power Query, fill the COUNTA helper column down, filter it for TRUE and select the visible rows. Then choose Home → Find & Select → Go To Special → Visible cells only, right-click the selection and choose Delete → Entire row.

This tool finds every fully blank row in one pass, lists each candidate row number and removes them all from a cleaned copy in a single approved run. It handles CSV or XLSX files up to 10 MB, 50,000 data rows, 200 columns and 500,000 cells in your browser, and you can uncheck any row you want to keep first.

Clear extra empty rows below your data

Excel always shows empty rows below your data. They become a problem when Excel still treats them as used, usually because empty cells there carry formatting; that makes the file larger than necessary and can add printed pages.

1. Press Ctrl+End. Excel jumps to the last cell that contains data or formatting.
2. If that cell sits below your data, click the row heading of the first empty row under your data, then press Ctrl+Shift+End.
3. On the Home tab, in the Editing group, select the arrow next to Clear, then select Clear All.
4. Save and close the workbook. When you open it again, the last cell should be the last cell of your data.

Clear All removes contents and comments as well as formatting, so check that the selected rows hold nothing you need.

Review the rule before it runs

The default rule removes only rows whose cells are all empty. You may explicitly treat whitespace-only cells as empty too. Values such as 0 and false, partially populated rows and nonempty text stay. The tool cannot know whether an empty row is an intentional separator: uncheck that row in the preview to preserve it, then approve the final count.

After confirmation, download CSV or XLSX plus a PDF summary and JSON audit. The audit records the rule, removed source-row numbers, and file hashes. Your original file stays separate from the result.

Frequently asked questions