• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
How2forU

How2forU

easy answers for you and me

  • Laptop & PC
  • Smartphone & Tablet
  • Office
  • Apps & Software
  • Glossary
  • Blog
  • Hobby
Home » How to find and replace: A Guide for Word, Excel and Google Docs

How to find and replace: A Guide for Word, Excel and Google Docs

07/22/2020 by Emre Peker

By using the find and replace feature, you can quickly search certain words in your document and make changes to them. In the following article we will show you how to use the find and replace tool in Microsoft Word, Excel and Google Docs.

Explore this article: 💡 hide
1 How to find and replace in Word
1.1 Advanced search options in Word
2 How to find and replace in Excel
3 How to find and replace in Google Docs

How to find and replace in Word

You can easily make use of the find and replace tool in Word. Just follow the upcoming steps:

  1. First launch Word or Word Online and open a document.
  2. Then click on the “Home” tab.
  3. Now click on the “Find” on the right side of the bar and select “Replace”. You can also get here by clicking on “Control” and “H” simultaneously.
  4. Now you can type in what you want to search and replace.
  5. Lastly you only have to tap on “Replace” or “Replace All” and you’re done.
The find and replace tool in word (c) Screenshot

Advanced search options in Word

With the advanced search options you can make further adjustments to your searches:

  • Match case: During a regular search Word does not distinguish between upper and lower case. With this search option you can match text in the exact case you used for your search.
  • Find whole words only: With this option you can determine that you only want to look for whole words and not part of words
  • Use wildcards: If you activate this search tool, you can use a “?” to replace any letter of your search request
  • Sounds like: This advanced search option will also find search results that sound similar to your query
  • Find all word forms: With this search option you can find related word forms, for example for the search “go”, it will also show you “went” and “gone”
  • Match prefix: With this you can search for certain prefixes of words and the results will show you all words with the entered prefix at the beginning of a word
  • Match suffix: This is the same function as the “Match prefix” one, only with a suffix at the end of a word
  • Ignore punctuation characters: This search option will allow you to search for words or phrases without taking punctuation into account
  • Ignore white-space characters: Searching words without taking white-space characters into account
Advanced search options in Microsoft Word (c) Screenshot

How to find and replace in Excel

To use the find and replace feature in Excel, the same procedure is needed:

  1. At first, you have to start Excel or Excel Online and navigate into a file.
  2. After that you open the “Home” tab on the bar above.
  3. Then tap on “Find & Select” and choose “Replace”. The keyboard shortcut “Control” and “H” can get you here, too.
  4. Next you type in what you search for and with what you want to replace it. You can additionally use search options like selecting sheets for a better result.
  5. At last, you click on “Replace” or “Replace All” to get your changes done.
The find and replace tool in Excel (c) Screenshot

How to find and replace in Google Docs

Like Microsoft Office programs, Google Docs also has a find and replace tool. Here’s how to use it:

  1. In the first place you have to open Google Docs and a document.
  2. Second navigate onto “Edit” in the toolbar and click on “Find and replace”. The shortcut “Control + H” does work here as well.
  3. Now enter the words you are searching for and the replacement. You also do have helpful options you can enable by ticking the boxes.
  4. After you find the words, just click on “Replace” or “Replace All” to complete your replacement.
The find and replace feature in Google Docs (c) Screenshot

Related Posts:

  • What is the WPS button and where can I find it?What is the WPS button and where can I find it?
  • How to check word count in Google DocsHow to check word count in Google Docs
  • How to find the IMEI number on your iPhoneHow to find the IMEI number on your iPhone
  • How to find the IMEI number on your Android phoneHow to find the IMEI number on your Android phone
  • How to use Subscript & Superscript in Google Docs, Slides and SheetsHow to use Subscript & Superscript in Google Docs,…
  • How to add a text box in Google DocsHow to add a text box in Google Docs

Filed Under: Office Tagged With: Excel, Microsoft Office, Word

Tags

4G 5G Alexa Android app Apple backup Covid-19 DIY documents e-mail Excel Gmail Google Halloween health Instagram iOS iPad iPhone Mac messages messenger Microsoft Office monitor music Netflix network Outlook passwords PDF Samsung screenshot shortcuts Signal Smart Home smartphone Snipping Tool social media Spotify video call WhatsApp WiFi Windows10 Word

Primary Sidebar

Browse our How Tos

Browse by category

  • Apps & Software
  • Smartphone & Tablet
  • Laptop & PC
  • Hobby
  • Office
  • Glossary
Alexa

Alexa: Funny questions you can ask Alexa

01/25/2021 By Michelle Sturhill

Alexa is a voice-controlled virtual assistant home device by Amazon. You can ask funny questions to lighten up your day.

A smart home speaker placed on top of a laptop with a textbox superimposed on it reading "Alexa: How to activate and set up Drop in"

How to activate Alexa Drop in

01/25/2021 By Nadine Noppinger

You can activate and set up Alexa Drop in to use your echo devices as a hands-free kit. To do so, simply follow our step-by-step guide.

How to install font to Mac

How to install font to mac

01/07/2021 By Anita Sommer

Do you want to install new fonts and typefaces to your Mac? We’ll show you how it works and how you can manage your fonts.

Hula Hoop How to exercise

Hula Hoop: How to exercise – Benefits & Tricks for Beginners

01/20/2021 By Anita Sommer

The hula hoop is a trendsetter when it comes to fitness exercises. Turn up the music and get ready to burn some calories.

templates word

How to create templates in Word

01/16/2021 By Sandra Sporer

Creating a custom template in Microsoft Word allows you to use the same document layout without having to recreate it by hand each time.

Internet-Verbindung

What is 4G and 4G+? Simply explained

01/12/2021 By Nadine Noppinger

In the status bar of your smartphone or tablet you will find the characters 4G and 4G+. We will explain to you which details are hidden behind the abbreviations.

Categories

  • 💡 Laptop & PC
  • 💡 Smartphone & Tablet
  • 💡 Office
  • 💡 Apps & Software
  • 💡 Glossary
  • 💡 Hobby

Smartphone & Tablet

How to change app icons on Android & iOS14💡 iPhone: How to recover deleted text messages💡How to share your iPhone calendar💡Sidecar: How to turn an iPad into a secondary Mac display 💡Huawei: How to take a Screenshot 💡 Samsung Galaxy S8: How to take a screenshot 💡 How to find your IMEI number 💡 iPad: How to take a screenshot

Laptop & PC

How to check your CPU temperature 💡 Is there a snipping tool for Mac? 💡 How to take a screenshot on your MacBook 💡 How to connect laptop to monitor

Office

How to fix slow running Windows 10 💡 How to use emojis in Microsoft Outlook 💡 How to password protect a folder in Windows 10 💡Excel: How to change the background color based on the cell value 💡 How to disable startup programs in Windows 10 💡 Word: How to start page numbering on page 3 💡 How to take screenshots on Windows 10

Apps & Software

How to start a video call on viber 💡 Funny questions you can ask Alexa💡Alexa glows green 💡 How to recover deleted WhatsApp messages 💡 Alexa glows yellow 💡 How to delete your Snapchat account 💡 How to merge several PDF files 💡 How to edit PDF files 💡 How to create a Gmail account 💡 Spotify Family: How to share an account 💡 Spotify costs: Free Account vs. Premium

Hobby

How to make homemade hand sanitizer 💡 What to eat after a colonoscopy 💡 How to keep chickens 

Glossary

What is 5G? 💡 What is 4G and 4G+? 💡 What’s Bixby? 💡 What is a VPN connection? 💡 What is the WPS button and where can I find it? 💡 “Thug life”: What does that mean? 💡What is a hashtag? 💡 What is SSID?

Footer

Pages

  • Blog
  • How2forU
  • Imprint
  • Privacy Policy

Copyright © 2021 · Genesis Sample on Genesis Framework · WordPress · Log in