Find and Select in Excel

Updated on December 27, 2023
Article byWallstreetmojo Team
Edited byAshish Kumar Srivastav
Reviewed byDheeraj Vaidya, CFA, FRM

What is Find and Select Tool In Excel?

The Find and Select in Excel tool are useful for finding data as required. Along with the FIND function, the Replace function in excelReplace Function In ExcelThe Replace function is a text function that replaces an old string with a new one. The input required is the old text, new text, and the starting and ending numbers of the characters that need to be more is also handy, which helps find the specific text and replace it with other text(s).

You can download this Find Excel Template here – Find Excel Template

How to use Find and Select in Excel?

–>> If you want to learn Excel and VBA professionally, then ​Excel VBA All in One Courses Bundle​ (35+ hours) is the perfect solution. Whether you’re a beginner or an experienced user, this bundle covers it all – from Basic Excel to Advanced Excel, Macros, Power Query, and VBA.

Let us follow the below steps:

  1. First, under the Home tab is the Find Select Excel section.

    find in excel example 1.1

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

    find in excel example 1.2

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

    find in excel example 1.3

  4. The find also works with fuzzy logic. For example, suppose we give cre in the find section. It will find the relevant words that contain cre.

    find in excel example 1.4

  5. To find the given text in all places of the worksheet, click Find All. As a result, it will highlight the keyword present everywhere in the worksheet.

    find in excel example 1.5

  6. We can match cases also within the worksheet to find case search sensitive data. First, we must click on Options, then select the Match case option.

    find in excel example 1.6

  7. To find cells containing just the characters typed in the Find what box, we must select the Match entire cell contents checkbox.

    find in excel example 1.7

  8. We can also find it through an excel keyboard shortcut. First, we need to press CTRL + F and then the Find Replace tab will appear.

    find in excel example 1.8

  9. If we want to replace something, we can use the Replace tab. For example, we want to replace credit with online payment. Then, we must click Replace All.

    find in excel example 1.9

  10. As a result, it will replace all the cells containing credit with online payment.

    find in excel example 1.10

  11. Then, we must go to Excel’s Go to Special feature.

    find in excel example 1.11

  12. This feature can quickly select all that contains formulas, conditional formatting, constant, data validation, etc.

    find in excel example 1.12

Things to Remember

  • Excel saves formatting that is defined. If one searches the worksheet for data again and cannot find the characters, they must clear the formatting options from the previous search.
  • In the above case, first, we need to go to the “Find and Replace” dialog box, click the “Find” tab, and click “Options” to display options for formatting. Then, we must click the arrow next to “Format” and click “Clear Find Format.”
  • There is no option to replace the value in a cell comment.

Recommended Articles

This article is a guide to Find and Select in Excel. We discuss using Excel Find and Select tool and an example and downloadable template here. You may also look at these useful functions in Excel: –

Reader Interactions

Leave a Reply

Your email address will not be published. Required fields are marked *