Recommended Free Tools
iTechGuides is reader-supported. When you buy through links on our site, we may earn an affiliate commission. As an Amazon Associate I earn from qualifying purchases. Learn more
To delete blank rows in Excel safely, first find candidate rows, confirm that every relevant cell in each row is empty, then delete the entire rows. A blank in one column is not proof that the record is empty. For a repeatable cleanup, Power Query’s Remove Blank Rows command checks rows as records; filtering and Go To Special are useful for inspecting candidates, but neither makes that check for you.
Before you delete anything, check the full data range
Work inside the intended list or table, not across an entire worksheet by default. Confirm the range boundaries and display any hidden rows or columns before editing: hidden cells may contain data that is easy to overlook and could be deleted inadvertently. Microsoft explains how to organize worksheet data and warns about hidden data in its worksheet data guidance.
If you are about to make a bulk deletion, keeping a recoverable copy first is a prudent precaution. Then decide what “blank” means for this list: empty across every relevant column, or empty in one specific field. Those are different criteria.
Do these 3 things before closing this tab:
1Repair Windows errors before they cause bigger problems2Fix the driver behind crashes, sound loss and screen glitches3Clear out junk files and repair common Windows errorsChoose a method based on what you mean by blank
- One-time review: Use Go To Special to select blank cells in a bounded range, then inspect each candidate row before deleting.
- Candidate review by field: Filter a dependable column for blanks, then inspect the full visible rows. This hides records temporarily; it does not delete them.
- Repeatable whole-row cleanup: In Power Query, use Remove Blank Rows when the requirement is that the record is empty across the row.
- Keep the source unchanged: Use FILTER to return a cleaned view as a dynamic array, with a condition that checks the columns that matter.
Use Go To Special to find blank cells in a range
This Microsoft-documented path is for Excel for Windows. It selects blank cells; it does not determine that their entire rows are empty.
- Select the bounded data range you want to check.
- On the Home tab, choose Find & Select > Go To, or press Ctrl+G.
- Choose Special, select Blanks, and confirm.
- Inspect each selected blank cell in the context of its row, across all relevant columns.
- Only after verifying that a candidate row is entirely empty, select and delete that whole row. Leave rows containing any needed value in place.
Microsoft’s Go To Special instructions describe selecting blank cells, not a universal safe-delete operation for whole rows. If a record has a blank in one column but data in another, deleting the row would remove that data.
Filter a column to inspect blank-field candidates
Filtering can make candidate records easier to review in a structured range or table. Use a column whose blank values help identify candidates, but do not assume that a blank in that field means the whole row is blank.
- Select a cell in the list or table.
- Choose Data > Filter.
- Open the filter menu for the chosen column and select its blank value.
- Check every visible candidate across the other relevant columns. Delete only rows that are empty across the whole record.
- Clear the filter to display the remaining records again.
Microsoft documents filtering ranges and tables in Excel for Windows, Mac, and the web. A filter temporarily hides rows that do not match; it does not remove them. To show all records again, clear the filter using Microsoft’s clear-filter instructions.
Remove wholly blank rows in Power Query
For a cleanup you expect to repeat, Power Query offers a whole-row operation. In the query editor, choose Home > Remove Rows > Remove Blank Rows. Microsoft describes this command as checking a row as a record. It is distinct from removing null or blank values in one selected column, so confirm that the whole-row rule matches your intended definition of empty.
Rank #3
Review the query output before loading it back to the worksheet. Microsoft’s Power Query guidance describes both blank-row removal and column-specific removal, which have different effects.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.Return a cleaned view with FILTER instead of deleting source rows
If you want to preserve the original list, Excel’s FILTER function can return matching rows as a dynamic array. The formula creates an output view; it does not physically delete rows from the source. Its include argument must test the columns that define a truly empty record. If it checks only one key column, rows with data elsewhere may be excluded from the result.
See Microsoft’s FILTER function documentation for the function’s arguments and behavior.
Quick Recap
Common mistakes to avoid
- Deleting based on one blank cell: The row may contain other values. Check all relevant columns first.
- Assuming a filter removes records: Filtering hides nonmatching rows until the filter is cleared.
- Running a whole-row cleanup when you mean one-column cleanup: Power Query has separate operations; choose according to the rule you need.
- Editing while data is hidden: Unhide rows and columns first so the full record range is visible.
- Using a formula as though it edits the source: FILTER returns a result array and leaves the source rows intact.
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
