How to Quickly Find Data Anywhere in Excel

Add to Favorites
Author: | Edits: don

Finding specific records and/or cells is easy when using the Find tool in Excel. It is located within the Find & Select drop down on the Home tab.

5f64d0b8cef5c59f686f4367165a46ae.jpg

Just click on Find within that drop down (Ctrl + F works too) and the following window will open:

bf7dae42bd8588f41e58e7a2353fae47.jpg072bb79edd120b0d01c6f2b812404b65.jpg

To use Find you simply type the data you are looking for into the Find what text box. Above, I am looking for records which contain the text Tyler. I then click Find Next. Excel then searches all the cells and selects the first cell it finds which contains Tyler.

12598cf4a86f976513871a8271e3bf9e.jpg

Alternatively I could have looked for Jackson and clicked Find All. This returns results based on the search:

1a9c3108831c0356e6e52a4cd0afd254.jpg

It shows me the number of times Jackson was found and what cells it was found in.

If a search is unsuccessful, the following error message will appear:

d05e348d942b2a67f945db965f167063.jpg

As the pop-up advised I will now click the Options button to expand the options for the search.

3c7b26d7e3ab9a2bd5698ed3669811c6.jpg

The Within drop down sets the scope of the search. Currently it is set to Sheet, so only searches within the current worksheet. As searching for email was unsuccessful within Sheet I will change this to within Workbook. I click Find Next and the whole workbook will be searched for email.

3de10cb7cda794b4b4e8d9bcd4f48e92.jpg

As you can see, this search was successful. Find took me to cell C1 on Sheet2 where it found a cell which contained email.

You may have noticed a number of other options within Find that I didnt use. Some of these are beyond the scope of this tutorial but I will give a brief description of these.

  • The Search dropdown doesnt really matter unless your data set is quite large and you want to save time. It just defines how Find will search for your data. (Either column by column or row by row)
  • As all my data is just simple text I dont need to change the Look in drop down. This is required when a workbook has lots of functions and formulas which I will cover how to use in a later tutorial.
  • The match case and match entire cell contents checkboxes are pretty self-explanatory. They are used to refine a search. If you choose to match case, searching for TYLER for example would be different to searching for Tyler. If you choose to match entire cell contents then Excel will look for cells which entire cell value matches what you are looking for. So if you typed Tyl instead of Tyler with match entire cell contents enabled you wouldnt find anything in the dataset I provided.
  • The Format options allow you to refine a search based on a cells formatting as well as its contents but this generally isnt used with Find. It is more commonly used with Find & Replace but this will be covered in a later tutorial as well.

Additional Resources

Vlookup to Return All Matching Results

SEARCH() vs FIND() Function in Excel

Excel 365 Wildcard Vlookup to Return All Partial Matches

Microsoft Find Documentation


Downloadable Files: Excel File 1, Excel File 2

Question? Ask it in our Excel Forum


Our Excel Courses

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.

Similar Content on TeachExcel
Dynamic Data Templates in Excel 365
Tutorial: How to quickly make data templates in Excel that have a customizable number of columns an...
Quickly Switch the Columns and Rows of a Data Set in Excel
Tutorial: How to switch a data set in Excel so that the columns become rows and the rows become col...
Save Hours with the Selection Pane in Excel
Tutorial: How to quickly work on shapes in Excel using the Selection Pane. This includes quickly pr...
Delete All Rows that Contain a Specific Value in Excel
Tutorial: Quickly find all rows in Excel that contain a certain value and then delete those rows. ...
Shade Every Other Row in Excel Quickly
Tutorial: How to shade every other row in Excel quickly without using the Table feature. This method...
Logical Comparison Operators in Excel - How to Compare Things
Tutorial: (Video tutorial's page: Compare Values in Excel - Beginner to Advanced) Logical compariso...