---
title: "How to Search and Replace in Google Sheets"
h1: "How to Search and Replace in Google Sheets"
description: "Effortlessly update your data in Google Sheets by using the search and replace feature. This tool allows you to quickly find specific text and replace it with new content across your spreadsheet."
route: "/learn/how-to-search-and-replace-in-google-sheets"
canonical: "https://www.layerpath.com/learn/how-to-search-and-replace-in-google-sheets"
---

# How to Search and Replace in Google Sheets

Effortlessly update your data in Google Sheets by using the search and replace feature. This tool allows you to quickly find specific text and replace it with new content across your spreadsheet.

### Interactive Layerpath tour

Canonical tour: https://share.layerpath.com/e/cm6fcrpdc0006l10czqcoof20/tour

Tour id: cm6fcrpdc0006l10czqcoof20

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