Find Shortcut in Google Sheets

When the sheet has a thousand rows and you need to land on a specific value, scrolling is the wrong answer. One keystroke opens a small search box that highlights every match and jumps you straight to the next one.

The shortcut is the same one you’ve probably used in every other app, with the platform’s standard modifier key.

It’s the fastest way to navigate inside a single sheet, and it leads naturally into Find and Replace when you need to swap values too.

Find Keyboard Shortcut in Google Sheets

Find Keyboard Shortcut (Windows Windows)

Ctrl + F

Find Keyboard Shortcut (Mac Mac)

⌘ + F

What this shortcut does

Pressing the shortcut opens a small search box in the top-right corner of the current sheet. Anything you type is matched against the displayed text in every cell.

Matches are highlighted in green as you type. The first match selects automatically, and Enter steps you to the next one. Shift+Enter goes the other way.

How to use it (step by step)

  1. Press the shortcut. A search box appears at the top-right.
  2. Type the value, name, or text you’re searching for. Matches highlight as you type.
  3. Press Enter to jump to the next match. Shift+Enter steps backwards.
  4. The match count (something like “3 of 11”) sits inside the search box so you know where you are.
  5. Press Esc to close the search box.

Alternative method (Find and Replace dialog)

For multi-sheet searches, regex, case sensitivity, or searching inside formulas, open the full dialog with Find and Replace instead. The shortcut is Ctrl + H on Windows or ⌘ + Shift + H on Mac. Edit → Find and replace gets you there from the menu.

The full dialog has the same Find function plus the extras, so some people use it as their default and skip the small search box entirely.

Things to watch for

  • Plain Find only searches the current sheet. If your match is on another tab, switch to Find and Replace and set Search to “All sheets”.
  • It matches displayed text. A cell showing $1,200.00 matches “1200” or “1,200” depending on how Google’s matching strips formatting. The underlying number is 1200, but the displayed string is what gets searched.
  • Formulas are not searched by default. Find looks at the result, not the formula. Use Find and Replace with “Also search within formulas” turned on if you need that.
  • The search box stays open. Sheets remembers your last search until you close the box with Esc. Useful when stepping through results across separate sessions.

Google Sheets keyboard shortcuts

Related Google Sheets shortcuts: