How to Find and Replace in Excel: A Complete Guide

Excel's Find and Replace feature is one of the most practical tools in the spreadsheet world — and one of the most underused beyond its basic function. Whether you're cleaning up a dataset, fixing a batch of errors, or reformatting thousands of cells at once, knowing how this feature works at every level can save you significant time.

The Basics: Opening Find and Replace

There are three ways to open the Find and Replace dialog in Excel:

• Keyboard shortcut:Ctrl + H (Windows) or Command + H (Mac) opens directly to Replace
• Find shortcut:Ctrl + F opens the Find tab — click the Replace tab from there
• Ribbon: Go to Home → Editing → Find & Select → Replace

The dialog box has two fields: Find what (the text or value you're searching for) and Replace with (what you want it changed to). Click Replace All to change every match at once, or Replace to step through them one by one.

What You Can Actually Search For

Most people assume Find and Replace only works on typed text — but it handles much more:

• Numbers and values — Replace a specific number across an entire dataset
• Partial text strings — Replace "Corp" with "Corporation" across hundreds of company names
• Blank cells — Leave the "Find what" field empty to locate blanks
• Formatting — More on this below
• Formulas — If you switch the "Look in" dropdown to Formulas, Excel searches inside formula code, not just displayed values

This distinction between searching Values versus Formulas catches a lot of users off guard. If a cell shows "100" but contains =50*2, searching for "100" under Values will find it — but searching under Formulas won't.

Using the Options Panel 🔍

Clicking Options >> in the dialog expands the feature considerably. These settings control exactly how Excel matches your search:

Match Entire Cell Contents is particularly useful when you want to replace standalone values. Without it, searching for "10" will also match "100", "210", and any other cell containing those digits.

Finding and Replacing Formatting

One of the less obvious capabilities is replacing cell formatting — independent of or alongside text content.

Click Options >>, then use the Format buttons next to each field to:

• Find cells with a specific font color, fill color, or border style
• Replace formatting across matched cells — for example, changing all red-highlighted cells to yellow
• Combine text + formatting: find the word "Draft" and make it bold in one pass

This is especially useful for large spreadsheets where formatting has been applied inconsistently across a team.

Wildcards: Searching with Flexibility

Excel supports two wildcard characters in Find and Replace:

• * (asterisk) — matches any sequence of characters. Searching for J*n would match "John", "Jan", "Jason", "Junction"
• ? (question mark) — matches any single character. J?n matches "Jan" or "Jon" but not "John"

If you actually need to search for a literal asterisk or question mark in your data, prefix it with a tilde: ~* or ~?

Wildcards make it possible to clean up messy data without needing to know the exact content of every cell — just a pattern.

Replacing Across Multiple Sheets

By default, Excel runs Find and Replace on the active sheet only. To search across an entire workbook:

1. Open Find and Replace (Ctrl + H)
2. Click Options >>
3. Change Within from Sheet to Workbook

This is a commonly missed step. Users assume Replace All works everywhere — it doesn't unless you tell it to. When working with multi-sheet workbooks, the scope setting matters considerably.

Where Results Can Vary by Setup 🖥️

The core behavior of Find and Replace is consistent across Excel versions, but a few variables affect what you'll see in practice:

• Excel version — Older versions (Excel 2010, 2013) have fewer formatting match options than Excel 365 or 2021
• Mac vs. Windows — The Mac version uses Command + H, and some advanced formatting options may appear in slightly different locations
• Excel for the Web — The browser-based version supports basic Find and Replace but strips out some of the advanced formatting and wildcard features available in the desktop app
• Large datasets — Replace All on a workbook with tens of thousands of rows and complex formulas may behave differently in terms of performance depending on your hardware and Excel version

Whether you're working in a simple budget spreadsheet or a complex multi-sheet data model also shapes how carefully you need to apply scope settings and cell-matching options. A Replace All that works perfectly in one context can cascade unintended changes in another — particularly when formulas reference cells whose values you just changed.

The feature itself is straightforward. How far it takes you depends on what you're actually working with.