Open Find and Replace with a keyboard shortcut
The fastest way to find and replace text in Google Sheets is to use Ctrl+H on Windows or Cmd+H on Mac. This opens the Find and Replace dialog box when ready, without clicking through menus. The dialog appears as a panel on the right side of your screen.
If the keyboard shortcut does not work on your computer, you can open Find and Replace through the menu instead. Click Edit at the top of the sheet, then select Find and replace from the dropdown. The result is the same panel.
Key Takeaways
- Use Ctrl+H (Windows) or Cmd+H (Mac) to open Find and Replace when ready without navigating menus.
- Type the text you want to find in the first field and the replacement text in the second field, then choose whether to replace one instance or all at once.
- The "Match entire cell contents" option prevents accidental replacements inside larger text strings, such as replacing "cat" inside "category".
- Use "Match case" when you need to distinguish between uppercase and lowercase letters, such as replacing "John" but not "john".
- Google Sheets shows you how many replacements it made, so you can undo the action if the number seems wrong.
Enter the text you want to find and what to replace it with
In the Find and Replace panel, the first field is labeled Find. Type the exact text you want to locate. This can be a single word, a phrase, or even a number. Google Sheets will search every cell in your sheet unless you tell it otherwise.
The second field is labeled Replace with. Type what you want to put in place of the text you found. If you want to delete the text entirely rather than replace it with something else, leave this field empty and proceed with the replacement.
Once both fields are filled in (or the Replace field is intentionally left blank), you have two choices: Replace all replaces every instance at once, while Replace replaces only the next single instance. Most people use Replace all, but Replace is useful when you want to check each match before committing to the change.
Limit your search to specific columns or sheets
By default, Find and Replace searches your entire spreadsheet. If you have multiple sheets or want to search only a certain range of cells, click More options at the bottom of the Find and Replace panel to reveal additional settings.
Under "Search in," you can choose All sheets, This sheet, or Specific range. If you select Specific range, a text field appears where you type the cell range you want to search, such as A1:C50 or Sheet2!A:A. This prevents accidental changes in parts of your spreadsheet you did not intend to modify.
Use "Match entire cell contents" to avoid partial replacements
Without this option enabled, Find and Replace will match text anywhere inside a cell. For example, if you search for "cat" and replace it with "dog," the word "category" becomes "dogegory." This is usually not what you want.
Click More options and check the box next to Match entire cell contents. Now the search only matches cells that contain exactly "cat" and nothing else. The word "category" is left untouched. Use this setting whenever you are replacing a word that might appear as part of a longer word.
Use "Match case" when uppercase and lowercase matter
By default, Find and Replace treats uppercase and lowercase letters as the same. A search for "john" will find and replace "John," "JOHN," and "john" all together.
If you need to distinguish between them, click More options and check the box next to Match case. Now a search for "john" finds only lowercase "john" and leaves "John" and "JOHN" unchanged. This is useful when you are working with data where capitalization carries meaning, such as product codes or proper names that must stay in a specific format.
Check the replacement count before confirming
When you click Replace all, Google Sheets shows you a message stating how many replacements were made. Read this number carefully. If you expected 5 replacements but the message says 47, something went wrong — perhaps your search term was too broad or appeared in places you did not anticipate.
If the count looks wrong, when ready press Ctrl+Z (Windows) or Cmd+Z (Mac) to undo the replacement. Then reopen Find and Replace, adjust your search term or enable additional options like "Match entire cell contents," and try again. Undoing is when ready and safe, so do not hesitate to use it.
Use regular expressions for complex patterns
For advanced searches, click More options and check Search using regular expressions. Regular expressions are patterns that match text in flexible ways. For example, the pattern ^[0-9]+$ matches any cell containing only numbers, and .*@.* matches any cell containing an email address.
Regular expressions are powerful but require learning their syntax. If you are new to them, start with straightforward searches and use Find and Replace without this option. Once you are comfortable with basic find and replace, you can explore regular expressions to handle more complex tasks like finding phone numbers in different formats or removing leading spaces from many cells at once.
Frequently Asked Questions
Can I undo a find and replace if I made a mistake?
Yes. Press Ctrl+Z (Windows) or Cmd+Z (Mac) when ready after the replacement to undo it. Google Sheets keeps your undo history for several actions, so you can step back even if you have made other changes since the replacement. If you realize the mistake much later, you may need to redo the work manually.
What is the difference between "Replace" and "Replace all"?
Replace changes only the next single instance of your search term and then stops, letting you review each match. Replace all changes every instance at once without pausing. Use Replace when you want to check each match first, and Replace all when you are confident the search term is specific enough to avoid mistakes.
Can I search across multiple sheets at once?
Yes. In the More options section, select "All sheets" under Search in. Google Sheets will then search and replace across every sheet in your spreadsheet. Be careful with this setting — if you have similarly named columns in different sheets, you might replace text you did not intend to change.
How do I find text that contains special characters like asterisks or question marks?
If you are not using regular expressions, special characters are treated as literal text. Type them normally in the Find field. If you have regular expressions enabled, special characters have special meanings, so you need to put a backslash before them — for example, \* to search for an actual asterisk.
Can I replace text with a formula or function?
No. Find and Replace only works with text and numbers, not formulas. If you need to change formulas across many cells, you must edit them manually or use a script. For straightforward text replacements, Find and Replace is the right tool.