• 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:

  • How to Restart Your iPhone: A Step-by-Step Guide
    How to Restart Your iPhone: A Step-by-Step Guide
  • How to Buy Bitcoin: A Step-by-Step Guide
    How to Buy Bitcoin: A Step-by-Step Guide
  • How to Unlock Your iPhone: A Step-by-Step Guide
    How to Unlock Your iPhone: A Step-by-Step Guide
  • How to Reset Your iPhone: A Comprehensive Guide
    How to Reset Your iPhone: A Comprehensive Guide
  • How to Clear Your Cache – Step-by-Step Guide
    How to Clear Your Cache – Step-by-Step Guide
  • How to check word count in Google Docs
    How to check word count in Google Docs
  • How to use Subscript & Superscript in Google Docs, Slides and Sheets
    How to use Subscript & Superscript in Google Docs, Slides…
  • How to add a text box in Google Docs
    How to add a text box in Google Docs
  • What is the WPS button and where can I find it?
    What is the WPS button and where can I find it?
  • How to find the IMEI number on your iPhone
    How to find the IMEI number on your iPhone

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

Tags

Alexa Android app Apple Covid-19 definition DIY documents e-mail Excel Facebook food Gaming Gmail Google Halloween hardware health Instagram iOS iPad iPhone Mac messages messenger Microsoft Office music Netflix network Outlook Samsung screenshot shortcuts Signal Smart Home smartphone social media Streaming Telegram video call WhatsApp WiFi Windows10 Word Zoom

Primary Sidebar

Browse our How Tos

Browse by category

  • Glossary
  • Smartphone & Tablet
  • Laptop & PC
  • Hobby
  • Office
  • Apps & Software
Teaser image for the article "USB: Difference between charging and data cable"

USB: This is the difference between charging and data cable

05/12/2021 By Jennifer Fritsch

The difference between a USB data cable and a USB charging cable is not obvious to everyone at first glance. We explain the differences between the two and how to tell them apart.

how to deactivate call forwarding

How to Deactivate Call Forwarding on Your Phone

02/09/2023 By Nadine Noppinger

Deactivating call forwarding on your phone is a simple process that can usually be done in just a few steps. Depending on your phone model and carrier, the steps for deactivating call forwarding may vary slightly. In this article, we will go over the most common methods for deactivating call forwarding on both Android and iPhone devices.

How to Zip a File: Windows, Mac and Mobile

02/03/2023 By Nadine Noppinger

Zipping a file is a common process for compressing large or multiple files into a single, smaller file called a zip file. The zip file can be easier to manage and share, and it takes up less storage space. The process of zipping a file is different depending on the operating system you are using, […]

resetting tinder account

Resetting Your Tinder Account: 2 Options

02/09/2023 By Nadine Noppinger

If you’re looking to start fresh on Tinder or if you’re experiencing technical issues with your account, resetting your Tinder account may be the solution. In this article, we’ll go over the steps for resetting your Tinder account, so you can start using the app again with ease.

how to identify a fast charger

How to Identify a Fast Charger for Your Device

02/09/2023 By Nadine Noppinger

Fast chargers are designed to quickly and efficiently charge your device, often in less time than it would take to charge with a standard charger. With so many fast chargers available, it’s important to choose one that is compatible with your device and meets your charging needs.

how to remove tiktok profile picture

How to Remove TikTok Profile Picture

02/09/2023 By Nadine Noppinger

If you want to change the appearance of your TikTok profile or if you have uploaded an incorrect profile picture, you can remove your profile picture at any time. In this article, we’ll go over the process for removing your TikTok profile picture, so you can make the necessary updates to your TikTok profile.

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 © 2023 · Genesis Sample on Genesis Framework · WordPress · Log in