Perform a Quick Search in Google Sheets
When you want to find text, a number, or a date in your current sheet, you can perform a quick search in Google Sheets using the keyboard.
Use an Advanced Search in Google Sheets
Maybe you need to do more than a simple search in Google Sheets. You might want to look within formulas, find an exact match, or look in the entire workbook. This is when an advanced search using the Find and Replace tool is the way to go.
Press Ctrl+F on Windows or Command+F on Mac. Then, select the three dots for More Options on the right side of the box.Select Edit > Find and Replace from the menu.Open the Help tab, type “Find” into the search box, and choose Find and replace from the results.
If you plan to replace what you find with something else, you can enter it into the Replace with box. Otherwise, leave that field empty.
All sheets: Use this option to search the entire workbook.This sheet: Use this option to search only the current, active sheet.Specific range: Use this option to search within a cell range. Add the range into the box that appears to the right or pick the grid icon and then select the range in the sheet using your cursor.
Match case: Use this to perform a case-sensitive search. Match entire cell contents: Use this to find an exact match. Search using regular expressions: Use this to find a pattern match. Also search within formulas: Use this to include formulas in your search. Also search within links: Use this to include links in your search.
If the tool finds a result in a hidden cell, you’ll see this display at the bottom of the search box. This lets you then unhide that row or column to see the result.
