How to Find and Replace Text in Google Sheets
Sometimes you'll have a word or number you need to find somewhere in your spreadsheet, but you're not sure where it is. Luckily, you can search a spreadsheet using the Find feature.
The Find feature makes it very easy to find specific words and values in a spreadsheet.
Press Ctrl + F.
The first instance of the search phrase is selected.
Click Find again to highlight the next instance and continue moving through the spreadsheet.
If you have a word that appears throughout a spreadsheet that needs to be replaced, you don't have to go cell-by-cell updating it.
Press Ctrl + H.
Here, you can choose which sheets to search in your spreadsheet.
Other options include matching the case of a search, or matching the entire contents of a cell.