Excel Find and Replace Shortcut Key: How Ctrl+H Works

In Excel for Microsoft 365 on Windows, press Ctrl+H to open Find and Replace, then enter the text to find and its replacement. To search without replacing, press Ctrl+F.

What Ctrl+H Does in Excel

Ctrl+H opens Excel’s Replace tab or dialog, where you can search for text or numbers and replace matches one at a time or throughout a selected search area. It is useful for correcting repeated typos, changing a label used across a worksheet, or updating a code that appears in many cells. The shortcut opens the tool; it does not change any cells until you choose Replace or Replace All.

Ctrl+F is the related Find shortcut. It opens the search interface so you can locate matching entries without changing them. In the Find and Replace window, you can move between the Find and Replace tabs, so there is no need to close the tool and start over when you want to switch tasks.

The shortcut is worth distinguishing from the browser shortcut: Ctrl+H usually opens browser history in a web browser, but in Excel desktop it invokes Replace. In Excel for the web, keyboard shortcuts can interact with browser controls, so using the ribbon is a reliable alternative.

Open Find and Replace from the Ribbon

If you forget the shortcut, or if a keyboard combination is intercepted by your browser or operating system, open the command from Excel’s ribbon. On Windows, choose Home > Find & Select > Replace. Select Find on the same menu to search without replacing. This route also makes it easier to confirm that you are using Excel’s command rather than a browser feature.

On a Mac, Control+H is commonly used to open Replace in Excel, while Command+F opens Find. Keyboard behavior can depend on the Excel release and keyboard settings. If the shortcut does not open the expected tool, use Excel’s menu command, such as Edit > Find > Replace, or look for Find and Replace on the Home tab. In Excel for the web, use the Home ribbon’s Find & Select options when the keyboard shortcut is not available or is handled by the browser.

After opening the tool, select the Replace tab if it is not already active. The dialog contains separate fields for the text to find and the replacement. Entering only a find term and clicking Replace All is not a preview: Excel will make the changes immediately.

Replace One Match or Every Match

Excel provides two main actions. Replace changes the current match and then lets you continue through later matches. Replace All changes every match within the chosen search scope in one operation. Choosing between them depends on how certain you are that every matching cell should be changed.

Use Find Next to move through matches and inspect each one before deciding what to do.
Use Replace when you want to change a specific occurrence but review the remaining matches individually.
Use Replace All when the target is unambiguous, such as replacing a consistently misspelled product name with its correct spelling.

For example, suppose a worksheet contains the department label “Custmer Service” in several cells. Searching for that exact misspelling and replacing it with “Customer Service” is a sensible Replace All task if the search is limited to the intended worksheet or range. If the short term is “IT,” however, replacing all matches could affect unrelated words, labels, or formulas. Review the matches first or narrow the scope.

Excel typically reports how many replacements it made after Replace All. Treat that count as a useful check, not proof that the results are correct. A surprisingly high count may signal that the search term was too broad; a count of zero may mean the spelling, case, or search scope did not match what you expected.

Limit the Search to the Right Cells

By default, Find and Replace works within the current worksheet. The dialog’s options let you adjust where Excel searches, including choosing the workbook rather than just the active sheet. Available labels and details can vary slightly among Excel versions, but look for the options area in the dialog and check the search scope before using Replace All. A workbook-wide replacement can alter matching entries on other sheets that are easy to overlook.

You can also select a range before opening Replace to focus the operation on that part of a worksheet. This is helpful when a column contains both data to update and similar text that must remain unchanged. Confirm the selection and scope in the dialog; do not assume that a highlighted range or an earlier search setting is still active if you have changed worksheets or reopened the tool.

Excel’s search options can also affect which content it examines. Depending on the version, the Look in setting can include formulas, values, or notes. Searching formulas is different from searching the displayed result of a formula. For example, a cell might display “North” because a formula returns that word, even though “North” is not written as a literal value in the cell. If a search misses an apparent match, check the Look in setting as well as the scope.

Use Case, Whole-Cell, and Format Options Carefully

Find and Replace includes options that control what counts as a match. Match case distinguishes uppercase and lowercase letters. Match entire cell contents restricts a search to cells whose complete contents equal the search term, instead of matching that term inside a longer entry. These settings are useful when a common word or code appears in several different contexts.

For example, searching for “East” without requiring a whole-cell match may also find “Eastern Region.” If you intend to change only cells containing exactly “East,” use Match entire cell contents. Conversely, enabling that option would prevent a search for “East” from finding “Eastern Region,” even though the word begins with the same letters. Check the options when the result count is unexpected.

Excel can also search by formatting, not just by typed characters. Find and Replace offers format criteria that can help locate cells with a particular fill, font, or other formatting, and can apply formatting through the replacement settings. This is a different task from changing a cell’s text. If a format criterion has been set previously, clear it when you want a normal text search; otherwise, matching text with a different format might be skipped.

Wildcards and Special Search Characters

In Find and Replace, an asterisk (*) can stand for any number of characters, and a question mark (?) can stand for one character. These wildcards can make broad searches powerful, but they can also produce more matches than a literal search. To search for an actual asterisk, question mark, or tilde rather than treating it as a special character, place a tilde (~) before it.

Jo*n can match text beginning with “Jo” and ending with “n,” with any number of characters between.
Item-? can match “Item-” followed by one character, such as “Item-A.”
~* searches for a literal asterisk character.

Test wildcard searches with Find Next or Find All before replacing. A pattern intended to match a small set of product codes can also match ordinary text if the pattern is broad. Escaping a wildcard with a tilde is especially important when the character itself is part of the data, such as a typed asterisk used to mark a note.

What Changes When a Match Is in a Formula?

Replacing text in a worksheet is not always limited to visible labels. If the search is set to look in formulas, a replacement may change the formula text itself. For instance, a formula containing a worksheet name or a text string could be affected if that text matches the search term. That can alter a calculation or break a reference even though the cells’ displayed values initially looked unrelated.

Before replacing a term that could occur in formulas, decide whether you mean to change formulas, displayed values, or both. Check the Look in option and consider limiting the action to a selected range. If the workbook is important, save a separate copy before a broad Replace All. Replacements made in cells can usually be reversed immediately with Ctrl+Z, but other actions or later changes may limit how practical undo is as a recovery plan.

Also remember that changing a value can affect dependent formulas, charts, or other workbook features. Excel recalculates formulas as appropriate, but it cannot determine whether the wording or data change was intended. Inspect a few affected cells and any relevant summaries after a large replacement.

Common Problems and Safer Workflows

If Ctrl+H appears to do nothing, first make sure Excel has focus rather than another application or a browser page. In Excel for the web, try the ribbon command. If a search returns no results, check for a spelling difference, extra spaces, Match case, Match entire cell contents, the active worksheet versus workbook scope, and whether Excel is looking in formulas or values.

A practical workflow for a potentially wide-ranging change is:

Save the workbook, or create a copy if the data is important.
Open Replace with Ctrl+H or Home > Find & Select > Replace.
Enter the exact search text and replacement text.
Review the search scope, Look in setting, and any case, whole-cell, or format options.
Use Find Next or Find All to inspect the targets when the match could be ambiguous.
Choose Replace All only when the listed scope and expected matches are clear, then review the result and replacement count.

For repeated, highly controlled transformations, Find and Replace may not be the best tool. A helper column with a formula can make proposed text changes visible beside the original data before you paste results back. A carefully reviewed Power Query transformation can be more suitable for a repeatable import-cleaning process. Those approaches take more setup, but they make the transformation rules clearer than an unrestricted replacement across a workbook.

Frequently Asked Questions

What is the shortcut for Find in Excel?
Press Ctrl+F on Windows to open Find. On a Mac, Command+F is the usual Find shortcut. Excel for the web may handle shortcuts differently depending on the browser, so its Home ribbon is a dependable alternative.

Does Ctrl+H replace every occurrence automatically?
No. Ctrl+H opens Find and Replace; it does not modify cells by itself. Choose Replace to handle a match or Replace All to change all matches within the active search scope.

How do I replace text across every worksheet?
Open Replace, expand or check the dialog options, and set the search scope to the workbook if that option is available. Review the number and location of matches carefully, because a workbook-wide operation can change cells on sheets beyond the one currently visible.

Can I undo Replace All?
Ctrl+Z will generally undo a recent Replace All in Excel, provided the undo history is still available. For important workbooks, save a copy first rather than relying on undo as the only safeguard.

Why does Excel find a word but not replace it?
Check that you are on the Replace tab and have entered replacement text. Also review the active worksheet or workbook scope, Match case, Match entire cell contents, format criteria, and the Look in setting. A search for displayed formula results may behave differently from a search in formulas.

Does Ctrl+H work in Excel for the web?
Shortcut behavior in a browser can vary, and Ctrl+H may be intercepted by the browser. Use the Home ribbon’s Find & Select commands to open Find or Replace in Excel for the web.

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.