Excel's Find and Replace can change a word or label across a sheet in one operation. Press Ctrl+H in Windows, enter the old and new text, then inspect a match before using Replace All.
Matching the complete cell protects longer entries. For example, Excel can change Open to Closed while leaving Open order alone.
Set up the text change
Open the intended worksheet. In desktop Excel, use Home > Find & Select > Replace; the control sits in the ribbon's Editing group on Windows. The Windows shortcut is Ctrl+H.
Enter the existing text in Find what and its replacement in Replace with. Microsoft documents this dialog in its Excel search instructions.
Status: Microsoft's Find and Replace options reviewed October 29, 2026 for desktop and browser Excel. The examples use invented labels, with no customer workbook edited.
Use Options to expose the remaining controls. With Within set to Sheet, the search stays in the current worksheet. Workbook extends it to other worksheets, so choose that only when the change belongs throughout the file.
The matching controls are separate from the scope. A correctly spelled search can still affect the wrong records when Workbook is selected unnecessarily.
Match a complete label instead of part of a cell
Enable Match entire cell contents when the old value should occupy the whole cell. Enable Match case when capitalization matters, such as distinguishing an uppercase code from ordinary text.
Consider these invented entries: Open, Open order and OPEN. With whole-cell and case-sensitive matching enabled, a search for Open selects only the first entry.
Without whole-cell matching, replacing that text with Closed can also turn Open order into Closed order. That may be intended for a sentence correction, but it is a different operation from changing an exact status label.
For punctuation such as an asterisk, use the literal-character search rules before replacing anything. Some punctuation has a special search meaning.
Review one change before replacing the rest
Choose Find Next and read the matched cell. Check both its visible content and the formula bar, then use Replace for a single occurrence.
Microsoft says Replace All changes every occurrence meeting the search criteria. Use it only after the first change and scope agree with the intended edit. A matching label on another sheet may have a different purpose.
Afterward, inspect representative changed cells and any totals depending on them. If the replacement was wrong, undo it immediately before continuing other edits.
A text search is not a substitute for inspecting formulas. Microsoft's Windows instructions say the Replace tab searches Formulas, whereas Find can also search Values, Notes or Comments.
Changing formula text can change the calculated answer, rather than replacing only what the cell displays. For a formula appearing as text, use the formula-display repair.
Find the command on Mac or in browser Excel
On Mac, open Home > Find & Select > Replace for the dialog. Command+F opens the search bar instead, so it is not the same route as the Windows replacement shortcut.
In Excel for the web, choose Home > Find & Select > Replace. Microsoft states that Search Options offers Selection, Sheet or Workbook, alongside case and whole-cell controls.
Use Selection in the browser when only the selected cells should be changed. Confirm that selection before replacement, particularly when the sheet mixes input records and calculations.
When Excel cannot find an entry that is visible
Recheck the sheet scope, case requirement and whole-cell requirement. In desktop Find, also inspect Look in and any Format criterion. Those filters can exclude a cell even when its displayed words look right.
If the intended cells cannot be edited, ask the workbook owner about its protection and editing permissions. For unexplained matches, show Microsoft Support sample entries, the search options and the expected change.
The Short Version
Set the sheet or workbook scope, choose partial or complete-cell matching, and review one replacement first. Replace All acts on every match in that scope. Formula text and displayed results need different care.
Isaac Smith is the founder and editor of PC Glance, a website that covers computers, laptops, and technology. He is a tech enthusiast and a computer geek who loves to share his insights and help his readers make smart choices when buying tech gadgets or laptops. He is always curious and updated about the latest tech trends.