How to Find and Replace in Google Sheets?

How to Find and Replace in Google Sheets?

Google Sheets are known for their dynamic workbooks which keep track of all the numerical calculations carried out by either a single user or by multiple users in the application. But once the data starts to get accumulated over some time, it becomes difficult to find specific values or even make changes to a particular value that was created long back. Most times, enterprises run into such problems, and the Find and Replace feature of Google Sheets acts savior in such difficult instances.

The Find and Replace feature of Google Sheets enable the user or users to get off the burden of searching through the entire set of workbooks to find a small detail. Instead, it let the users get hold of the required information in just a matter of seconds. It not only just finds the portion, but also provides the option to replace the part with any other appropriate part. 

It is an extremely user-friendly feature as it let the users search using expressions, cells, formulae, wildcards, etc. along with the regular text. The following section applies the use of this feature in multiple instances.

How to use Find and Replace in Google Sheets?

Method 1.

Step 1. Click open the Google Sheets application on your device.

How to Find and Replace in Google Sheets

Step 2. Open the sheet in which you want to find any particular value or number.

How to Find and Replace in Google Sheets

Step 3. Click on the Edit option present at the top menu bar.

How to Find and Replace in Google Sheets

Step 4. From the drop-down menu that appears, click on the Find and Replace option.

How to Find and Replace in Google Sheets

Step 5. On clicking the Find and Replace option, a Find and Replace dialog box appears.

How to Find and Replace in Google Sheets

Step 6. Enter the text that you want to find at the prescribed slot or space in the dialog box.

How to Find and Replace in Google Sheets

Step 7. Enter the replacement text, if any, in the dedicated space.

How to Find and Replace in Google Sheets

Step 8. Customize the search according to whether the entire sheets have to be searched or not.

How to Find and Replace in Google Sheets

Step 9. Also, optimize the searching process by choosing the required checkboxes in the bottom part of the dialog box.

How to Find and Replace in Google Sheets

Step 10. Click Find, if you don’t want to replace anything. If you have entered any search optimizations, click on the Done option at the bottom right corner of the dialog box.

How to Find and Replace in Google Sheets

Step 11. The searched text will now be highlighted in the sheet to get noticed easily.

How to Find and Replace in Google Sheets

Method 2

The second method to find and replace a part of the Google Sheet involves a keyboard shortcut.

Step 1. Open the Google Sheets application on the concerned device.

How to Find and Replace in Google Sheets

Step 2. Click open the document in which the search and replacement have to be conducted.

How to Find and Replace in Google Sheets

Step 3. Using the keyboard, click CTRL+H. The Find and Replace dialog box appears instantly.

How to Find and Replace in Google Sheets

Step 4. Fill in the particulars in the dialog box and press Done.

How to Find and Replace in Google Sheets

Step 5. The searched content is now available as highlighted in the Google Sheet.

How to Find and Replace in Google Sheets

Method 3.

The third method also involves a keyboard shortcut. But the difference lies in the fact that this shortcut does not take the user to the Find and Replace dialog box.

Step1. Open the Google Sheets application on the device.

How to Find and Replace in Google Sheets

Step 2. Open the sheet in which the work has to be done.

How to Find and Replace in Google Sheets

Step 3. On the keyboard, press CTRL+F. A generic Find box appears on the top right side of the sheet. The user can type anything that has to be searched into this Find box.

How to Find and Replace in Google Sheets

Step 4. Type in the word that has to be searched. When you start typing itself the number of similarly spelled words present in the sheet is shown at the right end of the Find box. Once you finish typing, the total number of the spelled word is shown at the right end of the Find box.

How to Find and Replace in Google Sheets

Step 5. All the instances of the word that you have searched presently in the sheet are now highlighted and are easily findable.

How to Find and Replace in Google Sheets

Step 6. The user can now scroll up and down the sheet to find the instances of the searched word occurring and choose which one that you were intending to act. The only difference that this method has from the other two methods is that there is no instant replacement option available for this method. The user will have to manually scroll up to the target word and change it. Also, as the searching cannot be optimized and narrowed down like the other two, most times, this method picks out a greater number of results.