How to Delete Blank Rows in an Excel Table Safely

To delete blank rows in an Excel table, first identify rows that are genuinely empty, then remove the table rows rather than clearing individual cells. If a column is required for every record, filter that column for blanks; otherwise, add a temporary helper column to flag rows with no content, filter for the flagged rows, and delete them. Save a copy first if the data matters, because deleting rows changes the table and can affect formulas or references.

What You’ll Need

A workbook open in Excel for Microsoft 365 on Windows, with the data formatted as a table. Click inside the data; if the Table Design tab appears and the headers have filter arrows, it is a table.
A clear definition of what counts as blank. A row with an empty required field is not necessarily an entirely empty row; check whether other cells contain useful information before deleting it.
For the helper-column method, know the first and last columns of the table. You can also make a backup by using File > Save As and saving a separate copy.

Step-by-Step

Check the table and protect the original data. Click any cell in the table and confirm that Table Design appears on the ribbon. If you do not see it, the range may not be an Excel table; the filtering approach can still work on a range, but table-specific delete commands may not appear. Consider saving a copy before removing many rows. If the table has totals, formulas, or links to other sheets, note how they are set up so you can check them afterward.
Decide which rows are truly empty. Look at several suspected blank rows across every column, not just the first one. A row can look empty because its important field is blank while a notes, date, or status cell still contains data. Also check for formulas that display nothing: a cell containing a formula that returns an empty string is not necessarily a truly empty cell. Decide whether those formula-only rows should stay or be removed, and apply the same rule consistently.
Use a required column if one exists. If every valid record must have a value in a particular column, use that column to find candidate blank rows. For example, an order table might require an Order ID. Open the filter arrow in that column’s header, clear Select All, select (Blanks), and choose OK. Review the visible records before deleting anything. This method is quick, but it finds rows with a blank Order ID, not necessarily rows that are empty across every column. If any visible row has useful information elsewhere, keep it and use the helper-column method instead.
For a table without a reliable required column, add a helper column. Add a new column at the right edge of the table and give it a clear temporary header such as Blank check. In this example, the table’s data occupies A2:D100, with headers in row 1, and the helper column is E. In E2, enter =COUNTA(A2:D2). The result is 0 when all four cells in that row are genuinely empty; if A2:D2 contains three nonempty cells, the result is 3. Because the formula is entered in a table column, Excel will usually fill it down the column automatically. If it does not, copy it down through the table’s data rows. Adjust the cell references to match your own table, and do not include the helper column in the counted range.
Filter the helper column to show only empty records. Open the Blank check filter arrow, clear Select All, select 0, and click OK. Inspect the displayed rows across the full width of the table. A zero means the cells in the range you counted are empty; it does not mean that every cell in the workbook row is empty. If you see a record that should be retained, check that the formula range covers all of the table’s data columns and that the row really follows your definition of blank.
Select only the displayed table rows. Do not select the worksheet’s entire row numbers or delete individual cells; either action can affect data outside the table or shift cells into the wrong columns. Select the visible data cells for the rows shown by the filter, without including the header or totals row. To avoid including hidden rows in a filtered selection, use Home > Find & Select > Go To Special, choose Visible cells only, and click OK. Check the selection before proceeding. If you cannot confidently select just the displayed records, clear the filter, sort the helper column so the zeros are together, and select the contiguous group of blank records instead.
Delete table rows, not cell contents. With the intended table data rows selected, choose Home > Delete > Delete Table Rows. Depending on your Excel window and selection, you may also be able to right-click within the selected table rows and choose Delete > Table Rows. Do not choose Clear Contents, which leaves empty rows behind, or Delete Cells, which can shift cells and misalign records. If the table has a totals row, make sure it is not part of the selection.
Restore the full table and check the result. Clear the filter using the header arrow and choose Clear Filter From, or select all values again. Confirm that the blank records are gone, the remaining records are intact, and totals or formulas still calculate as expected. Delete the temporary Blank check column by right-clicking its table header and choosing Delete > Table Columns. Save the workbook. If you removed the wrong rows, use Ctrl+Z immediately on Windows; on Mac, use Command+Z. Undo may not be available after closing the workbook or performing other actions, which is why a saved copy is useful.

Mac and Excel for the web: The basic filtering idea is the same in Excel for Mac and Excel for the web, although ribbon labels or menus can vary slightly. In Excel for the web, use the table header filters and delete the selected table rows using the available row or table menu. If the delete option is missing or the selection is unclear, open the workbook in the desktop app before removing a large set of filtered rows. On a Mac, use Command+Z rather than Ctrl+Z to undo.

Common Mistakes

Filtering a column that is not mandatory. Filtering for blanks in one field can show incomplete but useful records. Review other columns before deleting those rows, or use a helper column that checks the entire data range.
Selecting blank cells and deleting them. A table row can contain some blanks without being an empty record. Selecting blank cells and pressing Delete may clear content, while deleting cells can shift neighboring values. Delete whole table rows only after checking each candidate row.
Including the header or totals row. The table header is needed for labels and filters, and a totals row may contain formulas. Keep both outside the selection. If you are unsure, remove the filter and identify the data rows carefully before deleting.
Counting the helper column in its own formula. If the helper formula checks a range that includes its own cell, it can create a circular reference. Count only the original data columns, such as A:D in the example.
Assuming a cell that looks empty is empty. Spaces, formulas returning an empty string, and formatting can make a cell appear blank even though it contains something. Use the formula bar to inspect suspicious cells before deciding whether to remove their rows.

Tips

Use a required identifier column for the fastest cleanup when your rule is simply that every valid record must have an identifier. Use the helper method when the rule is that every data cell in the row must be empty.
Keep the helper column until you have checked the result. It makes it easier to review which rows were classified as empty and to correct the formula if a column was missed.
If row order is important, filtering and deleting the flagged records preserves the order of the remaining records. If you choose to sort the helper column to group blank rows, add a temporary index column first so you can restore the original order afterward.
Before deleting, check for merged cells, hidden columns, and data immediately beside the table. Excel tables normally keep their records together, but a quick check helps prevent accidental changes to nearby information.
For repeat cleanup, save the workbook with a clear process note describing which columns define an empty row. A consistent rule helps prevent one person from deleting incomplete records that another person needs to retain.

Troubleshooting

The filter does not show (Blanks) or 0. Check that the filter is applied to the table’s actual data column and that the table includes the rows you expect. A cell containing a space or a formula may not count as truly empty. For the helper method, verify that the formula starts on the first data row, covers every original data column, and is filled down. If Excel displays a formula error or a circular reference, check that the helper column itself is not part of the counted range.

Rows with visible data are marked as empty. The helper formula may not include all of the table’s data columns. For instance, if your records span A:F but the formula checks only A:D, a row containing information in E or F could be marked 0. Edit the formula to cover the complete original data range, then check the results again before deleting.

Rows that look blank are not marked 0. Inspect the row for spaces, hidden values, or formulas that return an empty string. COUNTA counts cells containing formulas even when their displayed result looks blank. If those formula cells should count as empty for your cleanup, do not delete based on the COUNTA result alone. Review the affected rows and decide whether to remove the formulas or use a different rule suited to the workbook’s data.

The delete command is unavailable or the wrong cells disappear. Confirm that the selection is inside the table’s data body, not only in the worksheet around it, and that you chose Delete Table Rows rather than Delete Cells or Clear Contents. If filters make the selection difficult to verify, cancel the operation, clear the filter, and sort the helper column so the zero rows are consecutive. Then select only those table records and delete them. Use Undo at once if the result is wrong, and restore the saved copy if undo is no longer available.

The table still has empty space after deletion. Check whether the rows are truly part of the table or merely blank worksheet rows below it. Deleting table records removes them from the table; it does not remove every unused worksheet row. If empty rows remain inside the table, repeat the identification process and delete those table rows rather than clearing their contents.

Frequently Asked Questions

Can I delete blank rows in an Excel table without a formula?
Yes. Filter a column that every valid record must fill, select the blank entries, review the resulting rows, and delete only the table rows that are genuinely empty. Use a helper column when no single field reliably identifies an empty record.

Does filtering for blanks delete the rows automatically?
No. Filtering only hides records that do not match the filter. You must select the displayed candidate rows and use Delete Table Rows, then clear the filter to see the remaining table.

Will deleting blank table rows affect formulas?
It can change formulas or references that depend on the deleted records. Table formulas and totals often adjust to the remaining data, but check important calculations, charts, and linked worksheets after deleting rows. Save a separate copy first if the workbook is important.

What if a row has one blank cell but other data?
Keep it if the row is a valid, incomplete, or partially populated record. A blank in one column is not the same as an entirely empty row. Use a helper check across all data columns and review the results before removing anything.

Can I use Go To Special to delete all blank cells?
Go To Special can select blank cells, but deleting those cells is risky because the selection may include blanks in otherwise valid records. It is safer to identify complete blank records first, then delete whole table rows. Never use Delete Cells if it would shift the remaining values out of alignment.

Does this method work in Excel for Mac or the web?
The filter and helper-column methods also work in Excel for Mac and Excel for the web, though the menu labels and selection behavior can differ. If you cannot confirm that only the intended table records are selected, use the desktop app or save a copy before continuing.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.