Excel Find and Replace Shortcut: Ctrl+H Explained

In Excel for Microsoft 365 on Windows, press Ctrl+H to open Find and Replace directly on the Replace tab. Enter the text to search for and its replacement, then choose Replace to handle one match at a time or Replace All to change every match in the selected search scope.

What Ctrl+H does in Excel

Ctrl+H opens Excel’s Find and Replace dialog, a built-in way to locate text or numbers and substitute something else. It is useful for corrections, consistent labels, and bulk edits—for example, changing every instance of the department label North to Northeast. The shortcut opens the dialog; it does not make a replacement by itself. You still choose what to find, what to use instead, and whether to replace one result or all results.

The related shortcut is Ctrl+F, which opens the same dialog on its Find tab. Use Find when you want to locate or inspect matches without changing them. Use Ctrl+H when you intend to replace content. Both shortcuts work in Excel for Microsoft 365 on Windows, and the dialog also has ribbon commands if you prefer not to use the keyboard.

How to replace text step by step

For a controlled replacement, search first and review the results before applying a workbook-wide change. In Excel for Windows, follow these steps:

Decide whether to search the current worksheet or the whole workbook. If the change should affect only part of a sheet, select the relevant cells first.
Press Ctrl+H. Excel opens the Find and Replace dialog on the Replace tab.
Type the existing text, number, or other target in Find what.
Type the intended replacement in Replace with. Leave this box empty only when you deliberately want to remove the matched content.
Check the search options and scope. If you are unsure how many cells will match, select Find All or use Find Next before replacing.
Choose Replace to review and change matches individually, or Replace All to apply the change throughout the specified scope.

After Replace All, Excel reports how many replacements it made. Read that count: if it is unexpectedly large or zero, undo immediately with Ctrl+Z and check your search term and options before trying again. A replacement can change cell contents, so verify a few affected cells and any dependent results before saving or sharing the workbook.

Find versus Replace: which command to use

Find and Replace are closely related, but their purposes differ. Find helps you navigate to occurrences, check whether a value exists, or inspect a list of matches. Replace changes the content that matches the search. A common safe workflow is to use Find first, especially when the search term is short or appears in many different contexts, and then use Replace only after you understand what will match.

For example, searching for the word May may locate the month in a date label, a person’s name, or a longer word. Replacing every match with June could therefore change more than the intended month labels. Selecting Match entire cell contents can limit the search to cells whose complete contents are May. It will not match May inside a longer entry such as May sales.

Find All can display matching cells in a results list, while Find Next moves through matches one at a time. These are useful checks when replacement scope matters. If you only need to jump to a known value and do not want to edit it, Ctrl+F is the more direct choice.

Choose the worksheet, workbook, or selected cells

Excel’s search scope controls where it looks. By default, Find and Replace generally searches the active worksheet. In the dialog’s options, Within lets you choose between Sheet and Workbook. Workbook scope is helpful when a term appears across several tabs, but it also increases the chance of changing cells you have not reviewed.

You can narrow a search by selecting a range of cells before opening Find and Replace. This is useful when you want to update one table without affecting similar labels elsewhere on the sheet. Confirm that the intended range is selected; if no range is selected, Excel searches the active sheet or workbook according to the Within setting. A selection can also be less obvious than it appears if it contains nonadjacent cells.

The dialog includes a Search setting for searching by rows or columns. This affects the order Excel follows as it moves through matches, not which values qualify. For most replacements, the default order is fine. The more consequential settings are the sheet or workbook scope and what Excel is set to look in.

Search options that change the results

Select Options in the Find and Replace dialog to see additional controls. Their current settings can affect later searches, so if Excel seems to miss an obvious match or finds too many, inspect these before changing the search term.

Look in: Choose what Excel searches, such as formulas or values. Searching formulas can find text used in a formula’s expression; searching values looks at the displayed or calculated cell results. The available choices can vary depending on the context and Excel version.
Match case: Turn this on when uppercase and lowercase letters should count as different. Leave it off when capitalization should not limit the search.
Match entire cell contents: Turn this on to find cells whose whole contents match the search term, rather than cells containing it as part of a longer entry.
Format: Find and Replace can also search for cells with specified formatting, and replacement options can apply formatting. If a text search behaves unexpectedly, check whether a format condition is active and clear it when it is not needed.

One easily overlooked issue is that Excel can retain Find and Replace settings between uses. A prior search may have left Match case or Match entire cell contents enabled. When a familiar term suddenly produces different results, inspect the options instead of assuming the workbook’s data has changed.

Examples: useful replacements and risky ones

Find and Replace is effective when the target is distinctive and the desired change is consistent. Suppose a worksheet has the label Qtr 1 repeated in several cells and the label should read Quarter 1. Enter Qtr 1 in Find what and Quarter 1 in Replace with. If only one tab should change, leave the scope on Sheet; if all tabs should change, select Workbook and verify the replacement count.

It can also correct a repeated spelling error or standardize a code in a selected range. For instance, if a list uses the exact status Pending review and the approved label is Awaiting review, use Match entire cell contents if you only want cells containing that exact phrase changed. Without that option, a cell containing Pending review from supplier may also match and be altered as part of the longer text.

Be cautious with short strings, numbers, and punctuation. Replacing 1 can affect 10, 21, or another entry containing that digit if whole-cell matching is off. Replacing a slash or hyphen may alter dates, identifiers, or URLs. If a replacement could alter formulas or structured labels, test it on a copied worksheet or a small selection first.

Wildcards and literal characters

Excel Find and Replace supports wildcard characters in searches. An asterisk (*) represents any number of characters, and a question mark (?) represents one character. For example, searching for east* can match text beginning with east followed by any characters. Wildcards can make a search powerful, but they can also match much more than an exact phrase.

To search for a literal asterisk, question mark, or tilde, prefix it with a tilde. For example, use ~* in Find what to search for an actual asterisk rather than treating it as a wildcard. This matters when working with codes, product labels, or text that includes these symbols. Review matches before using Replace All whenever a wildcard is part of the search.

Common problems and how to fix them

If Ctrl+H appears to do nothing or the result is not what you expected, work through a few checks before repeating a bulk edit:

No matches are found: Confirm the spelling, punctuation, and search scope. Check whether Match case or Match entire cell contents is enabled, and verify the Look in setting.
Excel finds fewer results than expected: The target may be part of a formula, a displayed value, or a longer cell entry. Try the appropriate Look in choice and review the entire-cell setting.
Too many cells change: Undo immediately with Ctrl+Z, then narrow the selection or choose Sheet instead of Workbook. Use Match entire cell contents if only exact entries should change.
A formula is changed unexpectedly: Inspect Look in and test on a copy. Replacing text in a formula can alter its expression, not merely the result shown in the cell.
The shortcut behaves differently: Confirm that Excel has focus and that the dialog is not already open behind another window. On a laptop, check whether the keyboard layout or a system utility intercepts the key combination.

Most ordinary replacements can be undone with Ctrl+Z, but undo is not a substitute for checking scope first. If you have made several later edits, undoing may also remove those edits. Save a copy before a high-impact replacement, especially in a workbook with many sheets, formulas, or important records.

Excel on Mac and Excel for the web

In Excel for Microsoft 365 on Mac, Control+H opens Find and Replace, and Control+F opens Find. On a Mac keyboard, Control is the Control key; these shortcuts are not the same as Command+H or Command+F. If the shortcut is unavailable or intercepted, use Excel’s ribbon command under Home > Find & Select and choose Replace or Find.

Excel for the web has Find and Replace controls in the Home ribbon as well. Keyboard behavior can depend on the browser and the web app’s shortcut handling, so use the ribbon’s Find & Select command if Ctrl+H triggers a browser command or does not open Excel’s replacement controls. The desktop and web interfaces may present options differently, but the basic process—specify a search term, replacement, and scope—remains the same.

Frequently Asked Questions

What is the shortcut for Find and Replace in Excel?

In Excel for Microsoft 365 on Windows, press Ctrl+H to open Find and Replace on the Replace tab. On Mac, use Control+H. Ctrl+F or Control+F opens the Find tab instead.

How do I replace all occurrences in Excel?

Press Ctrl+H, enter the original text and its replacement, confirm the search scope and options, then select Replace All. Review the reported number of replacements and check affected cells afterward.

Can I replace text in the whole workbook?

Yes. Open Options in Find and Replace and set Within to Workbook rather than Sheet. Check the scope carefully before choosing Replace All, because the change can affect matching cells on multiple worksheets.

How do I replace only an exact cell match?

Open the dialog’s Options and enable Match entire cell contents. This restricts matches to cells whose complete contents equal the search text, rather than cells that merely contain it.

Can I undo Replace All in Excel?

Usually, press Ctrl+Z immediately after Replace All to undo the replacement. If you have made other changes since then, undo may also reverse those actions, so save a backup before a consequential bulk edit.

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.