Technology Tip for the day

Ever need to replace every instance of a word or phrase in a Google document, slides, or sheets, for example, AEA 267 and replace with Central Rivers AEA?  Use Find and Replace All! 

Use find and replace in a document or presentation

  1. On your computer, open a document or presentation in Google Docs or Google Slides.
  2. Click Edit and then Find and replace.
  3. Next to “Find,” type the word you want to find. If you want to replace the word, enter the new word next to “Replace with.”
  4. To see the next time the word is used, click Next. To go back to the previous word, click Prev.
  5. Optional: Narrow your search by using an option below.
  • Match case: Matches only words with the same capitalization.
  • Advanced- Match using regular expressions: In Google Docs, matches words based on regular expressions.
  1. To replace the highlighted word, click Replace. To replace the word every time it’s used, click Replace all.

Use find and replace in a spreadsheet

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Click Edit and then Find and replace.
  3. Next to “Find,” type the word you want to find, If you want to replace the word, enter the new word next to “Replace with.”
  4. To search for the word, click Find. To see the next time the word is used, click Find again.
  5. Optional: Narrow your search by using an option below.
  • Match case: Makes your search case-sensitive.
  • Match entire cell contents: Searches for cells that are an exact match.
  • Advanced- Search using regular expressions: Searches for cells that match a pattern.
  • Also search within formulas: Searches include formulas.
  1. To replace the highlighted word, click Replace. To replace the word every time it’s used, click Replace all.

Check out this short video on how to use Replace All in Google Docs, I love it! 

As always, if you have any questions please don’t hesitate to contact one of our instructional technologists.  Kay Schmalen, Ashley Flatebo, Cari Teske, Sarah Nelson, Cheryl Carruthers, or LeaAnn Peschong

This entry was posted in Tech Tips, Uncategorized. Bookmark the permalink.