Search Words in Specific Range of Google Sheets

How to search a word in specific range of Google docs spreadsheet?

Explanation

To find words in the specific range of the worksheet,
Step 1: EditFind and replace or press Ctrl+ H.
find google spreadsheet
Step 2: Find and Replace dialogue box appears, type the word you need to find in the text box provided and click the Select data range icon.
find specific range google sheet
Step 3: You will get What data? dialog box. Click and drag the required cell range. Cell reference will automatically get filled in the textbox.
Step 4: Click OK. It will highlight the searched word with blue color box in the selected range .
find specific range google sheet1
Step 5: Just hit the Find button to find further. Finally click Done to close the search.
find specific range google sheet2


Related Topics

Google Docs Spreadsheet Tutorial