Find Blank Cells in Excel and Fill Them With Zero

To find blank cells in an Excel range and fill them with zero, select the range, choose Home > Find & Select > Go To Special > Blanks, type 0, then press Ctrl+Enter on Windows. Excel enters zero in every selected blank cell while leaving the cells that already contain data unchanged.

Quick method: select blanks and enter zero

This method is usually the quickest way to fill actual empty cells directly in a worksheet. First decide which part of the sheet should be changed: a column, a rectangular range, or a deliberately selected group of cells. Selecting a limited range is safer than selecting the entire worksheet, especially if the sheet contains notes or unused areas where blanks should remain blank.

Select the cells you want Excel to check. For example, select B2:B100 if the values belong in column B.
On the ribbon, choose Home > Find & Select > Go To Special.
Choose Blanks, then select OK. Excel highlights the empty cells within the selected range.
Type 0. Do not click another cell or press Enter first.
Press Ctrl+Enter to put zero in all the selected blank cells at once.

On Windows, you can open Go To Special with F5 or Ctrl+G, choose Special, and then select Blanks. In Excel for Mac, use the ribbon’s Home > Find & Select > Go To Special command where available; the equivalent multi-cell entry shortcut is generally Control+Return. Keyboard behavior can vary with Mac settings and keyboard layout, so use the ribbon command if a shortcut does not work.

What Excel considers a blank cell

Go To Special selects cells that are genuinely empty. It does not mean every cell that looks empty on screen. This distinction matters because a cell may appear blank while containing a formula, a space character, or other content.

Truly empty cell: It contains no value or formula. Go To Special > Blanks selects it.
Formula returning an empty string: A formula such as one that displays an empty result is still in the cell, so Go To Special does not treat it as a genuinely empty cell.
Space character: A cell containing one or more spaces is not blank, even if the spaces are hard to see.
Cell containing zero: Zero is a value, not a blank. The command will not replace it.
Empty-looking cell with formatting: Formatting alone does not put a value into a cell, so a formatted but otherwise empty cell can still be selected as blank.

If the cells look empty but are not selected, inspect a few of them by clicking a cell and checking the formula bar. A visible formula or an invisible-looking space explains why the cell was not included. Avoid treating a displayed blank and a genuinely empty cell as interchangeable: formulas and data tools can handle them differently.

Choose the right range before filling

The result depends on the range you select before opening Go To Special. Excel searches only within that selection. If you select B2:B100, it will not change blanks elsewhere in the worksheet. This is useful when a sheet has several tables or when blank cells outside the data area should stay untouched.

For a table with headings in row 1, select the data rows rather than the heading row. For example, if column C contains amounts from row 2 through row 250, select C2:C250. If you select whole columns, Excel may process a very large range, and it may fill empty cells below the data as well. That can make later worksheet operations less convenient and can make the sheet appear to contain more used data than intended.

Before applying the change, consider why the cells are blank. A blank in a data-entry table might mean zero, but it might also mean unknown, not applicable, or not yet recorded. For example, replacing missing survey responses with zero could misrepresent the data. Confirm that zero is the correct meaning for the particular column, not merely a convenient way to remove empty cells.

What happens when you press Ctrl+Enter

After Go To Special selects the blanks, typing 0 places that entry in Excel’s input line, but it does not by itself commit the value to every selected cell. Ctrl+Enter commits the entry to the entire selection. Pressing Enter instead generally enters the value in the active cell and moves the selection, which is not the intended bulk-fill action.

The inserted zero is a numeric value, not the text character “0.” That distinction is useful for addition, averages, sorting, and other calculations. For instance, if a blank in a quantity column is meant to represent no items, a numeric zero can be included in arithmetic. Excel may display the zero according to the cell’s number format, however, so a format that hides zero values can make the updated cell still look blank. Check the formula bar or change the number format if you need to verify what is stored.

If the selected cells are spread across multiple areas, Ctrl+Enter can enter the value in all selected cells. Still, examine the highlighted selection before typing: an accidental selection that includes cells outside the intended data area can change more than expected. If the result is wrong, use Undo immediately with Ctrl+Z on Windows; on Mac, use Command+Z.

Use a formula when you want to preserve the source

If you need to show zero for blank inputs without changing the original cells, create a formula in a separate output column. For example, with source values in A2:A5 and the results intended for B2:B5, enter this formula in B2 and fill it down through B5:

=IF(A2="",0,A2)

For the illustrative source values 12, a truly empty cell, 0, and 8 in A2:A5, the results in B2:B5 are 12, 0, 0, and 8. The formula preserves existing values and supplies zero when the source is empty. It also treats a formula result of an empty string as matching the test, which is different from Go To Special’s selection of genuinely empty cells. A cell containing spaces does not match this empty-string test.

To fill the formula down, select B2:B5 and press Ctrl+D on Windows, or use Home > Fill > Down. On Mac, Command+D is commonly the Fill Down shortcut. If you later need fixed results rather than formulas, copy the output cells and use Paste Special > Values in the destination. Keep the source column until you have checked the results; formulas refer back to it, so deleting or changing the source can alter the output.

Common problems and how to avoid them

Blanks were not selected: The cells may contain formulas returning empty text or spaces. Check the formula bar and use a formula-based approach if those should also become zero.
Only one cell changed: Make sure you pressed Ctrl+Enter on Windows, rather than Enter. On Mac, try Control+Return or use the ribbon workflow.
Zeros do not appear: A custom number format or a worksheet setting may hide displayed zeros. Check the cell’s stored value and number format before repeating the fill.
Unexpected cells changed: Undo, reselect only the intended data range, and inspect the highlighted blanks before committing the entry.
The range includes filtered or hidden rows: Do not assume a normal selection will change only the rows currently visible. Check the selected cells carefully, particularly when working with filtered data, and test the operation on a small range or a copy first.

Find and Replace is usually not the right tool for this task. A blank cell is not ordinary text that can reliably be targeted by entering nothing in the Find field, and a broad replacement can have unintended effects. Go To Special explicitly selects empty cells within a chosen range, making it easier to control what gets filled.

Which method should you use?

Use Go To Special when you want to change genuinely empty cells in place and know that zero is the correct value. It is direct, works on a selected range, and leaves existing values alone. Use a formula when you want to retain the original data, when blank-looking formula results should also display as zero, or when you want a separate cleaned result for reporting.

These approaches serve different purposes: the direct fill changes the worksheet’s stored data, while the formula creates a calculated view alongside the source. Neither method automatically determines whether a missing value should mean zero. In a report, a blank can communicate “not supplied,” whereas zero communicates a measured or confirmed amount of none. Choose based on the meaning of the field and the requirements of the analysis.

Frequently Asked Questions

Can I fill every blank in the entire Excel worksheet with zero?
Yes. Select the worksheet and use Go To Special > Blanks, then enter zero and press Ctrl+Enter on Windows. This can affect a very large number of empty cells, so it is usually safer to select only the data area you intend to change.

Will this replace cells that already contain zero?
No. Go To Special > Blanks selects empty cells, not cells containing zero or other values. Existing zeros remain unchanged.

Does Go To Special find formulas that display nothing?
No. A cell containing a formula is not genuinely empty, even if the formula displays a blank-looking result. A formula such as =IF(A2="",0,A2) can return zero for an empty-string result while leaving the source unchanged.

Can I use this method on multiple columns?
Yes. Select the intended rectangular range, including the columns you want checked, and then choose Blanks. Excel fills the selected empty cells in that range; it does not fill cells outside the selection.

Will filling blanks with zero change the formatting?
Entering zero does not ordinarily remove the cell’s existing formatting. A format that suppresses zero values can still make the cell look empty, so check the number format if the result is not visible.

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.