Ctrl+H in Excel: Find and Replace Step-by-Step Guide

How-to basics · Updated November 22, 2026

In Excel for Microsoft 365 on Windows, press Ctrl+H to open the Find and Replace dialog with the Replace tab ready. Enter the text to find and its replacement, then choose Replace to review matches one at a time or Replace All to change every match in the selected search area.

What Ctrl+H Does in Excel

Ctrl+H is the keyboard shortcut for Excel’s Replace command. It is useful when the same text, number, or other searchable content appears in multiple cells and you want to update it consistently. For example, you could replace an outdated department name, correct a repeated spelling error, or change a product code across a worksheet.

The shortcut opens a dialog rather than making a change immediately. You can inspect the search settings, enter what should be found and what should replace it, and choose how broadly Excel should search. That pause matters: a replacement can affect many cells, and the intended change may be narrower than the default search.

Ctrl+F opens Excel’s Find tab for locating content without replacing it. You can also open Replace with the ribbon: go to Home > Find & Select > Replace. In the dialog, the Find what box contains the current text to search for, and Replace with holds the new text. The labels are important: reversing the entries would change the wrong content.

How to Replace Text Step by Step

For a controlled change, use Replace rather than immediately choosing Replace All. This lets you confirm each match before Excel edits a cell.

  1. Click a cell or select a range. If a range is selected, Excel searches within that selection; click a single cell if you intend to search the sheet rather than just a block.
  2. Press Ctrl+H, or use Home > Find & Select > Replace.
  3. Type the existing content in Find what and the new content in Replace with. Leave the second box empty if the goal is to remove a match.
  4. Choose Find Next to move to a match and inspect it. Select Replace to change that match and continue, or choose Replace All after checking the settings.
  5. Read Excel’s message reporting how many replacements were made, then inspect the affected cells and nearby data.

For example, if a worksheet contains the label East Region and you need it to read Eastern Region, put East Region in Find what and Eastern Region in Replace with. Using Replace All is reasonable if the exact phrase has a consistent meaning throughout the chosen scope. If East Region also appears inside a longer label, enable Match entire cell contents when only cells containing exactly that label should change.

Choose the Search Scope Before Replacing

The Options button in the Find and Replace dialog reveals controls that determine where and how Excel searches. The Within setting chooses Sheet or Workbook. Sheet searches the active worksheet; Workbook searches across the workbook’s worksheets. For a workbook-wide replacement, confirm that Workbook is selected rather than assuming the shortcut will search every tab.

A selected range is another important boundary. If you select cells before opening the dialog, Excel limits the search to that selection. This is useful when you want to update one table without touching another, but it can also explain why a replacement reports no matches even though the text exists elsewhere in the sheet. Click a single cell and check the Within setting if you need to broaden the search.

The Search setting can specify whether Excel moves through cells by rows or by columns. This affects the order in which Find Next visits matches, not which matching text qualifies. The Look in setting controls what Excel examines, such as formulas or cell values; available choices can vary with the workbook content and Excel version. Check it if Excel seems to skip a visible match.

Useful Options: Case, Whole Cells, and Formats

Two options help prevent accidental partial or case-insensitive matches. Match case distinguishes uppercase and lowercase letters, so searching for Item does not necessarily match item. Match entire cell contents requires the whole cell to equal the search text. Without that option, a search for cat can match a cell containing catalog as well as a cell containing only cat.

These controls are especially useful with short codes and words that occur as parts of other values. If you are changing a code such as AB, consider whether you mean only cells whose full content is AB or also entries such as AB-104. For names or labels, think about whether capitalization is meaningful in the data before enabling Match case.

Excel’s Find and Replace can also search by formatting. The dialog’s Format controls let you specify formatting to find and, where applicable, formatting to use for the replacement. This is separate from replacing text: a format-based search can help locate cells with a particular style, but it should not be confused with a text match. If an old format choice is affecting later searches, clear the format criteria in the dialog before searching again.

Wildcards and Special Characters

Excel supports wildcard characters in the Find what box, which can make a search flexible but also broader than expected. An asterisk (*) matches any number of characters, including none. A question mark (?) matches one character. For example, searching for prod* can find text beginning with prod, including product names with different endings.

Use wildcards carefully with Replace All. A broad pattern might match many different labels, not just the one example you had in mind. Search first with Find Next or Find All, and check the number and context of matches before applying a replacement. Wildcards are patterns, not literal punctuation, unless you escape them.

To search for a literal asterisk, question mark, or tilde, precede it with a tilde (~) in the Find what text. For instance, use ~* to find an actual asterisk. This is useful when a worksheet contains symbols as data, such as a note marker or a question mark in a code. If your search includes these characters and results seem unexpectedly broad, check whether Excel is interpreting one as a wildcard.

Replacing Cell Values Versus Formula Text

A cell may display a result while containing a formula, so the visible text is not always the content Excel searches. The Look in option matters here. When it is set to Values, Excel searches displayed cell results; when it is set to Formulas, it searches the formula text stored in cells. The right choice depends on whether you want to find a displayed result or edit part of a formula.

For example, a cell might display North while its formula refers to a lookup table or combines text from other cells. Replacing North among values is not the same as replacing a reference or word inside formulas. Formula-text replacements can alter how calculations work, so review matches carefully and consider testing on a copy of the workbook when the formulas are important.

Replacing a value also does not mean that every related feature is updated. A cell’s displayed result may come from a formula, a number format, or another source. If a search does not find what you see, first check the Look in setting and then inspect the cell’s formula bar. This helps distinguish an actual stored value from a display created by formatting or calculation.

Common Problems and Safer Ways to Work

  • Excel finds nothing: Check whether a range is selected, whether Within is set to Sheet or Workbook as intended, and whether Look in is set to Formulas or Values appropriately. Also check for extra spaces or different punctuation in the stored content.
  • Too many cells change: Use Find Next to preview a few matches, enable Match entire cell contents or Match case if appropriate, and narrow the selection or scope. Avoid Replace All until the match rules reflect the intended change.
  • Only part of a word changes: Excel normally matches text within a cell, not just complete words. Use Match entire cell contents for cells that must equal the full search phrase; for more complex cases, review matches individually.
  • Replacement affects formulas: Check Look in and whether the matched content is inside a formula. If formulas are involved, use a workbook copy or replace one match at a time and verify calculated results.
  • A previous search behaves strangely: Find and Replace can retain options from an earlier search, including formatting or case settings. Open Options and review the criteria instead of assuming every search starts with defaults.

Excel generally allows an immediate replacement to be reversed with Ctrl+Z. Do that promptly if the result is wrong, before making more edits. Undo availability can depend on subsequent actions and the particular operation, so it is not a substitute for checking the scope first. For a large or valuable workbook, save a copy before a broad replacement; this also gives you a recovery point if the change has consequences that are not obvious at first.

Keyboard Shortcuts on Mac and Excel for the Web

In Excel for Microsoft 365 on Windows, Ctrl+H opens Replace. In Excel for Mac, the equivalent shortcut is generally Control+H; do not substitute Command+H, which is a macOS command for hiding an app. Menu labels and shortcut behavior can vary with keyboard layout or application settings, so the ribbon or menu command is a reliable fallback. In Excel for the web, use the Home tab’s Find & Select controls if the browser handles the keyboard shortcut instead.

These shortcuts open the same general search-and-replace workflow; they do not determine whether Excel searches only the active sheet or the full workbook. Always confirm the scope and options in the dialog. If you only need to locate a value and leave it unchanged, use Find rather than Replace, then close the dialog without editing.

Frequently Asked Questions

Does Ctrl+H replace everything in an Excel workbook?
No. It opens the Replace dialog, but the scope depends on the Within setting, any selected range, and the options you choose. Use Workbook for a workbook-wide search, and verify that Replace All is appropriate before applying it.

How do I replace only a complete cell value?
Open Ctrl+H, enter the text, select Options, and enable Match entire cell contents. This prevents a search for a short label from matching that text as only part of a longer cell entry.

Can I use Ctrl+H to remove text?
Yes. Enter the text to remove in Find what and leave Replace with empty, then use Replace or Replace All. Check whether the search should match a whole cell or just part of its contents before removing it.

Why does Ctrl+H change formulas or fail to find a displayed value?
Check the Look in setting. Formulas searches formula text, while Values searches displayed results. A visible value may be calculated by a formula rather than stored as literal text in the cell.

Can I undo Replace All?
Usually, press Ctrl+Z immediately after the replacement. If you have performed later actions, undo may also reverse those actions, so saving a workbook copy before a large replacement is the safer recovery plan.

Related

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.