Find and Replace in Microsoft Excel 2016
Step 1. To find an exact word or phrase in your Excel workbook, click on the option Find & Select. Here you have lots of options and you can click on one of them to do whatever you want. Now click on the first option, here on the new window you have the find and replace option in the same window. If you just want to find something click and type the word or phrase, and find one of them or all.
Here you can find your word and find that, if there are a lot of that word you can click on Find all. Step 2. Through to this step you can use more options to find & replace the exact word and phrase in your worksheets. When you click on Options, you see some new options that help you to find the specific word or phrase in a specific place. Here at first, you can select the following options:
Formats: – formats help you to find a text with a specific format and characteristic such are number, alignment, font, border, fill, and protection Within (sheet or workbook): – this option let you search the world in all workbooks or just in one worksheet. Search (By rows, By column): – when you have any table of contents, and you want to search something entire that table here you can select that you want to find a word or phrase in rows or columns. Look in: – here you have three other options such are formulas, values, and comments. You can look and find your word from one of these options
Replace the Incorrect Word with the Correct one
Step 3. In this step, you can use the replace option to remove useless words or incorrect words. And put the correct one in the same place. Here at first type, the old word or phrase then go to replace and type the new word or phrase. Then you can find and replace them. Here you can use the same options of Find, and you can replace one of the world or all of them.
Conclusion
Its all about that how to find & replace a word or phrase in workbook or worksheets of Microsoft Excel 2016. In this article, I focused on those important points that need to be explained. And by using these options you don’t need to read all the content. To find the words to change them or remove them. Microsoft excel gave you this opportunity to find and replace your words automatically and quickly. If you have any question write down and comment it. Thanks for following us.
