How to Use Find and Replace in Excel
Find and Replace in Excel can clean labels, update terms, and fix repeated values quickly. Learn safe options before changing hundreds of cells.
Find and Replace in Excel searches a worksheet or workbook for matching text, numbers, formulas, or formats, then replaces the matches you choose. It is fast enough to clean hundreds of rows, which also means it is fast enough to damage a workbook if the match is too broad.
Use it when a repeated label, vendor name, status, product code, or formula reference needs to change consistently.
Find a value first
Step 1. Press Ctrl+F on Windows or Command+F on Mac.
Step 2. Type the value you want to find.
Step 3. Click Options if you need to limit the search.
Useful options include:
Within: SheetorWorkbookSearch: By RowsorBy ColumnsLook in: Formulas,Values, orCommentsMatch caseMatch entire cell contents
Find first. Replace only after you know Excel is matching the right cells.
Replace values safely
Step 1. Press Ctrl+H on Windows or Command+Shift+H on Mac.
Step 2. Enter the current value in Find what.
Step 3. Enter the new value in Replace with.
Step 4. Use Find Next to inspect a few matches.
Step 5. Use Replace for one cell at a time, or Replace All only when the match is clearly safe.
TIP
Match entire cell contents when replacing short labels like IT, HR, or Ops; otherwise Excel may change text inside longer values.Practical example: clean inconsistent statuses
Suppose a project tracker has three labels that all mean the same thing:
In ProgressIn progressWorking
Pick one official label, such as In Progress, then replace the inconsistent versions one at a time. After that, add dropdown validation so the same problem does not come back.
This same workflow helps in a CRM lead tracker when source names drift, an expense tracker when category labels vary, or an employee schedule when role names are typed inconsistently.
Common mistakes
| Mistake | What goes wrong | Safer move |
|---|---|---|
| Replacing too short a term | Rep changes inside unrelated words | Match entire cells |
| Replacing across the workbook | Hidden sheets change too | Start with the active sheet |
| Replacing formulas accidentally | References or text in formulas change | Check Look in first |
| Using Replace All immediately | Bad matches change at scale | Inspect several matches |
The Griddy way
Find and Replace is useful, but cleaning operational data usually needs judgment about which labels should be standardized and which should stay distinct.
"Standardize the status, department, and source labels in this tracker without changing formulas or notes"
Griddy can inspect the workbook, propose the cleanup map, apply the replacements, and leave the formulas intact.
Skip the manual work
Describe it. Griddy does it.
Instead of writing this formula yourself, just tell Griddy what you need in plain English. Works in Excel and Google Sheets.