Find and Select Commands in Excel
In this blog post we will see all the options available under “Find & Select” command in excel. This command is available in Home tab, under Editing group as shown in below image. To explain all the options in details we have prepared a dummy data of Sales Performance for the year 2020. In this data we have entered data of few employees as shown in below image. We have applied some formulas, Data Validation, Comments, Conditional Formatting to this data so that it will be easier for you to understand this topic. So, let’s see all these options one by one: Find: This option will help us to find desired value in our existing data. 1. Select the sheet where our existing data is present. 2. Select the command “Find & Select” and select option “Find” from the list of available options. 3. This will open “Find and Replace” dialog box on our screen. 4. We have to provide input value for the field “Find what” which we have to find in our existing data. As an example we will enter ...