Find and Replace in Excel - Part 2

Ho guys,

We have already discussed the "Replace" option and today I'm going to write about the "Find" option.
In this option, you can find any data from your worksheet or workbook.  There are lots of options to find data within the whole data.
Let's try this.
I will use the below data to use the "Find" option.

Now you know the way how to open the "Find" window. I will use the keyboard shortcut "Ctrl+F".
Then you will be seen as below.

There is a button in "Find" window, named "Options" If you go there you can be seen more options to be selected what we want to find.
After we entered for the option, the window will expand as below.

Without "Option" we can be only found data via letters, numbers or symbols. But, here there are more. Let's see what will happen when we use these options.

Without "Option", if we enter some data to be found the result will be as below.

When we find the data "1000", we can be seen the result not only "1000" and the results are included "1000". It means if there is "1000" in anywhere of the text, that cell will be fount by this option.

But, assume that we need to find only the values "1000"s from this data. Then what can we do?
Let me show you how.
To do this, we do have to use the "Option" button.

In the options area, there is an option to be selected named "Match entire cell contents". You just click on that option and then find.  The result will be as below.

Try this and the next option will be included in the next post. Thank you.