The fastest way to remove blank cells from your spreadsheet
To delete blank cells in Excel, select the range containing them, open the Edit menu, choose Delete Cells, and pick whether to shift cells left or up. This removes the empty cells and closes the gap. The method you use depends on whether your blanks are scattered throughout your data or clustered in one area, and whether you want to delete just the cells or entire rows and columns.
Excel does not have a single "delete all blanks" button. You need to either select the blanks manually, use Find & Replace to locate them, or let Excel's Go To Special feature find them for you. Each approach works best in different situations — scattered blanks need a different strategy than a whole column of empties.
Key Takeaways
- Select the range with blanks, then use Edit > Delete Cells and choose to shift cells left or up to close the gap.
- Use Go To Special (Ctrl+G, then Special) to find and select all blank cells in your range at once, then delete them together.
- If entire rows or columns are empty, right-click and choose Delete Row or Delete Column instead of using Delete Cells.
- Find & Replace can locate blanks by searching for nothing (leave the search field empty), then delete them in bulk.
- Always check your data after deleting — blanks sometimes mark important gaps, and removing them can shift your columns out of alignment.
Using Go To Special to find all blanks at once
The Go To Special feature finds every blank cell in your selected range and highlights them all, so you can delete them in one action. This is faster than clicking each blank individually. In Excel for Windows, press Ctrl+G, then click Special. In Excel for Mac, press Ctrl+Shift+G. Choose Blanks from the dialog.
Once the blanks are highlighted in blue, right-click and select Delete Cells. A small dialog appears asking whether to shift cells left, shift cells up, delete the entire row, or delete the entire column. Choose based on your data layout — if your blanks are in a column, shift left; if they are in a row, shift up. This closes the gap and removes the empty cells in seconds.
This method works best when blanks are scattered throughout a range. If you have entire empty rows or columns, it is faster to select the row or column header and delete it directly.
Deleting entire rows or columns that are empty
If a whole row or column contains nothing but blanks, delete the entire row or column rather than individual cells. Click the row number on the left (for a row) or the column letter at the top (for a column) to select it. Right-click and choose Delete. The entire row or column disappears, and the rows below or columns to the right shift up or left to fill the space.
This is cleaner than using Delete Cells when you know the row or column serves no purpose. It also prevents the misalignment that can happen when you delete individual cells — if you delete cells in one column but not others, your data can become hard to read because the rows no longer line up.
If you have multiple empty rows scattered through your sheet, select them all at once by clicking the first row number, then holding Ctrl and clicking the others. Right-click and delete them together.
Using Find & Replace to locate and remove blanks
Find & Replace can search for empty cells and delete them. Open Edit > Find & Replace (or press Ctrl+H). Leave the Find field empty and leave the Replace field empty as well. Click Replace All. This removes all blank cells in your current selection.
This method is useful when you want to delete blanks across a large range without manually selecting them first. However, it deletes the cells themselves, not the rows or columns, so you will need to choose shift direction just as you would with Delete Cells. If you want more control, click Find All first to see how many blanks exist, then use Replace one at a time to watch what happens.
Be careful with Find & Replace — it works on your entire sheet unless you select a specific range first. Always select your data range before opening Find & Replace if you only want to affect part of your spreadsheet.
Choosing between shift left and shift up
When you delete cells, Excel asks whether to shift the remaining cells left or up. The right choice depends on how your data is organized. If your blanks are in a column and you want the columns to the right to move left and close the gap, choose Shift Cells Left. If your blanks are in a row and you want the rows below to move up, choose Shift Cells Up.
Choosing wrong can scramble your data. For example, if you have a table with names in column A, ages in column B, and blank cells in column C, deleting column C's blanks with Shift Left will move the data from column D into column C — which may not exist, leaving you with misaligned rows. Think about which direction makes sense for your layout before confirming the delete.
If you are unsure, use Ctrl+Z to undo and try again. Excel's undo is reliable, so experimenting is safe.
What happens to formulas and references when you delete cells
If your spreadsheet contains formulas that reference cells you are about to delete, those formulas will break or return an error. Before deleting blanks, check whether any formulas point to the cells you are removing. You can do this by clicking a cell with a formula and looking at the formula bar — it shows which cells the formula uses.
If a formula references a blank cell you plan to delete, the formula will show #REF! after the deletion. This is Excel's way of saying the cell it was looking for no longer exists. You will need to edit the formula to point to a different cell or remove the formula entirely. This is why it is important to understand your data before deleting — a blank cell might be a placeholder for future data or part of a calculation you did not notice.
Preventing blank cells from appearing in the first place
If you find yourself regularly deleting blanks, the real problem might be how data is being entered. Blank cells often appear when people skip fields, when data is imported from another program with missing values, or when rows are deleted but not cleaned up properly. Preventing blanks is easier than removing them later.
Use Data Validation to require certain cells to have content. Select the range, go to Data > Validation, and choose Custom or Text Length. You can set rules that prevent blanks from being entered in the first place. You can also use formulas like =IF(A1="","[missing]",A1) to mark blanks with visible text instead of leaving them empty, making them easier to spot and handle intentionally.
Frequently Asked Questions
Will deleting blank cells affect my row numbers?
Yes. When you delete cells and shift up, the rows below move up and their row numbers change. If you delete entire rows, the row numbers shift down. If you only want to remove the visible blanks without changing row numbers, use a filter instead — go to Data > AutoFilter, click the column header, uncheck blanks, and you will see only non-blank rows without actually deleting anything.
Can I delete blanks from multiple columns at once?
You can select multiple columns and use Go To Special to find all blanks across them, but deleting them together can cause misalignment. It is safer to delete blanks from one column at a time, or to delete entire rows if the blanks span multiple columns in the same rows.
What if I accidentally delete cells I needed?
Press Ctrl+Z when ready to undo. Excel keeps an undo history, so you can undo multiple actions in a row. If you have already saved the file, you cannot undo past the last save, so always save a backup before deleting large numbers of cells.
How do I delete blanks but keep my column headers?
Select only the data rows, not the header row, before using Go To Special or Find & Replace. Click the first data cell, then hold Shift and click the last data cell to select only that range. Then open Go To Special and delete blanks from that selection only.