Excel Find and Replace Blanks: How to Fill or Clear

To fill genuinely empty cells in Excel, select the range, choose Home > Find & Select > Go To Special > Blanks, type the value, then press Ctrl+Enter. To clear cells that contain matching data, use Ctrl+H and leave Replace with empty. These are different jobs: Find and Replace is useful for removing known content, while Go To Special is the dependable way to select empty cells for filling.

What “find and replace blanks” can mean

The phrase can describe several different tasks, and the right method depends on what is actually in the cells. A cell that looks empty may be truly empty, contain a formula that displays an empty string, or contain spaces or other invisible characters. Excel treats these cases differently.

Fill empty cells: Put a value, such as “Unknown,” in cells with no content. Use Go To Special > Blanks.
Clear known contents: Remove a particular word, number, or other entry wherever it appears. Use Find and Replace and leave Replace with blank.
Clean invisible content: Remove spaces or characters that make apparently blank cells behave as if they contain data. Find and Replace or a cleanup formula may help, depending on the character.
Handle formulas showing nothing: A formula that returns an empty string is still a formula, so Excel does not classify that cell as truly blank.

First decide whether you want to fill, clear, or clean cells. Applying the wrong method can overwrite useful information or leave the apparent blanks unchanged.

Fill truly empty cells with Go To Special

In Excel for Microsoft 365 on Windows, Go To Special selects genuinely empty cells within a range. Selecting the range first is important: it limits the operation to the intended area instead of potentially selecting blank cells elsewhere on the worksheet.

Select the cells or columns where you want to fill blanks. For example, select B2:B50 to work only in that part of column B.
Choose Home > Find & Select > Go To Special.
Select Blanks, then choose OK. Excel highlights the empty cells in the selected range; other cells are not selected.
Type the replacement value. Do not click another cell after typing.
Press Ctrl+Enter. Excel enters the typed value in every selected blank cell.

For example, if B2:B50 contains a list of department names with occasional empty cells, selecting that range and entering “Not assigned” fills only its truly empty cells. Existing department names stay as they are. If the selected range has no empty cells, there is nothing for Excel to fill.

You can open the Go To dialog with Ctrl+G or F5 on Windows and choose Special there. In Excel for Mac, use the ribbon’s Home > Find & Select > Go To Special command when available; menu placement and shortcuts can vary by Mac version. In Excel for the web, the desktop Go To Special workflow may not be available in the same way, so check the commands offered in your current web interface or open the workbook in the desktop app.

Clear matching content with Find and Replace

Find and Replace is suited to removing content you can identify, not to reliably locating every genuinely empty cell. On Windows, press Ctrl+H to open Replace. Enter the text or number to remove in Find what, leave Replace with empty, and choose Replace All. In Excel for Mac, use the Replace command from the Edit or Home controls, depending on the version.

For example, if a worksheet contains the word “pending” in cells that should be cleared, searching for pending and replacing it with an empty replacement removes that matching content. If the word is part of a longer entry, Excel may remove only that portion. To remove only cells whose entire contents match, open the Find and Replace options and select Match entire cell contents before replacing.

Take care with Replace All. Review the search scope and options before confirming. Excel can search within the current sheet or the workbook, and the Look in setting affects whether it searches values or formulas. If you intend to work only in one area, select that range before opening Replace and confirm that Excel is limiting the search as intended. A broad replacement can change many more cells than expected.

Replacing with an empty value removes matching cell content, but it does not necessarily remove formatting, comments, or other cell features. If you need to remove all content and formatting from selected cells, use Home > Clear > Clear All instead. Clear All is a different operation and can remove more than just the text or number.

Why a cell that looks blank may not be empty

Several common situations make a cell appear blank while Excel still considers it occupied. This matters because Go To Special > Blanks selects cells without content, not every cell that looks empty on screen.

A formula returns an empty string: A formula such as an IF formula may display no visible text when its condition is met. The formula remains in the cell.
The cell contains spaces: One or more ordinary spaces are content, even though they are difficult to see.
The cell contains a nonbreaking space or another invisible character: These characters may arrive through copied web data and may not behave like a normal space in Find and Replace.
Formatting hides a value: A custom number format or font color can make existing content appear invisible.

To distinguish a genuinely empty cell from a formula that displays nothing, suppose A2 is the cell being checked. The formula =ISBLANK(A2) returns TRUE if A2 is truly empty and FALSE if it contains a formula, even if that formula displays an empty string. If A2 contains a formula that returns an empty string, =LEN(A2)=0 returns TRUE because the displayed text has zero characters. The second check can also return TRUE for a genuinely empty cell, so it does not by itself distinguish those two cases.

If a cell contains a space, LEN will count that character, and Go To Special will not select the cell as blank. A useful first step is to inspect the formula bar after selecting a suspicious cell. If the problem is whitespace, clean a copy or a helper column first and review the results before replacing original data.

Find and Replace options that affect results

Find and Replace has options that can change what Excel matches. Open the expanded options in the dialog and verify them before using Replace All, especially in a workbook with formulas or repeated labels.

Within: Choose whether the search applies to the sheet or the workbook. A workbook-wide replacement may affect sheets you did not intend to edit.
Search: Choose whether Excel searches by rows or columns. This usually does not change which matches are found, but it can affect the order in which you review them.
Look in: Searching values differs from searching formulas. When formulas are included, a replacement can affect formula text, so avoid broad searches that might alter calculations.
Match case: Use this when uppercase and lowercase versions should be treated differently.
Match entire cell contents: Use this to avoid replacing a matching word when it appears within a longer entry.

Before Replace All, use Find Next or Find All when available to inspect the matches. If the data is important, save a copy first or use Undo immediately if the result is wrong. Undo can reverse an ordinary replacement, but it is safer to confirm the scope before making a large change.

Common problems and safer fixes

Leaving Find what empty does not fill blanks reliably. To select empty cells for a shared value, use Go To Special. Find and Replace is designed to replace matching content; an empty search field is not a dependable substitute for selecting blank cells.

Ctrl+Enter fills selected blanks, not the entire worksheet. It enters the value into all cells currently selected. If you accidentally selected a whole column, you may fill far more cells than intended. Check the selection before typing, and use a bounded range such as B2:B500 when that matches your data.

Zero is not the same as blank. Replacing 0 with nothing can erase meaningful values, including parts of identifiers or calculations. If only cells containing exactly zero should be changed, use Match entire cell contents and inspect the affected cells first.

Spaces can defeat a blank-cell selection. If Go To Special does not select a cell that looks empty, check for spaces, a formula, or formatting that hides content. Do not blindly replace every space in a worksheet: spaces may separate names, addresses, and other valid text.

Formulas can be damaged by a broad replacement. When Look in is set to formulas, a search string may occur inside a formula even though it is not visible in the cell. Use a copy of the workbook or a narrowly selected range, and inspect matches before replacing formula text.

Choosing the right method for the job

Use Go To Special when the aim is to put the same value into truly empty cells in a selected range. It makes the target cells explicit and preserves occupied cells. Use Find and Replace when you know the content to remove or change, such as a repeated status word, an obsolete code, or a specific text fragment.

For cells that look blank because a formula returns an empty string, decide whether the formula should remain. If the formula is still needed, leave it in place; visually blank does not necessarily mean the cell should be overwritten. If the formula itself should be removed, identify the relevant formula cells carefully rather than treating them as empty cells. For whitespace or imported characters, clean a copy or helper column and compare results before replacing the source data.

A practical rule is to select and inspect a small sample before making a workbook-wide change. Check several expected matches and several cells that should remain untouched. That simple review can reveal whether the issue is empty cells, hidden content, or a search option that is too broad.

Frequently Asked Questions

Can Excel Find and Replace find empty cells?
For selecting truly empty cells, use Home > Find & Select > Go To Special > Blanks. Leaving Find what empty in Replace is not the reliable method for selecting blanks to fill.

How do I put the same word in every blank cell?
Select the intended range, choose Go To Special > Blanks, type the word, and press Ctrl+Enter on Windows. Only empty cells within the selected range receive the entry.

How do I replace a word with nothing in Excel?
Open Replace with Ctrl+H on Windows, enter the word in Find what, leave Replace with empty, check the search scope and matching options, then choose Replace All. Use Match entire cell contents if you want to remove only cells that consist of that word.

Why does Go To Special skip a cell that looks blank?
The cell may contain a formula returning an empty string, a space, an invisible character, or content hidden by formatting. Select it and inspect the formula bar; Go To Special selects cells that are actually empty.

Does replacing a value with blank remove cell formatting?
No. Replacing matching content clears the matching entry, not necessarily its formatting. To remove both content and formatting, select the cells and use Home > Clear > Clear All, checking that this broader action is intended.

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.