In this tutorial, you will learn how to find and replace in Google Sheets.
When you’re working in Google Sheets, you may find that you need to change key pieces of information across the entire spreadsheet. For example, you might need to update information that has changed since the spreadsheet was created, or correct errors.
Fortunately, Google Sheets makes it quick and easy to find specific text wherever it occurs in a spreadsheet and replace it with different text. Read on to learn how.
Open the Edit menu and click on the Find and Replace option, or use the keyboard shortcut:
- CTRL + H on Windows
- CMD + SHIFT + H on Mac
In the Find and Replace dialog that appears, type the text you want to replace in the Find field, and the text you want to replace it with in the Replace With field. The screenshot below shows what this looks like when finding all instances of the name “John Smith” and replacing it with “Jane Doe”
Choose where you want to perform the find and replace from the Search dropdown. You can choose to search the entire spreadsheet, the currently active sheet, or a specific range
If you selected Specific Range in Step 3, a field will appear where you can enter the range to search
If you would like to match the exact case of the text you enter, Match only entire cell contents, or search within formulas not only values, check corresponding checkboxes.
You can also use regular expressions to search for text that matches a pattern, such as an ID or email address. Regular expressions are a full topic unto themselves and beyond the scope of this tutorial but there’s a lot of information on the internet on how to use them
Use the Find button to step through all instances of the search text, and the Replace button to replace that text
You can also click Replace All to replace all instances of the search text with one click
Click the green Done button when you’re done to close the Find and Replace dialog
Example Spreadsheet: Make a copy of the example spreadsheet
In this tutorial, I covered how to find and replace in Google Sheets. Want more? Check out all the Google Sheets Tutorials.