How to Search and
Replace in Google
Sheets
Open your Google Sheets document and press Ctrl + H (Windows) or Cmd + H (Mac) to open the Find and Replace tool.
In the “Find” field, enter the text or value you want to replace.
In the “Replace with” field, type the new text or value.
Click “Find” to locate instances of the text before replacing them.
Choose “Replace” for a single change or “Replace all” to update all occurrences at once.
Click “Done” to close the tool once you’ve finished making replacements.
