Find and Select in Excel

Lest follow the below steps.

1. Under the Home tab, there is the Find & Select excel section

   
   

2. Suppose we want to find a ‘credit card’ from the data given.  We need to go to the Find section and type credit card.

   
   

3. When we press Find Next we get the next result where there is a credit card.

   
   

4. The find also works with fuzzy logic. Suppose we give “cre” in the find section, it will find the relevant words that contain ‘cre’.

   
   

5. In order to find the given text in all places of the worksheet, click Find All. It will highlight the keyword present everywhere in the worksheet.

   
   

6. We can do match case also within the worksheet to find search for case sensitive data. For this, click on Options then select the Match case option.

   
   

7. For finding cells that contain just the characters that are typed in the Find What box, then we have to select the Match entire cell contents checkbox.

   
   

8. Find can be also done through an excel keyboard shortcut. We need to press CTRL + F then the Find & Replace tab will open up.

   
   

9. Now, if we want to replace something we can use the Replace tab. Let’s say we want to replace credit with online payment. Then we click Replace All.

   
   

10. It will replace all the cells containing credit with online payment.

    
    

11. Then go to Excel’s Go to Special Feature.

    
    

12. This can be used to quickly select all that contains formulas, conditional formatting, constant, data validationData ValidationData validation in Excel is used to limit a user's inputs to specified cells or input ranges by offering pre-defined inputs for selection to avoid multiple redundant data inputs.read more etc.