When you press cmd + F on your keyboard, a search box will pop up on the upper-right side of your page. Enter your search term there. Google Sheets will highlight any matching terms in your spreadsheet.
If, instead, you want to search for and replace particular values or text, then you can use the find and replace function built into Google Sheets.
- Go to Edit.
- Choose Find and replace.
Now, input the value or phrase you want to find in the "Find" text box. Then, input what you want to replace it with in the "Replace with" text box.
- Select Replace all.