WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Find and Select in Excel

Find and Select in Excel

By Madhuri ThakurMadhuri Thakur | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

What is Find and Select Tool In Excel?

Find and Select in Excel is a very useful tool to find data as required. Along with FIND, the Replace function in excel is also quite handy which helps to find 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?

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

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

 find in excel example 1.1

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

 find in excel example 1.2

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

find in excel example 1.3

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

find in excel example 1.4

  • 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.

Example 1.5

  • 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.

Example 1.6

  • 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.

Example 1.7

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

Ctrl + F Shortcut

  • 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.

Find and Replace

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

Example 1.10

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

Example 1.11

  • This can be used to quickly select all that contains formulas, conditional formatting, constant, data validation etc.

Go To Special

Things to remember

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

Recommended Articles

This has been a guide to Find and Select in Excel. Here we discuss how to use Excel Find and Select Tool along with an example and downloadable template. You may also look at these useful functions in excel –

  • Apply Conditional Formatting for Dates
  • How to Find Duplicates in Excel?
  • Find and Replace in Excel
  • Fill Down in Excel
0 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download Find Excel Template

Special Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More