How to Delete Blank Rows in an Excel Column Safely

To delete entire rows where a chosen Excel column is blank, select the data range, choose Home > Find & Select > Go To Special > Blanks, then choose Home > Delete > Delete Sheet Rows. First confirm those rows are genuinely empty records: deleting a row removes its contents from every column. If you only want to close gaps in one column, delete the blank cells and shift that column up instead—but only when it will not misalign related data.

What You’ll Need

A workbook open in Excel for Microsoft 365 on Windows.
A clear idea of whether you want to remove whole worksheet rows or only blank cells in one column.
A saved copy of the workbook, especially if the range contains important or hard-to-recreate data.
The column header or another way to identify the data range, so you do not accidentally include unrelated cells.

Step-by-Step

Save a copy and inspect the data. Use File > Save As to create a working copy if the data matters. Look across several columns in the rows that appear blank in your chosen column. If any of those rows contain a name, date, amount, note, or other information you need, do not delete the entire row just because one cell is empty. Decide whether the blank means the whole record should go, or whether you only mean to remove empty cells from that one column.
Identify the exact data range. Note the column you want to check and where its records start and end. For example, if column A has a header in A1 and entries from A2 through A500, the records to check are A2:A500. Do not include the header in the selection: a header is often text rather than a blank, but excluding it makes the operation easier to review. If there are other unrelated tables above or below the records, keep them outside the selected range.
Select the cells in the target column. Click the first data cell, then hold Shift and click the last data cell. You can also click the Name Box to the left of the formula bar, type the range such as A2:A500, and press Enter. Using a specific range is safer than selecting the entire worksheet column, because it avoids acting on distant cells or another block of data in that column.
Find blank cells in that selection. On the ribbon, choose Home > Find & Select > Go To Special. In the dialog box, select Blanks and choose OK. Excel highlights blank cells within the range you selected. Pause and inspect the highlighted cells. If the selection includes blanks in rows outside your intended records, press Esc and select a narrower range before continuing. This command selects blank cells; it does not decide whether the rest of each row is safe to remove.
Delete entire rows only when the records should be removed. If each highlighted blank marks a record that should be discarded, choose Home > Delete > Delete Sheet Rows. Excel removes each worksheet row containing a selected blank cell, including data in other columns. For a right-click alternative, right-click one of the selected blank cells and choose Delete, then select Entire row and choose OK. Do not choose this option if other information on those rows must stay.
Use cell deletion only when shifting one column is appropriate. If you intentionally want to close gaps in the selected column, keep the blank cells selected, choose Home > Delete > Delete Cells, select Shift cells up, and choose OK. This moves the cells below each blank upward in that column. It does not move neighboring columns with them, so names, dates, or values can become paired with the wrong record. Use this only for a standalone list or when you have confirmed that the other columns do not need to stay aligned.
Check the result before saving. Review the rows around each place where blanks were removed, and check that headers, totals, formulas, and related columns still make sense. If you deleted the wrong cells and have not made other changes since, press Ctrl+Z on Windows to undo. On Mac, use Command+Z. Once the result is correct, save the workbook.

For a formatted Excel Table: You can also filter the target column to show blanks, review the visible records, and delete only the rows that should go. Click the filter arrow in the column header, select only Blanks, and confirm the displayed records are safe to remove. Select the visible table rows and use the table-row deletion command available from the right-click menu or the Home tab. Clear the filter afterward to see the remaining data. Be careful to delete table rows, not just clear the blank cells, if your goal is to remove records.

On Mac or Excel for the web: The ribbon labels and dialog placement can vary slightly by platform. In Excel for Mac, use Home > Find & Select > Go To Special when available; F5 or Control+G can open Go To, depending on your keyboard settings. Excel for the web may not offer the same Go To Special workflow in every build. If you cannot find it, use a column filter to display blank entries, review the records, and delete the intended rows, or open the workbook in the desktop app.

Common Mistakes

Deleting a whole row when only one cell is blank. A blank in the key column does not prove the rest of the record is empty. Deleting the sheet row removes every cell on that row, including information in columns you did not select. Inspect the neighboring columns before using Delete Sheet Rows.
Shifting up one column in a multi-column list. This can pair a value with the wrong name or date. For example, removing a blank cell from an ID column while leaving the corresponding dates in place changes the relationships between records. Delete entire records together, or do not shift cells in a single column.
Selecting the whole column without checking the range. Go To Special acts on the selection. Selecting an entire column can include blank areas far below the table and unrelated sections. Select the actual data range, excluding headers and separate blocks.
Assuming a cell that looks empty is truly blank. A formula can return an empty-looking result, and a cell can contain spaces or other invisible characters. Go To Special > Blanks selects genuinely empty cells; it may not select cells containing formulas or spaces.
Choosing Clear Contents instead of deleting rows. Clear Contents empties cells but leaves the worksheet rows in place. If you want records removed and the remaining rows moved together, use Delete Sheet Rows or delete the relevant table rows.

Tips

Use a stable key column. A column that should always contain an ID, order number, or email address is often a better guide than a column where blank values are normal. Filter or select blanks in the key column, then inspect the complete records before deletion.
Keep the header out of the operation. For a simple range, select from the first data row to the last. For a Table, use its filter arrow so Excel recognizes the header and filters the table records rather than an arbitrary worksheet area.
Sort only if it is safe for the full dataset. Sorting a single column by itself can separate values from their related rows. If sorting to bring blanks together, select the whole data range or use a Table so each record moves as a unit.
Use filters to review before deleting. Filtering the target column to blanks makes it easier to see what will be affected. Check other columns in the visible rows, then clear the filter when finished. A filter hides records; it does not delete them until you take a separate deletion action.
Make a copy before bulk cleanup. A saved backup gives you a recovery route if you notice later that a row contained information you needed. Undo is helpful immediately, but it is not a substitute for a backup after further edits or after closing the workbook.

Troubleshooting

Go To Special selects nothing. Check that the intended range is selected and that its cells are truly empty. If cells contain formulas that display an empty string, spaces, or other invisible characters, Excel does not treat them as ordinary empty cells. Use the filter menu to inspect the column, or examine a suspicious cell in the formula bar before deciding how to handle it.

Some blank-looking rows remain after deletion. They may contain a space, a formula, formatting, or a value in another column. Check the target cells individually and look at the formula bar. If a space is the problem, remove it only after confirming it is not meaningful. If a formula returns an empty result, decide whether to keep the formula or remove the entire record; do not delete it automatically just because it looks blank.

Rows with information disappeared. If you have not made other edits, use Ctrl+Z on Windows or Command+Z on Mac immediately. If undo is no longer available, close without saving if you can safely discard all changes since the last save, or restore a previous version from your backup or version history. When repeating the cleanup, inspect every visible row in the target column before deleting whole rows.

The Delete option is unavailable or behaves differently. A protected worksheet may prevent row deletion; check Review > Unprotect Sheet if you have permission and the password if one is required. In a filtered Table, use the table-row deletion option rather than clearing contents. If the workbook is open in a browser and the Go To Special dialog is missing, use the filter approach or open it in desktop Excel.

The remaining data no longer lines up. This usually happens when cells were shifted up in just one column. Undo if possible. If you cannot undo, restore the backup or version history rather than trying to guess how to re-pair the records. For future cleanup, delete full rows or Table records so related values remain together.

Frequently Asked Questions

Can I delete blank rows based on just one column?
Yes. Select the data cells in that column and use Go To Special > Blanks. If you then choose Delete Sheet Rows, Excel deletes every worksheet row with a blank in that column. That is appropriate only when those entire records should be removed.

How do I remove blanks from a column without deleting whole rows?
Select the relevant range, choose Home > Find & Select > Go To Special > Blanks, then use Home > Delete > Delete Cells and choose Shift cells up. This compacts that column only. Do not use it when values in adjacent columns belong to the same records.

Does Go To Special find formulas that display blank?
Usually not. A cell containing a formula is not truly empty, even when its displayed result looks blank. Review such cells separately and decide whether to keep the formula, clear it, or delete the associated record.

Will filtering blanks delete the rows automatically?
No. A filter only hides rows that do not match the selected criterion and displays the blank entries. You must still select the intended visible records and delete their rows. Review the other columns before doing so.

Can I undo deleting blank rows?
Use Ctrl+Z on Windows or Command+Z on Mac if the deletion is still in the undo history. If you have continued editing or closed the workbook, undo may not be available. A saved copy or workbook version history is the safer recovery option.

Can I use these steps in Excel for the web?
Filtering a column and deleting selected records may be available, but Go To Special can differ by build. If you do not see the command, use the filter method or open the workbook in Excel for Microsoft 365 on Windows or Mac.

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.