If you need to update specific data throughout your spreadsheet, it can be time-consuming. But with a built-in tool, you can find all instances of that data and replace them at one time in Google Sheets.

You may need to change a price or other attribute for a product, a dollar amount or item number, or a vendor’s name or location. Using the Find and Replace feature along with any necessary parameters, you can locate and change what you need in Google Sheets quickly.

Use Find and Replace in Google Sheets

Visit Google Sheets and open the spreadsheet where you want to locate and update your data. Click Edit > Find and Replace from the menu.

When the Find and Replace window displays, enter the data you want to locate in the Find box. Then, in the Replace With box, enter what you want to update it with.

Enter the Find and Replace data

Use the Search drop-down box to select where you want to look. You can choose All Sheets, This Sheet, or a Specific Range.

Choose where to search

To review and confirm the data before replacing it, click “Find.” This will highlight the first instance of the data you enter in the Find box. Continue to click “Find” to see each subsequent instance of the data. When all results have been found, the tool will start from the beginning, and you’ll see the message “No more results found, looping around” appear in the Find and Replace window.

No more results found

If you review your data and determine that all instances should be replaced, click “Replace All.” You’ll then see the number of items replaced in the Find and Replace window and your data updated.

Replaced all data

If you only want to update a certain instance rather than all of them, you can click “Replace” for the particular instance found and highlighted. You’ll see your data update and the details in the Find and Replace window.

Replaced specific data

Add Search Parameters

In the Search section of the Find and Replace window, you have additional options you can use to find your data. These can be helpful for locating something specific or when data is entered in various formats throughout your sheet.

Add search parameters in Google Sheets

Match Case: This is ideal when searching for text that uses upper and lowercase letters. You can match the case exactly, so you find the correct data.

Match Entire Cell Contents: To avoid finding and replacing data that’s similar throughout your sheet, you can locate something in particular by matching all contents within a cell.

Search Using Regular Expressions: If you want to use regular expressions to get more precise or varied results, you can check this box.

Also Search Within Formulas: To include data that’s within formulas instead of only cell contents, mark this search option.

Updating the data in your sheet doesn’t have to be a time-consuming process. Remember this tip for using Find and Replace the next time you want to update your Google Sheets.

And if you want to find and link data together, take a look at how to use VLOOKUP in Google Sheets.

Profile Photo for Sandy Writtenhouse Sandy Writtenhouse
With her B.S. in Information Technology, Sandy worked for many years in the IT industry as a Project Manager, Department Manager, and PMO Lead. She learned how technology can enrich both professional and personal lives by using the right tools. And, she has shared those suggestions and how-tos on many websites over time. With thousands of articles under her belt, Sandy strives to help others use technology to their advantage.
Read Full Bio »