How to Search in Google Sheets

Searching in Google Sheets helps you quickly find specific data, replace values, and navigate large spreadsheets efficiently.

Use Find (Ctrl+F)

Press Ctrl+F (Windows) or Cmd+F (Mac) to open the Find dialog. Type your search term and press Enter to cycle through matches.

💡 Matches are highlighted in green for easy identification.

Press Ctrl+H to open Find and Replace. Enter the search term and the replacement value. Click "Replace all" to update all instances at once.

Select a range before searching to limit the search to that area. This is useful for large spreadsheets with multiple sections.

In Find and Replace, expand "More options" to enable search within formulas, match case, or match entire cell contents.

💡 Search within formulas is helpful for finding specific function references.

Yes. Google Sheets supports regex in Find and Replace when you enable "Search using regular expressions".

Find and Replace searches the entire spreadsheet by default, including all sheets.