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 |
Use a safe replacement workflow
Start with a copy or a saved version of the workbook. In Find and Replace, choose whether to search the current sheet or the whole workbook, and decide whether the match should include formulas, values, or comments. Preview a few matches before using Replace All, especially for short terms that may appear inside longer labels.
For standardized categories, write the old-to-new mapping in a small audit table so another person can review what changed. Avoid replacing a value in formulas unless that is the intended repair; a text replacement can alter logic without changing the visible result immediately. After the replacement, search again for the old value and spot-check formulas, IDs, and notes that should have remained untouched.
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.
Sources
Do this with AI
Turn the instructions into a finished spreadsheet.
Tell Griddy what you need in plain English, then inspect and keep editing the result in the browser, Excel, or Google Sheets.