How to Search in Excel: 7 Methods (Find, Filter, FIND, SEARCH) 2026
Learn how to search in Excel using Find & Replace, filters, FIND, SEARCH, MATCH, XLOOKUP, and conditional formatting. Step-by-step shortcuts for fast

To search in Excel, press Ctrl+F (Control+F on Mac) to open the Find dialog, type your text, and press Enter; press Ctrl+H to find and replace. For results you can use in calculations, use functions such as FIND, SEARCH, MATCH, XLOOKUP, or FILTER. Practice with the free Excel practice test on PracticeTestGeeks (500+ questions with answer explanations).
Searching a worksheet feels simple until you open a file with 80,000 rows and realize that Ctrl+F alone won't get you there. The truth is, this guide covers seven distinct ways to find data, and each one solves a different problem. Some are made for quick one-off lookups, others for pulling values into formulas, and a few for spotting patterns across whole tables.
This guide walks through every method, in order of complexity. You'll see when to use Find & Replace, when filters beat searching, how the FIND and SEARCH functions differ (yes, they're different), and how modern tools like XLOOKUP and FILTER have changed how searching works. We'll cover keyboard shortcuts, wildcards, case sensitivity, and the small traps that catch even experienced users โ like why your search returns zero results when the value is clearly there.
Whether you're prepping for the Excel certification exam, sitting an interview test, or just trying to clean up a quarterly report, knowing how to search well is one of the most useful Excel skills you can build.
Microsoft Excel: upcoming dates and official changes
- Jun 30, 2026: Certiport retired the Microsoft Office Specialist 2016 certifications, including MOS Excel 2016, on June 30, 2026. The Microsoft 365 Apps and Office 2019 Excel exams are still available. (certiport.pearsonvue.com)
- Updated Oct 16, 2026: Delivery is now Proctored live-in-the-application exam via Certiport Authorized Testing Centers (in-center or remote-proctored) (previously Proctored live-in-the-application exam via Certiport Authorized Testing Centers).
- Updated Oct 16, 2026: Eligibility is now No formal prerequisites; about 150 hours of instruction and hands-on experience recommended (previously No formal prerequisites; ~150 hours of instruction and hands-on experience recommended (Associate)).
- Updated Oct 16, 2026: Time limit is now 50 minutes (60 minutes seat time) (previously 50 minutes (60 minutes seat time)).
Facts verified Oct 17, 2026 against Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business. Dates that have passed are removed automatically.
- The MOS Excel (Microsoft 365 Apps) exam has 33 to 37 questions. (certiport.pearsonvue.com)
- The MOS Excel Expert (Microsoft 365 Apps) exam has 23 to 27 questions. (certiport.pearsonvue.com)
- Microsoft Office Specialist Excel exams last 50 minutes, with 60 minutes of total seat time. (Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business)
- The passing score for Microsoft Office Specialist Excel exams is always 700 on Certiport's 1 to 1000 scaled score. (certiport.pearsonvue.com)
- After failing a Microsoft Office Specialist Excel exam, candidates must wait 24 hours before the first retake and 48 hours before each later retake, and there is no annual limit on attempts. (Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business)
- Microsoft Office Specialist Excel certifications earned on or after September 23, 2025 are valid for five years; those earned earlier do not expire. (certiport.pearsonvue.com)
- The Microsoft Office Specialist Excel exam is proctored and delivered live in the Excel application through Certiport Authorized Testing Centers, either in person or remote-proctored. (Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business)
- Microsoft recommends that candidates for the MOS Excel Associate (Microsoft 365 Apps) certification have about 150 hours of instruction and hands-on experience with Excel. (Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business)
- Candidates get their MOS Excel score report as soon as they finish the exam, and it can also be viewed in their Certiport profile. (certiport.pearsonvue.com)
Facts verified Oct 17, 2026 against Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business. Dates that have passed are removed automatically.
Microsoft Excel Exam at a Glance
| Item | Detail | Official source |
|---|---|---|
| Number of questions (Excel Associate (MO-210)) | 33-37 questions | certiport.pearsonvue.com |
| Number of questions (Excel Expert (MO-211)) | 23-27 questions | certiport.pearsonvue.com |
| Time limit | 50 minutes (60 minutes seat time) | Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business |
| Passing score | 700 on a 1โ1000 scale | certiport.pearsonvue.com |
| Retake policy | Wait 24h after 1st fail, 48h before each later retake; no annual limit | Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business |
| Validity | Valid 5 years (earned on/after Sept 23, 2025) | certiport.pearsonvue.com |
| Delivery | Proctored live-in-the-application exam via Certiport Authorized Testing Centers (in-center or remote-proctored) | Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business |
| Eligibility | No formal prerequisites; about 150 hours of instruction and hands-on experience recommended | Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business |
| Score release | Score report at end of exam; also in Certiport profile | certiport.pearsonvue.com |
Facts verified Oct 17, 2026 against Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business. Dates that have passed are removed automatically.
Free Excel Study Tools
Interactive Excel resources on PracticeTestGeeks, free to start:
- Free Excel Questions and Answers โ 16 questions with instant scoring and answer explanations
- Excel flashcards โ review key terms and concepts card by card
- Excel study guide โ topic-by-topic overview of what the exam covers
- Excel cheat sheet โ one-page printable summary for last-minute review
Excel Search at a Glance

Method 1: The Find Dialog (Ctrl+F)
Press Ctrl+F on Windows or Control+F on Mac. A small dialog opens. Type what you want to find, hit Enter, and Excel jumps to the first match. Press Enter again to cycle through subsequent hits. That is the basic flow.
Click Options to expand the dialog and you'll see settings that most people never touch. Match case forces a case-sensitive search โ useful when you're hunting for a specific product code that's case-mixed. Match entire cell contents only returns hits where the whole cell equals your query, not partial strings.
The Within dropdown lets you search a single sheet or the entire workbook, and Look in toggles between values (what you see) and formulas (the underlying calculation). That last one matters: if you're searching for a function name, you need to set Look in to Formulas, otherwise Excel will ignore it.
Method 2: Find All
In the same Ctrl+F dialog, click Find All instead of Find Next. Excel lists every match in a panel below โ sheet name, cell reference, value, and formula. Click any row and you jump to that cell. This is gold for auditing: instead of stepping through one match at a time, you see the entire footprint of your search term in one view. Selecting entries in that list selects the matching cells.
Wildcards Save Hours
Use * to match any number of characters and ? to match exactly one character. Searching for Jo*n finds John, Jordan, Jonathon. Searching for ?at finds bat, cat, hat but not boat. To search for a literal asterisk or question mark, prefix it with a tilde: ~*. Wildcards work in the Find dialog and most lookup functions, but FIND treats them as literal characters โ use SEARCH instead when you need wildcard support inside a formula.
Method 3: Find & Replace (Ctrl+H)
Replace works the same as Find but with an extra field for the substitution. The killer feature is Replace All, which swaps every occurrence at once. Combine it with wildcards to clean a dataset quickly. Stripping the prefix "SKU-" from every product code? Find SKU-, replace with nothing, click Replace All. Done.
A trick most people miss: leave the Replace with field empty to delete characters in bulk. Need to remove every space in a column? Find (a single space), replace with empty, hit Replace All. Because Replace All changes every match at once, work on a copy of the sheet first when running mass replacements on important data.
Method 4: Filters
Sometimes you don't need to find one value โ you need to see all rows that match a condition. That's what filters are for. Select your data, press Ctrl+Shift+L to toggle filter arrows, then click any column header dropdown. You'll see Text Filters, Number Filters, or Date Filters depending on the column's content. Pick "Contains" and type a substring; Excel hides every row that doesn't match.
For more advanced filtering, type into the search box at the bottom of the dropdown. This searches the unique values in that column, which is quicker than scrolling. Tick the values you want to keep and click OK. To clear: same shortcut, or click the funnel icon and choose Clear Filter.
When to Use Each Search Method
Use Ctrl+F. Fastest path to a single known value across the active sheet or workbook.
Use Ctrl+H. Edits hundreds of cells at once with optional wildcards.
Use AutoFilter (Ctrl+Shift+L). Best when you want to see every match in context.
Use FIND, SEARCH, MATCH, or XLOOKUP. Required when results feed into another calculation.
Excel Search Options Reference: Find vs Replace vs Functions
| Method | Shortcut or syntax | Scope | What it does |
|---|---|---|---|
| Find (Find tab) | Ctrl+F (Control+F on Mac) | Within: Sheet or Workbook (Selection in Excel for the web) | Finds text or numbers. Find Next steps through matches; Find All lists every match so you can click to jump to it. |
| Replace (Replace tab) | Ctrl+H (Control+H on Mac) | Same Within choices as Find | Replace changes one occurrence at a time; Replace All changes every occurrence that matches. |
| Options: Match case | Options button in the dialog | Applies to the current search | Limits matches to the same capitalization you typed. |
| Options: Match entire cell contents | Options button in the dialog | Applies to the current search | Finds only cells that contain exactly the characters in Find what. |
| Options: Format / Choose Format From Cell | Options button in the dialog | Applies to the current search | Searches by cell formatting, alone or together with a value. |
| Wildcards in Find | ? = one character, * = any number of characters, ~ = literal ? or * | Find and Replace dialog | ~ before ? or * finds the character itself. |
| FIND function | =FIND(find_text, within_text, [start_num]) | Inside one text string | Case-sensitive; does not allow wildcards; returns a position number. |
| SEARCH function | =SEARCH(find_text, within_text, [start_num]) | Inside one text string | Not case-sensitive; allows ? and * wildcards; returns a position number. |
| XLOOKUP wildcards | match_mode 2 | A lookup range | Turns on wildcard matching where *, ?, and ~ have special meaning. |
Sources: Microsoft Support, "Find or replace text and numbers on a worksheet", "SEARCH function" and "XLOOKUP function".
Method 5: The FIND and SEARCH Functions
This is where many users get confused. Both functions look for a substring inside another string, both return the starting position as a number, and both throw a #VALUE! error if the substring isn't found. But they differ in two ways. FIND is case-sensitive; SEARCH is not. And SEARCH supports wildcards, while FIND does not.
Syntax is identical: =FIND(find_text, within_text, [start_num]) and =SEARCH(find_text, within_text, [start_num]). The optional third argument tells Excel where to begin looking. If you omit it, the search starts at position 1.
Practical example. Cell A2 holds "Order-2024-North-1245". To extract the first part, use =LEFT(A2, SEARCH("-", A2)-1), which returns Order. To pull the region, use =MID(A2, 12, SEARCH("-", A2, 12)-12), which starts at character 12 and stops at the next hyphen, returning North. FIND and SEARCH plus LEFT, MID, or RIGHT work in every Excel version.
Method 6: MATCH and XMATCH
If you need to find where a value lives in a range โ not what's inside it โ use MATCH or its newer cousin XMATCH. The classic form is =MATCH(lookup_value, lookup_array, [match_type]). Match type 0 means exact match; 1 means largest value less than or equal to (requires ascending order); -1 means smallest value greater than or equal (requires descending). Use 0 when you need an exact match.
Returns a position number. Combine with INDEX and you have the legacy lookup combo: =INDEX(B:B, MATCH("Widget", A:A, 0)). This pulls the value from column B on the same row where column A equals "Widget". Unlike VLOOKUP, it can return a value from a column to the left of the lookup column.

Function Quick Reference
Case-sensitive search inside a string. Returns position number. No wildcards. Syntax: =FIND(find_text, within_text, [start_num]). Use when case matters, e.g., distinguishing 'Apple' from 'apple'. Throws #VALUE! if not found, so wrap in IFERROR for safety.
Method 7: XLOOKUP and FILTER (Modern Excel)
If you're on Excel 365 or Excel 2021 or 2024, the new dynamic array functions transform how you search. XLOOKUP finally fixes VLOOKUP's biggest weaknesses: it can search left as well as right, defaults to exact match, returns a custom value when nothing's found, and supports approximate matching (match_mode) and binary search (search_mode).
Basic syntax: =XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]). Example: =XLOOKUP("North", A2:A100, C2:C100, "Region not found"). That formula reads cleanly even to someone who's never seen it before โ try saying the same about a nested INDEX-MATCH.
FILTER is the other major advantage. Instead of returning a single value, it returns every row that meets your criteria. =FILTER(A2:D100, B2:B100="Active") pulls every row where column B equals "Active". The result spills down and across automatically. Use its optional third argument, if_empty, to show a message when nothing matches.
If your search returns nothing but you can see the value, check these in order: (1) Are you searching values or formulas? Press Ctrl+F, click Options, change Look in. (2) Is Match case ticked when it shouldn't be? (3) Is Match entire cell contents only ticked, excluding partial matches? (4) Are there trailing spaces? Use TRIM in a helper column to confirm. (5) Are some cells formatted as numbers but contain text that looks numeric? Mixed types break exact-match lookups.
Searching Across Multiple Sheets
Ctrl+F has a setting buried in Options called Within. Change it from Sheet to Workbook and Excel searches every tab in the file. This is essential when you've inherited a workbook with 30 sheets and you have no idea which one contains the value you need. The result list from Find All shows the sheet name, so you can navigate straight to the hit without opening tabs one by one.
For formula-driven cross-sheet searching, you can extend MATCH or XLOOKUP across sheets with INDIRECT, but this can be slow on large workbooks. A cleaner pattern in modern Excel is to consolidate the sheets into one table with Power Query, then search the consolidated table. Power Query lives under Data > Get Data and is the right tool when your search problem has grown beyond a single sheet.
Wildcards in Formulas vs. Find Dialog
Wildcards behave differently depending on where you use them. In the Find dialog, asterisk and question mark always work. In SEARCH, they work. In FIND, they're treated as literal characters. In MATCH with match_type 0, they work. In VLOOKUP/HLOOKUP with exact match (FALSE/0), they work. In XLOOKUP, you have to enable them by setting match_mode to 2. Mixing this up is a common reason a formula returns #N/A even though the value is right there.
Performance and Big Worksheets
A worksheet can hold up to 1,048,576 rows, and searches over very large ranges take longer. Limit a search to the cells you need by selecting them first. For formulas, XLOOKUP supports binary search through search_mode 2 (ascending) or -2 (descending), but Microsoft notes that invalid results are returned if the data is not sorted, so only use it on sorted lookup columns.
Excel Search Skill Checklist
- โMemorize Ctrl+F (Find), Ctrl+H (Replace), and Ctrl+Shift+L (Filter toggle) โ the three shortcuts for finding, replacing, and filtering data.
- โKnow when to switch Look in from Values to Formulas โ searching formula text is required when hunting function names or cell references inside calculations.
- โPractice wildcards thoroughly: asterisk for many characters, question mark for exactly one, tilde to escape a literal asterisk or question mark.
- โUnderstand the FIND vs SEARCH case-sensitivity distinction โ FIND is case-sensitive and rejects wildcards, SEARCH is case-insensitive and accepts wildcards.
- โUse MATCH with match_type 0 for exact-position lookups, or wrap it with INDEX for two-way exact lookups across columns and rows.
- โAdopt XLOOKUP and FILTER if you're on Excel 365 or Excel 2021 โ they replace VLOOKUP, HLOOKUP, INDEX-MATCH, and most array formula tricks.
- โAlways run TRIM and CLEAN on text columns before searching to remove invisible whitespace and non-printing characters that block exact matches.
- โSave a backup copy of the workbook before running mass Replace All operations โ Replace All changes every match at once.
- โWhen searching across many sheets, switch the Find dialog Within dropdown from Sheet to Workbook to cover every tab in one pass.
- โFor repeated searches on the same dataset, build a search box on the worksheet using FILTER with ISNUMBER and SEARCH for live filtering as you type.

Searching By Format, Not Just Value
This one trips most people up because it's hidden behind a small button. Open Ctrl+F, click Options, and you'll see a Format... button. Click it and you can search for cells with a specific font color, fill color, bold style, or number format โ with or without value criteria. Need to find every cell highlighted in yellow? Set the format filter to yellow fill, leave the find field blank, hit Find All. Excel returns every yellow cell in the sheet.
You can also use "Choose Format From Cell" to copy the format of an existing cell as your search template. Click that button, click any cell in your sheet, and Excel grabs its formatting as the filter. This is faster than configuring the format dialog manually when you have a sample cell to point at.
Regular Expressions: The Missing Feature
The Find dialog supports only wildcards (*, ?, and ~), not regular expressions. However, Microsoft 365 now includes the REGEXEXTRACT, REGEXTEST, and REGEXREPLACE functions, which let you do real pattern matching in formulas. They are not available in older perpetual versions of Excel, so use wildcards with SEARCH there.
Searching Within a Selection
If your dataset is huge and you only want to search a portion, first select the range, then press Ctrl+F. This limits the search to that selection, which is handy on a wide sheet when you only want to search one column: select the column header, then press Ctrl+F.
Find Dialog vs Formula-Based Search
- +Find dialog is instant โ no setup, no formulas to author
- +Find dialog works on any sheet without modifying the data
- +Find All shows every match in a clickable list
- +Format-based searches catch what value searches miss
- โFind dialog results are not reusable in calculations
- โFind dialog can't return values, only navigate to them
- โManual searching doesn't scale to repeated reports
- โFormulas are required when results must feed other cells
Building a Search Box on Your Sheet
For dashboards or reports you reuse, build a search experience directly into the worksheet. Drop a cell at the top, label it Search:, name it SearchTerm. Then use FILTER below: =FILTER(DataTable, ISNUMBER(SEARCH(SearchTerm, DataTable[Product]))). As the user types, the matching rows appear below. No macros, no dialogs, no clicks beyond typing.
You can extend this with multiple search columns by combining conditions with the * operator (acts as AND) or the + operator (acts as OR) inside FILTER. Example: =FILTER(DataTable, (ISNUMBER(SEARCH(SearchTerm, DataTable[Product]))) + (ISNUMBER(SEARCH(SearchTerm, DataTable[SKU])))) searches both Product and SKU columns at once. To handle the no-results case, add FILTER's third argument: =FILTER(..., ..., "No matches").
Power Query Search
When your data lives across files, folders, or external systems, Power Query is the answer. Under Data > Get Data, you can load a CSV, Excel file, database, or web source into the Query Editor, then add filter steps that act like supercharged searches. Filter steps in Power Query support multiple conditions and are recorded as steps you can re-run on refreshed data. If you find yourself doing the same search every Monday morning, that's a sign to move it into Power Query and click Refresh instead.
Final Thoughts
Searching in Excel isn't one skill โ it's a stack of seven skills that overlap. Master Ctrl+F for navigation, Ctrl+H for editing, filters for visual analysis, FIND/SEARCH/MATCH for legacy formulas, and XLOOKUP/FILTER for modern work. Know when to reach for each. Practice the wildcards and the format-based variants. The difference between a junior analyst and a senior one often comes down to how quickly they can pull the right value out of a large workbook, and that depends on which search tool you reach for first.
Excel Questions and Answers
Where Excel Search Skills Pay Off
The seven search techniques covered here are everyday skills for anyone who works with large worksheets, and they are useful when preparing for Excel-based assessments too.
If you're preparing for any Excel-based assessment, drill these techniques until they're muscle memory. Open a sample workbook, hide the answer, and time yourself finding it three ways: Ctrl+F, a filter, and a formula. Filters are good for seeing matches in context; formulas are best when results feed other cells. Knowing both, and which to pick when, is what makes searching fast in practice.
Written and edited by Nathan Beja, founder of Practice Test Geeks, with AI assistance. Exam facts are checked against the official sources linked below. Editorial policy
Sources & references
Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy
- learn.microsoft.com โ Retake policy, test delivery, time limit, eligibility ยท verified Oct 2026
- certiport.pearsonvue.com โ Exam format, score validity, passing score, score release, exam information ยท verified Oct 2026