How to Find and Replace in Google Sheets

Whether you're cleaning up a dataset, fixing a repeated error, or updating values across hundreds of rows, Find and Replace in Google Sheets is one of the most time-saving features you'll use. It works faster than scanning cells manually and gives you precise control over what gets changed — if you know how to use it well.

Opening Find and Replace in Google Sheets

There are two ways to launch the tool:

• Keyboard shortcut: Press Ctrl + H on Windows/Chromebook, or Cmd + Shift + H on Mac
• Menu path: Go to Edit → Find and Replace

A dialog box will appear with fields for your search term and replacement text, plus a set of options that control how the search behaves.

The Basic Workflow

1. Type the text or value you want to locate in the Find field
2. Type the replacement in the Replace field
3. Click Replace to change one instance at a time, or Replace All to update every match at once
4. Click Done when finished

That covers most everyday use cases — fixing a misspelled name, swapping an old product code for a new one, or replacing placeholder text across a sheet.

Find and Replace Options Explained

The real power comes from the checkboxes inside the dialog. Each one changes what the tool matches and how.

When "Match Entire Cell Contents" Matters

By default, Google Sheets will find your search term anywhere inside a cell. So searching for "cat" would also match "category" or "concatenate." Enabling Match entire cell contents restricts matches to cells that contain only that term — nothing before or after it. This is especially useful when working with IDs, codes, or standardized labels.

Searching Within Formulas

If you need to update a formula — say, replacing references to one named range with another — check Also search within formulas. Without this option, the search ignores formula syntax and only looks at what the cell displays.

Using Regular Expressions for Advanced Searches

Regular expressions (regex) allow you to search by pattern rather than exact text. This is a more advanced feature, but even simple patterns can save significant time.

A few practical examples:

• ^s+ — matches leading spaces in a cell
• d+ — matches any sequence of digits
• [aeiou] — matches any vowel

To use regex, check Search using regular expressions in the dialog. Keep in mind that regular expressions follow a specific syntax, and a small typo in the pattern can return no results or unintended matches.

Controlling the Search Scope

By default, Find and Replace searches the entire active sheet. You have a few options for narrowing that scope:

• Selected range only: Highlight the cells you want to search before opening the dialog. Google Sheets will limit the search to that selection.
• All sheets: Use the Search dropdown inside the dialog to switch from "This sheet" to "All sheets" — useful when the same error appears across multiple tabs.

🔄 Replacing Values vs. Replacing Formula Text

This is a common source of confusion. If a cell contains a formula like =SUM(A1:A10) but displays the number 250, a standard find-and-replace on "250" won't affect that cell — because the displayed value comes from the formula, not stored text.

To modify the formula itself, you need to enable Also search within formulas. Be cautious here: changing formula content can break calculations if the replacement text isn't valid formula syntax.

How Results Vary by Workflow

The same Find and Replace dialog behaves differently depending on what you're working with:

• Simple text data (names, labels, notes): Straightforward — matches are predictable and replacements are clean.
• Mixed data types (text alongside numbers, dates, formulas): Requires more care. Numbers formatted as text behave differently than true numeric values.
• Large datasets with thousands of rows: Replace All is fast, but there's no built-in preview of every change. Undo (Ctrl + Z) works immediately if something goes wrong, but reviewing changes in a large sheet afterward can be time-consuming.
• Collaborative sheets: Changes made via Find and Replace are tracked in the version history, so they can be reviewed or reversed — but collaborators editing simultaneously may not see the changes in real time until their view refreshes.

What Doesn't Have a Undo-Proof Safety Net

Google Sheets does support undo, and version history lets you roll back to earlier states. But Find and Replace doesn't offer a built-in preview of all affected cells before committing changes. If you're working with complex or sensitive data, it's worth duplicating the sheet first — or at minimum, doing a test Find pass before running Replace All.

The right approach to Find and Replace really depends on the complexity of your data, how many sheets are involved, whether formulas are in play, and how comfortable you are with features like regex. Simple use cases are straightforward; larger or formula-heavy sheets introduce variables that are specific to how your data is structured.