Skip to content

Find and Replace in Google Sheets

In this article, I will teach you how to use the Find and Replace feature in Google Sheets.

What Is Find and Replace?

Find and Replace is a feature in Google Sheets that allows you to locate a certain text value and immediately replace any or all instances of that value with something else.

Find Example

Take a look at the data below. You have multiple colors listed throughout the range A1:D8.

The goal is to locate all instances of the word Gray. Start by using the keyboard shortcut CTRL+F. This shortcut will open the Find tool in the top right-hand corner of your spreadsheet.

Next, type in the text you want to find.

Google Sheets then highlights all instances of that text value.

Find and Replace Example

Now let’s say that you want to replace all instances of Gray with the alternate spelling of Grey.

To start, you must open the Find and Replace window. You can do this by clicking on the three dots on the Find tool.

You can also open the Find and Replace window using the keyboard shortcut CTRL+H.

Next, type in the text you want to replace in the Find box and add the text you want to do the replacing in the Replace with box.

You can then click on Find to locate the first instance of Gray and click on Replace to switch it with the new text value.

You also have the option to replace all instances of Gray with Grey by clicking on the Replace All button instead.

Google Sheets will let you know how many replacements it makes.

Once finished with your replacements, you can click on Done.

And those are the basics for working with Find and Replace in Google Sheets. Microsoft Excel also has a similar feature.

This Post Has One Comment

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top