How To Find And Replace Google Sheets

Last Updated on December 5, 2022 by Jake Sheridan

In this tutorial, you will learn to find and replace in Google Sheets.

A cool trick in Google Sheets is you can find a particular word and replace it across the entire Google Sheets.

To have a better understanding, we can get started by using real-life scenarios to help you understand how to find and replace in Google Sheets.

How To Find And Replace Google Sheets

Before we begin we will need a group of data to be used to create the waterfall chart.

Step 1

Make sure your group of data is displayed in a clean and tidy manner.

Step 2

To find and replace, simply select ‘Edit’ then select ‘Find and replace’.

Step 3

After you selected, a pop-up box will appear in the middle of your screen. Now you can find and replace a certain word. In this example, we want to replace Apple with Blueberry. We also want to match the entire cell content to make sure the correct cells are replaced. Once you are done, select ‘Replace all’.

Step 4

After you are done, the ‘Apple’ cells are replaced with ‘Blueberry’.

Summary

That’s all there is to it. You are welcome to copy the example spreadsheet below to see how it is done. The most crucial lesson is to enjoy yourself while doing it.

In this tutorial, I covered how to find and replace in google sheets. Want more? Check out all the Google Sheets Tutorials.