How to find and replace in Google Sheets on Mac, step by step for Chrome

Before the steps, a note on where they come from. Google's help pages describe Sheets as a web app that runs in a browser. I did not find an official Mac app, so these steps assume you use Google Sheets in Google Chrome on your Mac. Other browsers may show the same menus, but Google's pages don't confirm that. If your menu names look different, trust what you see on screen.

Open Find and replace in Google Sheets on Mac

The fastest route is the keyboard. Open your spreadsheet, then press ⌘ ⇧ H. The Find and replace dialog opens. Google's keyboard shortcut list gives this combination for Mac. The same list gives Ctrl + H for Windows and Chrome OS.

If nothing happens, use the menu row inside Sheets. It sits under the file name, and it holds File, Edit, View, and the other menus. Click Edit, then choose Find and replace. The Edit menu at the top of your Mac screen belongs to Chrome, so it will not show this command.

Pick whichever route feels faster. The keyboard wins once your fingers know it. The menu is easier the first time, and it shows you the shortcut next to the command. Check the menu once to confirm the shortcut on your own setup.

Search first with ⌘ F, then decide whether to replace

Plain ⌘ F is for searching. Google's Docs help says ⌘ F searches within a file, and that page lists no shortcut for the Replace dialog. Use ⌘ F when you only want to see where a word appears. Use ⌘ ⇧ H when you plan to change it.

Searching first is never wasted time. A quick search tells you how many places the word appears. It also shows you the words around each match. Those surrounding words often reveal a second spelling you did not expect.

Type your search and step through the matches

Type the text you want to find in the Find box. Click Find to jump to the first match. Click Find again to go to the next occurrence. Google's help page describes this click-again behavior, so you can scan a column one match at a time.

Scanning catches the most common mistake. People search for a short word that sits inside longer words. A search for Ann also matches Anna and Annual. If you want only the cell that says Ann, turn on Match entire cell contents before you replace anything.

Try a quick count. Search for a word that appears in a column you know well. Count the matches the dialog finds, then count them by eye. If the numbers differ, the search is catching something you did not mean to change.

Replace one match or replace every match

Replace changes only the match that is highlighted. Use it when some matches should stay the same. Click Replace, then click Find again to move on. It is slower, but you see each change as it happens.

Replace all changes every occurrence the search finds. It is fast. It also causes trouble when the search is too broad. Run a Find pass first, then click Replace all only when the matches look right.

A simple rule helps. Use Replace for a column with mixed meaning, such as free-text notes. Use Replace all for a column where every match should change, such as a product code that moved to a new format.

The four options that change what Sheets matches

• Match case: finds only the capitalization you typed. Use it to tell IT apart from it.
• Match entire cell contents: finds only cells whose full contents match. Partial matches are skipped.
• Search using regular expressions: treats the Find text as a pattern. Use it for codes, formats, and name flips.
• Also search within formulas: includes formula text in the search. Leave it off if you only want visible text changed.

The options combine. With regular expressions on, special characters such as $ and . change meaning. A search that looks plain can behave differently. Test the pattern with Find before you replace anything.

Worked example: clean a Status column

Say a Status column has Pending in many rows. Another column holds notes like Waiting on pending approval. You want the Status cells to read Open, and you want the notes left alone. Open the dialog, type Pending in Find, and type Open in the replace box.

Turn on Match entire cell contents. Only cells that read exactly Pending will match, so the notes stay put. Click Find, check the highlighted match, click Find again to step through a few more, then click Replace all.

Scan the notes column afterward. Confirm that the phrase Waiting on pending approval is unchanged. If it changed, press ⌘ Z right away, turn on the option you missed, and run the search again.

Regular expression examples for Google Sheets

Google's help page says Sheets uses RE2 for regular expressions. To find a literal dollar sign, turn on Search using regular expressions and type \$ in the Find box. Without the backslash, $ is read as an end-of-cell anchor, which matches a different place.

Here is a name flip that works in Sheets. Suppose a column holds names like Lee, Maria. Turn on Search using regular expressions. Find ^(\w+), (\w+)$ and replace with $2 $1. The cell now reads Maria Lee. The ^ and $ anchors and the $1 and $2 capture groups work only in Sheets, not in Docs.

Test the pattern on a few rows first. A plain \w pattern can miss names with spaces, hyphens, or accents. Regex mistakes are easy to miss because the sheet still looks normal after a bad replace.

Anchors need care too. The ^ marks the start of a cell and the $ marks the end. A search for cat$ matches a cell that ends in cat. It does not match a cell that has cat in the middle.

Common mistakes people make with find and replace

• Searching a short word that sits inside longer words, such as Ann in Anna.
• Leaving Match entire cell contents off when you only want whole cells changed.
• Clicking Replace all before scanning matches with Find.
• Using $1 in a search with regular expressions turned off. Capture groups need the regex option on.
• Typing $ or . in a regex pattern without a backslash.
• Assuming Docs and Sheets handle patterns the same way. Anchors and capture groups behave differently in Sheets.
• Looking for Find and replace in the Edit menu at the top of the Mac screen. It lives in the Sheets menu row.

Undo a bad replace before you make more edits

Press ⌘ Z right away, or choose Edit > Undo. Undo is simplest before you make more edits. Once you type into other cells, the mistake gets harder to trace, and each undo step has to unwind your later work too.

Adjust the options after an undo, not before. Run Find again and check the matches. Then try the replace once more on a few rows. If it still looks wrong, stop and compare against your original file.

Limits to check before a big find and replace

Google's limits page says a Sheets spreadsheet can have up to 20 million cells or 100MB. If your file sits near either limit, a sweeping replace takes more checking. Work on a copy, and check the result in smaller blocks of rows before you trust it.

The 50,000-character limit matters for notes, logs, and pasted text. Google says cells with more than 50,000 characters are removed when an Excel file converts. A replace cannot bring back text the conversion already dropped.

Keep the original file, too. Undo is quick, but a copy is the fallback you can count on for a big cleanup.

Edit offline and in view-only files

Google's offline help says offline work needs Google Chrome or Microsoft Edge, an up-to-date browser, and the Google Docs Offline Chrome extension turned on. It also says not to use a private or incognito window. If you open the file in an incognito window, the dialog may not behave as this page describes.

You also need edit access to change text. In a view-only file, the replace steps will not let you change anything. Ask the owner for edit access, or make your own copy and work on that.

Install Google Sheets as an app in Chrome

If you use Sheets all day, you can install it as a web app from Chrome. Google's Chrome help says to select More, then Cast, save, and share, then Install page as app. Some sites show an install icon in the address bar instead.

To make a shortcut for the installed app, open chrome://apps. Right-click the app, choose Create shortcut, then click Create. Google's find and replace pages do not mention the installed window, so check the menu row once after you install it.

What to do next with find and replace

Once replace works, the next step is usually cleanup. Pick a copy of your sheet, run one replace, check a sample of rows, then move on. If you use Sheets for a specific job, see Google Sheets for data analysts on Mac for clean-data workflows.

Google's keyboard shortcut page lists the Mac and Windows keys for Sheets in one place. Bookmark it if you switch between computers, and check it when a shortcut stops working for you.