Excel Find and Replace Shortcut: Keys, Options, and Tips

In Excel for Microsoft 365 on Windows, press Ctrl+H to open Find and Replace. Enter the text to locate and its replacement, then choose Replace to change one match or Replace All to change every match in the selected search area.

Use the shortcut and make a replacement

The shortcut opens Excel’s Replace tab, where you can specify what to find and what to put in its place. For a controlled edit, use Replace rather than Replace All: Excel changes the current match and lets you review the next one before proceeding. Replace All is faster, but it can change many cells in one action, so check the search settings first.

Press Ctrl+H.
Type the existing text in Find what and the new text in Replace with.
Choose Find Next if you want to review matches before changing them.
Select Replace to change the current match, or Replace All to update all matches within the chosen scope.
Read Excel’s result message, then inspect the affected cells.

You can also open the same tool from the ribbon: choose Home > Find & Select > Replace. To search without changing anything, press Ctrl+F or choose Find from that menu. The Find and Replace window has separate Find and Replace tabs, so you can move between locating text and editing it.

What Find and Replace changes

Find and Replace searches cell content; it is not limited to words in ordinary text cells. Depending on the selected Look in setting, a search can look at formulas, displayed values, or notes and comments. A replacement can affect text inside a cell as well as a whole-cell entry. For example, replacing North with West can turn North Region into West Region, not just replace cells whose entire contents are North.

That distinction matters when the same characters appear in different contexts. If a worksheet contains product codes such as A-10 and A-100, a broad search for A-10 might match part of the longer code. If you intend to change only cells whose entire contents match, open Options and enable Match entire cell contents. This option narrows the match; it does not mean Excel will ignore the other search settings.

Find Next moves through matches one at a time. Find All displays a list of matching cells, which is useful for checking locations before editing. In the Replace tab, Replace All reports how many replacements it made. The count is a useful confirmation, but it is still worth reviewing the result when the workbook is important.

Choose the search area and direction

By default, the search is generally confined to the active worksheet. To look across sheets, open Options and change Within from Sheet to Workbook. This is different from selecting several worksheet tabs: use the Within setting to make the intended search scope explicit. A workbook-wide Replace All can affect cells on multiple sheets, including sheets that are not currently visible.

If you select a range before opening Find and Replace, Excel can limit the search to that selection. This is handy when you only want to edit a particular table or column. Before using Replace All, verify that the selection is the one you intended; otherwise, clear the selection if you want to search the full sheet. Check the Within setting as well, because a selected range and workbook-wide scope are separate controls.

The Options area also includes Search choices such as By Rows or By Columns. These determine the order Excel uses to move through matches, not which text qualifies as a match. They rarely change the outcome of Replace All, but can make Find Next easier to follow in a large sheet. If Find All returns unexpected results, confirm the search scope and Look in setting before assuming the text is absent.

Use wildcards for patterns

Excel supports wildcard characters in the Find what field, which lets you search for a pattern rather than a single exact string. Wildcards are useful for inconsistent entries, but they can also match more cells than expected. Try a pattern with Find All first, and review the listed matches before replacing anything.

* matches any number of characters. Searching for West* can find entries that begin with West, such as West Region.
? matches one character. A search for R?D can match R1D or RED, but not R12D.
~ treats the next wildcard as a literal character. To find an actual asterisk, search for ~*; use ~? to find a question mark.

A common misconception is that an asterisk always means a literal star. In Find what, it normally acts as a wildcard, so escape it with a tilde when the symbol itself is what you need. Wildcards are for searching patterns; they do not act as special placeholders in the Replace with field. If you are changing text that contains punctuation, use Find Next to check a sample match before running Replace All.

Search formulas, values, and formatting carefully

Open Options to choose what Excel searches under Look in. When set to Formulas, the search can find text as it appears in a formula’s formula bar representation. For instance, searching for a cell reference or a word in a formula may locate formulas even when the cells display calculated numbers. Replacing text while searching formulas deserves particular care: changing part of a formula can alter its logic or make it invalid.

Values is useful when you want to search what cells display rather than inspect formula text. A displayed result may come from a formula, so locating a value does not mean it is safe to overwrite the cell. Check the formula bar and the surrounding data before replacing. Notes and comments can also be included in searches in versions that show those Look in choices; names of these options can vary as Excel’s note and comment features have changed.

Find and Replace can also search for formatting. In the dialog, use the Format control to specify formatting criteria, and use the replacement formatting controls if your aim is to change formatting rather than text. This is different from replacing a word with another word. If an old formatting criterion is unintentionally carried into a later search, clear the Find Format setting before searching again.

Prevent common replacement mistakes

The most frequent problem is replacing a short piece of text that appears inside longer words, codes, or formulas. Another is searching only the active sheet when the intended change spans a workbook, or doing the reverse and changing more sheets than intended. A few checks reduce those risks:

Use Find All to see where a broad search matches before changing anything.
Use Match case when uppercase and lowercase should be treated differently.
Use Match entire cell contents when only a complete cell entry should qualify.
Confirm Within, Look in, and any selected range before choosing Replace All.
Save a copy of an important workbook before a large or workbook-wide change.

Excel’s Undo command can often reverse a replacement if you act immediately, but do not treat that as the only backup plan. A long sequence of later actions can make it harder to return to the earlier state, and saved copies provide a safer recovery point. After replacing, spot-check both ordinary cells and important formulas, then use Find again to see whether any old text remains.

If Excel reports zero replacements, check for extra spaces, different spelling, case-sensitive matching, the wrong Look in option, or a search scope that excludes the relevant cells. A cell may also display a formatted value that differs from its underlying stored value. For example, a date’s displayed format can differ from how the underlying date is represented, so searching a visible date string may not behave as expected under every Look in setting.

When to use another tool

Find and Replace is best for direct, one-time edits to cell contents or formatting. Use Find when you need to inspect or navigate to a match without changing it. Use filters when you want to isolate rows based on a column’s values and then review a group of records. Filters do not automatically rewrite the underlying text, which makes them useful for checking a list before deciding what should change.

For repeatable cleanup, formulas can be preferable because they leave the original data intact and show the transformed result in another column. For example, a helper column can standardize a set of labels while preserving the source values for comparison. Power Query is another option for repeatable data-cleaning steps, especially when importing and reshaping data. These approaches take more setup than Ctrl+H, but they are easier to review and repeat when the source data is refreshed.

For a one-off correction such as changing an obsolete department label throughout a carefully checked sheet, Replace All may be the simplest choice. For ambiguous patterns, formula text, or a large workbook with important calculations, inspect matches first or use a reversible workflow. The right method depends on whether the priority is speed, reviewability, or repeatability.

Windows, Mac, and Excel for the web

This guide uses Excel for Microsoft 365 on Windows, where Ctrl+H opens Replace and Ctrl+F opens Find. The ribbon route is Home > Find & Select > Replace. On Excel for Mac, Control+H is the usual shortcut for Find and Replace; Command+F opens Find. If a shortcut behaves differently with your keyboard layout or Excel build, use the ribbon’s Find & Select menu instead.

Excel for the web also provides Find and Replace, but browser and keyboard behavior can affect shortcuts. If Ctrl+H opens browser history rather than Excel’s tool, use Excel’s ribbon command or its search controls instead. The same practical checks still apply: select the intended sheet or range, review search options, and inspect matches before a broad replacement. Menu labels or available options can differ slightly between desktop and web versions.

Frequently Asked Questions

What is the shortcut for Find and Replace in Excel?
In Excel for Microsoft 365 on Windows, press Ctrl+H. On Mac, Control+H is the usual shortcut. You can also use Home > Find & Select > Replace.

How do I replace only one occurrence in Excel?
Enter the old and new text in the Replace tab, then choose Find Next and Replace. This lets you review each match instead of changing every occurrence at once.

How do I replace text in the whole workbook?
Open Options in Find and Replace, set Within to Workbook, enter the text, and review the search settings before selecting Replace All. Check the resulting replacement count and inspect the affected sheets.

Can Excel Find and Replace change part of a cell?
Yes. A search can match text within a longer cell entry. Enable Match entire cell contents if the whole cell must match, or use Find Next to confirm exactly what a partial search will catch.

Why does Ctrl+H open browser history instead of Replace?
This can happen in Excel for the web because the browser may capture the shortcut. Open Find and Replace from Excel’s ribbon instead. In the Windows desktop app, Ctrl+H is the Replace shortcut.

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.