In Excel for Microsoft 365 on Windows, press Ctrl+H to open Find and Replace directly on the Replace tab, or choose Home > Find & Select > Replace. To find text without replacing it, press Ctrl+F. Before using Replace All, check the search scope and test a single replacement so you do not change unintended cells.
What You’ll Need
- An Excel workbook open in the desktop app, with the worksheet containing the text or values you want to find.
- A clear idea of what you want to search for and, if replacing, the exact replacement text. If the change could affect many cells, save a copy of the workbook first.
You do not need to install an add-in or enable a special setting. Find and Replace is built into Excel. The steps below are for Excel for Microsoft 365 on Windows; the Mac and web differences are noted where useful.
Step-by-Step
- Open the worksheet and decide where to search. Click the sheet tab that contains the information. Excel can search the active sheet or the whole workbook. If you only want to search a particular cell range, select that range before opening the tool, then verify the scope in the dialog. If you want to include every worksheet, leave the selection alone and choose the workbook scope in a later step.
- Open Find and Replace. Press Ctrl+H on Windows. Excel opens the Find and Replace dialog with its Replace controls available. You can also open the ribbon and choose Home > Find & Select > Replace. This is useful if the shortcut is unavailable or you prefer to use the ribbon.
- Enter the text or value to find. Click the Find what box and type the characters, word, number, or other content you want Excel to locate. Enter the text as it appears in the cells. For example, to change the department label Sales to Sales Team, type Sales in Find what. Take care with short search terms: Excel may find them inside longer words as well.
- Enter the replacement, if you want to change the cells. Click Replace with and type the new content. In the example, enter Sales Team. To locate matches without changing them, use the Find tab instead, or use Find Next from the Replace tab and do not select Replace. A blank Replace with box is meaningful: replacing with nothing removes the matching text, so confirm that this is what you intend.
- Set the search scope and matching options. Select Options if the extra settings are not visible. Check Within: choose Sheet to search the active worksheet, or Workbook to include all worksheets in the open workbook. Check Look in to choose whether Excel searches formulas, displayed values, or notes. Use Match case when capitalization must match, and Match entire cell contents when the whole cell must equal the search term. Leave those boxes clear for a broader search.
- Check the search before changing anything. Click Find Next to move through matches one at a time. Excel selects a matching cell, allowing you to inspect it and decide whether it should be changed. Choose Find All to display a list of matches; select an item in that list to go to its cell. This preview is especially helpful when the same word appears in labels, notes, or unrelated parts of the sheet.
- Replace one match first. When you are confident the selected match is appropriate, click Replace. Excel updates that match and moves to another one. Review the changed cell and any surrounding data. If the result is correct, continue with Replace for individual changes or proceed to Replace All if every match should be changed.
- Use Replace All only after reviewing the scope. Click Replace All to change every match within the chosen scope. Excel reports how many replacements it made. Read that message and, if the count seems unexpectedly high or low, stop and review the options. If the change was a mistake, press Ctrl+Z immediately to undo it, provided you have not performed another action that changes the undo history.
- Close the dialog and check the workbook. Click Close, then inspect several changed cells and any formulas or totals that depend on them. Save the workbook after confirming the result. If you changed several sheets, visit each one rather than assuming a workbook-wide replacement affected only the sheet that was visible.
For a find-only search, press Ctrl+F or choose Home > Find & Select > Find. Enter the term, then use Find Next or Find All. In the Find and Replace dialog, you can also switch between the Find and Replace tabs without reopening the feature.
Common Mistakes
- Replacing every match too soon. Replace All does not ask you to approve each cell. A short term such as art could match part of words such as department. Preview several results or make one test replacement first.
- Searching the wrong area. The Within setting may be set to Sheet when you expected Workbook, or the reverse. A selected range can also narrow what you intend to search. Confirm the setting and results before running a large replacement.
- Using the wrong Look in option. A cell may display a calculated result while its formula contains different text. If you are looking for the visible result, search values; if you need to find text inside a formula, search formulas. Changing formula text can alter how calculations work.
- Assuming matching is always exact. Unless Match entire cell contents is selected, Excel can find a term within a longer cell entry. Unless Match case is selected, Excel generally treats capitalization as a match regardless of case.
- Leaving Replace with empty by accident. An empty replacement deletes the found characters from matching cells. If you meant to retain the text, fill in the replacement box before choosing Replace or Replace All.
Tips
- Use Find All as a review list. It can show where a term occurs before you make changes. If the matches are scattered across a large sheet, the list is faster to review than repeatedly clicking Find Next.
- Use the sheet scope for controlled edits. When you only intend to edit one worksheet, choose Sheet rather than relying on a remembered workbook-wide setting. For a workbook-wide change, check that every included sheet should be affected.
- Understand wildcard characters. In searches, an asterisk (
*) can stand for any number of characters and a question mark (?) can stand for one character. To search for a literal asterisk or question mark, place a tilde before it, such as~*or~?. Use wildcards only when you mean to match a pattern, because they can produce many more results than a plain-text search. - Use a copy for high-impact changes. If you are renaming codes, editing formulas, or replacing content across many sheets, save a separate copy first. You can also test the replacement on a small, representative range before expanding the scope.
- Remember the Mac shortcuts. In Excel for Mac, use Command+F to find. Control+H opens Replace in many current Mac configurations; if the shortcut behaves differently on your keyboard, use Home > Find & Select > Replace. Keyboard shortcuts can vary with macOS settings and keyboard layout.
- On Excel for the web, use the ribbon if needed. The browser may capture familiar shortcuts for its own commands. Open Home > Find & Select and choose Find or Replace when available in the web interface. The available controls can vary with the current Excel for the web layout.
Troubleshooting
Ctrl+H does nothing or opens something unexpected: Click a cell in the workbook first, then use Home > Find & Select > Replace. In a browser, the browser may intercept a shortcut; the ribbon is the safer route. On a Mac, use the ribbon if the keyboard shortcut is intercepted or differs on your setup.
Excel says there are no matches: Check spelling, spaces, punctuation, and the selected sheet or range. Open Options and verify Within, Look in, Match case, and Match entire cell contents. For example, a search for a displayed number may not find it if Excel is looking in formulas, while a formula expression may not be found when Look in is set to Values. Also check whether a filter or hidden row has led you to overlook where a result is located; search settings and visible rows are separate issues.
The replacement changes too much: Press Ctrl+Z immediately on Windows, or Command+Z on Mac, to undo the last change. Reopen Find and Replace, narrow the Within setting or select the intended range, then use Find All to inspect matches. Turn on Match entire cell contents if only cells containing exactly the search term should qualify. If you already made other edits after the replacement, undo may also reverse those later actions, so inspect the workbook carefully.
The visible text is not what Excel searches: A formula cell can show a result different from the formula text itself. Review Look in and choose Values to search what the cell displays, or Formulas to search the expression. Number formats can also make a stored value display differently; for example, a date or a number with leading zeros may not be stored as the visible characters suggest. Check the cell contents and format before changing the search term repeatedly.
Find All or Replace All returns an unexpected count: Recheck whether the search term is part of longer words, whether wildcards are active, and whether the scope includes other sheets. If you are unsure, close the dialog without replacing, save a copy, and run Find All with narrower options. A small test replacement is a safer way to confirm the match behavior.
Frequently Asked Questions
What is the keyboard shortcut for Find and Replace in Excel?
In Excel for Microsoft 365 on Windows, press Ctrl+H to open the Replace controls and Ctrl+F to find. On Mac, Command+F opens Find; use Control+H for Replace where supported, or use the ribbon path.
How do I open Find and Replace without a keyboard shortcut?
Choose Home > Find & Select > Replace in the Excel desktop app. To search without replacing, choose Home > Find & Select > Find.
Can I find and replace text in the whole workbook?
Yes. In the dialog, show Options and set Within to Workbook. Review the matches first, because Replace All can affect every worksheet in that workbook, not just the active sheet.
Can Find and Replace change only part of a cell?
Yes. If Match entire cell contents is not selected, Excel can find a term inside a longer cell entry and replace that matching portion. Use Find Next to confirm exactly what will change before replacing.
Can I undo Replace All?
Usually, press Ctrl+Z on Windows or Command+Z on Mac right after the replacement. Undo availability depends on what you do afterward. Save a copy before a large edit so you have a fallback if the result is not correct.
Why does Excel find a value on one sheet but not another?
The sheets may have different content, or the search may be limited to the active sheet or a selected range. Check the Within option, the Look in setting, and any match options. If you need to search every sheet, set Within to Workbook and use Find All to review the results.
Related
- Google Sheets Jira Plugin: Setup, Features, and Options Guide
- Google Sheets Jira Sync: Methods, Setup, and Limits
- Google Sheets Join Columns: Formulas and Methods That Work
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Put a Heat Map in Excel Using Conditional FormattingTo put a heat map in Excel, select the numeric cells you want to compare, then choose Home…
- Excel Data Validation Colour Change: Rules and FixesExcel data validation cannot directly change a cell’s colour when someone chooses a value. To make the cell…
- Google Sheets: Check If a Value Is in a ListIn Google Sheets, check whether a value appears in a list with =COUNTIF($A$2:$A$10,D2)>0, assuming the list is in…
- Excel Scatter Plot With Two Y-Axes: How to Make OneYes. In Excel for Microsoft 365 on Windows, create an XY scatter chart, select the data series that…
- How to Paste in Excel Without Replacing Existing DataTo paste copied cells in Excel without overwriting what is already there, copy the source range, right-click the…
- Excel Table Slicers: How to Add, Use, and TroubleshootAn Excel table slicer is a clickable filter panel for an Excel table: choose a button such as…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.