# How to Search and Replace in Google Sheets

Viewport: 1920x951 @0.75x

Playback: autoplay=false durationMs=3000 navBar=false arrows=true callouts=true browserBar=false browserTheme=light

1. [Intro] How to Search and Replace in Google Sheets
   - body: This guide provides a detailed walkthrough on how to search for and replace text within a Google Sheets document. Each step is carefully explained to help you efficiently navigate through the process.
   - voiceover: This guide will take you through a detailed walkthrough on how to search for specific values in a Google Sheets document and replace them systematically. Following these steps will help you efficiently find and replace text, enabling more precise data management.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6fcrpdc0006l10czqcoof20/cm6fczwic00010cl72xuzej8q.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
1. step_01 [image] - Click Ctrl+F and enter the value you want to search for
   - source type: IMAGE
   - description: Open Search Function
   - target: (2131.97123883066, 141.4087804889293), rect: top=138.6041717529297 left=2196.666748046875 width=141.33334350585938 height=27
   - hotspots: 1
     - hotspot_01 (2131.97123883066, 141.4087804889293), rect: top=138.6041717529297 left=2196.666748046875 width=141.33334350585938 height=27
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - voiceover: Click Ctrl+F and enter the value you want to search for. This will open the search box where you can type the keyword you wish to find.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6fcrpdc0006l10czqcoof20/cm6fd035c00030cl79jau4whj.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6fcrpdc0006l10czqcoof20/cm6fcry3m0006033p23yq2gmn.png
2. step_02 [image] - Use the arrows next to the search box to view other occurrences of the searched word
   - source type: IMAGE
   - description: Navigate Occurrences
   - target: (2373.4552351033494, 172.48430643521465), rect: top=-1100.8125 left=1586.8333740234375 width=1522 height=1492
   - hotspots: 1
     - hotspot_01 (2373.4552351033494, 172.48430643521465), rect: top=-1100.8125 left=1586.8333740234375 width=1522 height=1492
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - voiceover: Use the arrows next to the search box to view other occurrences of the searched word in your document. This helps you locate all instances of the keyword.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6fcrpdc0006l10czqcoof20/cm6fd036b00040cl78o6n8caa.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6fcrpdc0006l10czqcoof20/cm6fcs4030008033pppdmwo26.png
3. step_03 [image] - Click the three vertical dots in the search box to open additional settings 
   - source type: IMAGE
   - description: Access More Options
   - target: (2441.7276114294355, 176.9083724984903), rect: top=-140.8125 left=1564.8333740234375 width=1522 height=1492
   - hotspots: 1
     - hotspot_01 (2441.7276114294355, 176.9083724984903), rect: top=-140.8125 left=1564.8333740234375 width=1522 height=1492
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - voiceover: Click the three vertical dots in the search box to open additional settings for your search. This provides more control over how your search is conducted.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6fcrpdc0006l10czqcoof20/cm6fd037d00050cl77hg298hf.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6fcrpdc0006l10czqcoof20/cm6fcs550000a033pjutqzwii.png
4. step_04 [image] - Enter the value you want to replace the searched keyword with
   - source type: IMAGE
   - description: Enter Replacement Value
   - target: (1316.48184209677, 502.72771376061706), rect: top=503.5 left=1139.8333740234375 width=280 height=36
   - hotspots: 1
     - hotspot_01 (1316.48184209677, 502.72771376061706), rect: top=503.5 left=1139.8333740234375 width=280 height=36
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - voiceover: Enter the value you want to replace the searched keyword with in the 'Replace with' field. This specifies the new text that will replace your search term.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6fcrpdc0006l10czqcoof20/cm6fd038n00060cl7gelkboxd.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6fcrpdc0006l10czqcoof20/cm6fcs7x1000b033ptig2otq1.png
5. step_05 [image] - Choose the settings you want from the options available,
   - source type: IMAGE
   - description: Adjust Settings
   - target: (1510.499965251949, 681.1666742302642), rect: top=531.1666742302642 left=1015.8332985852825 width=494.6666666666667 height=300
   - hotspots: 1
     - hotspot_01 (1510.499965251949, 681.1666742302642), rect: top=531.1666742302642 left=1015.8332985852825 width=494.6666666666667 height=300 style=STYLE2
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - voiceover: Choose the settings you want from the options available, such as case sensitivity or matching the entire cell. This allows for a more tailored search and replace operation.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6fcrpdc0006l10czqcoof20/cm6fd03a600070cl73vma6elq.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6fcrpdc0006l10czqcoof20/cm6fcs96a000c033piyptffpu.png
6. step_06 [image] - Click 'Done' to replace all occurrences 
   - source type: IMAGE
   - target: (1529.4995396334778, 855.9229187091105), rect: top=821.2562520424439 left=1402.832872966811 width=126.66666666666667 height=69.33333333333333
   - hotspots: 1
     - hotspot_01 (1529.4995396334778, 855.9229187091105), rect: top=821.2562520424439 left=1402.832872966811 width=126.66666666666667 height=69.33333333333333 style=STYLE2
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - voiceover: Click 'Done' to replace all occurrences of the searched keyword with the new value. This final step updates your document with the specified changes.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6fcrpdc0006l10czqcoof20/cm6fd03bk00080cl7a5al96ae.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6fcrpdc0006l10czqcoof20/cm6fcs96a000c033piyptffpu.png
8. [Outro] Proceed to Further Actions
   - body: You've successfully replaced all occurrences. You can now proceed with any other modifications or reviews necessary for your Google Sheets document.
   - voiceover: You have successfully searched for and replaced values in your Google Sheets document. For more advanced operations, consider exploring additional functions and formulas within Google Sheets.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6fcrpdc0006l10czqcoof20/cm6fczykr00020cl793ys5vrn.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM

Source: https://share.layerpath.com/share/cm6fcrpdc0006l10czqcoof20/tour