Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.
Worth $20, Absolutely Free
Everyone know that we can find and replace a text with find and replace option. But very few people know that you can use this option to an advance level.
If not, then after reading this post you’ll love this tool. In this post, you will learn some useful examples to use find and replace option to an advance level.
So let’s get started.
First of all, you have to activate advanced options in find and replace. Click on the “Options” button to activate.
With advanced options, you can find values using different parameters. You can specify conditions like searching for specific formulas, cells with specific colors, bold texts, etc.
Here are some useful examples for searching some specific values:
You can find a value from your entire workbook rather than from a single worksheet.
And, you can also replace that value with some other specific value.
This is also a useful option to find a cell which has a specific formula and replace that formula with some other specific formula.
This one is my favorite.
You can find the cell in which you have a cell comment with a specific value.
This will help you in two ways, first, it will search for the cells which have the cell comment and then it will search a specific value in that comment.
Here we have another useful option to find a cell on the basis of value and format of a specific cell.
And, after that, you can also change that value and format.
You can also select a cell to take as a base for replacement.
You can also use the custom format to search and replace cell values and formats.
Using this option you will able to make any type of search basis on the format.
You can search for:
Using find and replace this way can save your lot of time. This can give you an advanced way to search for the values. And the best part is you, you can replace those values.
I hope you like it. Do you have any unique idea to use this option? Please share your view in the comment box, I would love to hear from you.