In that case, you will need to press the Replace button (if you want to manually replace the word one at a time) or Replace all button (if you want to replace all occurrences of the word at once).Īlso note that you can use the Find and Replace dialog box to find what you need in the current sheet, all the sheets, or even a selected range of cells.
Note: After Step 6, if you want to replace the word with something else, you can enter the new word next to the label “ Replace with”. Once you are done searching (and/or replacing), press the ‘Done’ button to close the Find and Replace dialog box.If you press the Find button after you see this message, Find and Replace will loop back to the first occurrence of the word.Looping around” at the bottom of the dialog box. When you reach the last occurrence of the word, you will see a message that says “ No more results found.If there are more instances of the word in the sheet, clicking on Find each time selects the next cell containing the word.This will select the first cell containing the word.In the input box next to the label “ Find”, type the word that you want to search for (In our example, we can type the word “ Paul”, since that’s what we’re looking for).Alternatively, you can open this box directly by pressing CTRL+H (if you’re on a PC) or Cmd+H (if you’re on a Mac). This will open the Find and Replace dialog box.Click on the Edit menu from the menu bar.
Here are the steps you need to follow in order to find them: Now let us say we want to find the cells containing the name “ Paul”. However, we’ve kept it simple so as to make the tutorial easy to understand. The dataset shown is a very simple one, and you can obviously find what you need by just looking at it. Let us assume we have the following data in a single worksheet: In case you need a little more control over how you can search for data in Google Sheets, then you can use the full-blown find and replace dialogue box functionality. This is a really quick method morning and you can use to find out if there are any cells that match the text string and go through these ones by one. You can also visually scan the result as all the matching cells are highlighted in the green color. If you want to go through each of the cells one by one, you can use the downward-pointing and upward-pointing arrow in the Find field. The above steps would highlight all the cells that have the matching text string.
Use the keyboard shortcut Control + F (for Windows) and Cmd + F (for Mac).Suppose you have a data set as shown below, and you want to find out all the cells that have the name ‘Mark’ in it:īelow are the steps to search in Google Sheets using the find option: use this option when you want to quickly search the entire worksheet hey and highlight the cells that have the matching string. Note that this is a part of the final replacement option that we are going to cover in the next section.