To quickly search an Excel spreadsheet, press Ctrl+F in Excel for Microsoft 365 on Windows, type the word or number, and press Enter to jump to a match. On a Mac, press Command+F; to search the whole workbook rather than just the current sheet, open the Find options and set Within to Workbook.
What Excel search does
Excel’s Find feature locates text, numbers, dates, and other cell contents without changing the worksheet. It is useful when you know what you want to locate but do not know where it is—for example, finding a customer name in a contact list, a product code in an inventory, or a particular word in a long report.
By default, Find searches the active worksheet. It moves the selection to a matching cell, so you can inspect the value in its row and column or edit it. If the search term appears more than once, you can move through the matches one at a time. Find is different from filtering: it takes you to matching cells but does not hide the rows that do not match.
Search a worksheet step by step
- Click a cell in the worksheet you want to search. If you have a range selected, Excel may search only within that selection, so click a single cell first when you mean to search the whole sheet.
- Press
Ctrl+Fon Windows orCommand+Fon Mac. You can also use Home > Find & Select > Find on Windows. - Enter the text, number, or other search value in the Find what box.
- Press
Enteror choose Find Next to go to a match. Choose Find All to display a list of matching cells. - Close the Find and Replace window when you are done. The active cell remains at the last match.
For example, to locate order number 10482 in an order log, enter 10482. If the value is present in several rows, Find Next steps through each occurrence. The surrounding row can help you confirm that the match belongs to the right order rather than to a different field that happens to contain the same digits.
Search the entire workbook
A workbook can contain many worksheets, and the default search scope is normally the active sheet. In the Find and Replace window, select Options if the extra settings are hidden, then change Within from Sheet to Workbook. Excel will search across the workbook’s worksheets for the term. Use Find All when you want a list of matches and their sheet locations, rather than navigating through them individually.
The Search setting determines whether Excel checks by rows or by columns. This affects the order in which matches are visited, not which cells qualify. For example, searching by rows checks across a row before moving down; searching by columns checks down a column before moving right. If the first result seems unexpected, check the search order and scope before assuming Excel missed a value.
Workbook search is particularly useful for looking up a code that may appear on a summary sheet, a detail sheet, and an archive sheet. It does not search every possible workbook object: it is intended to find content in worksheet cells, not text inside a chart image or an embedded document. If you need a search limited to a specific area, select that range before searching and confirm the scope shown in the dialog.
Use Find options to narrow results
When a basic search returns too many matches—or none at all—open Options in the Find and Replace window. These settings let you specify what Excel should match and where it should look:
- Match case: Distinguishes uppercase from lowercase letters. Use it when searching for a case-sensitive label or code.
- Match entire cell contents: Requires the whole cell to equal the search term. Searching for
catwithout this option can also find a cell containingcatalog; with it enabled, that longer entry is not an exact match. - Look in: Controls whether Excel searches formulas, displayed values, or available note or comment content. The choices depend on the Excel version and workbook.
- Within: Sets the search scope to the current sheet or the workbook.
- Search: Sets the order in which matches are visited, by rows or by columns.
Look in matters when a cell displays a result produced by a formula. For instance, a cell might show North because its formula returns that word, even though the formula itself refers to other cells. Searching values looks for what the cell displays; searching formulas looks at the formula text. If a visible result cannot be found, or a formula reference is what you need to locate, check this option.
Find partial text and wildcard patterns
Excel can search for a fragment of text, not just a complete cell value. Searching for Mar can find entries such as Marketing or March, unless Match entire cell contents is selected. This is convenient for a distinctive part of a name or description, but it can return unrelated results when the fragment is common.
For a pattern rather than a literal string, Excel supports two wildcards in Find:
*stands for any number of characters. Searching forEast*can find entries that start with East, such asEast Region.?stands for one character. Searching forAB?12can matchABC12orAB712.~escapes a wildcard so Excel searches for it literally. For example, use~*to find an asterisk character instead of treating it as a wildcard.
Wildcards can be helpful in inconsistent data, but use them deliberately. A search for *son may find many names or words ending in those letters, while a search for J? Smith may match more than the one person you had in mind. Review the cell and its context before acting on a result.
Find versus Replace, filters, and sorting
Use Find when you want to locate a value and inspect it. Use Replace when you intend to change matching content: Ctrl+H opens Replace on Windows, and the Find and Replace window includes a Replace tab. Replace All can change many cells at once, so first use Find All or a limited scope to check what will match. Consider saving a copy before making a broad replacement, especially in a workbook used by other people.
Use a filter when you want to show only rows meeting a condition and compare several records together. For example, a filter on a Status column can display every row marked Pending, while Find takes you to one occurrence at a time. In a formatted table, select the header filter arrow and choose or search for a value in that column. Sorting is useful when you want to organize records into an order, such as dates from oldest to newest; it does not search for a specific term.
These tools solve different problems. Find is usually fastest for one known word or code. Filters are better for reviewing all records that share a field value. Sorting helps reveal patterns or put related entries together. A filter or sort also changes how the worksheet is displayed, while a simple Find does not rearrange the data.
Common search problems and fixes
If Excel reports that it cannot find a value you can see, check the scope, the selected range, the Look in choice, and whether Match case or Match entire cell contents is turned on. A search confined to the current sheet will not find a match on another sheet. A search confined to a selected range will not find content outside it.
Other common causes include small differences in the data. A cell may contain a leading or trailing space, a different hyphen, or a number stored as text. Dates may be displayed in one format while the underlying cell value is stored differently. Try a distinctive part of the entry, and inspect the cell in the formula bar. If a cell contains a formula, switch between searching values and formulas as appropriate.
Find settings can persist between searches. If a search suddenly behaves differently from the last one, open Options and check the choices instead of repeatedly changing the search phrase. Also remember that Find locates cell contents; it does not identify a word merely because it appears visually inside a picture, shape, or screenshot on the sheet.
Keyboard shortcuts and version differences
On Windows, Ctrl+F opens Find and Ctrl+H opens Replace. On Mac, the corresponding shortcuts are Command+F and Control+H in Excel for Mac. Keyboard behavior can vary with the Mac’s system settings and keyboard layout, so the Find command in Excel’s menus is a fallback if a shortcut is intercepted.
Excel for the web has a Find command too, but its interface can differ from the Windows desktop dialog. Browser shortcuts may be used by the browser or Excel depending on the command and browser, so use Excel’s Home ribbon and Find command if Ctrl+F opens the browser’s own page search. Browser page search is not a substitute for searching workbook cells: it may only look at content currently rendered on the page.
Frequently Asked Questions
How do I search all sheets in an Excel workbook?
Press Ctrl+F on Windows or Command+F on Mac, open Options, and set Within to Workbook. Then enter the term and choose Find Next or Find All. If the setting is left at Sheet, Excel searches only the active worksheet.
Why does Excel say it cannot find something that is visible?
Check whether the search is limited to a selected range or one sheet, whether Match case or Match entire cell contents is enabled, and whether Look in is set to formulas or values. Spaces, punctuation, or a stored-as-text number can also make the underlying content different from what you expect.
Can I search for part of a word in Excel?
Yes. Enter the fragment in Find and leave Match entire cell contents off. Excel can find that fragment within longer cell contents. You can also use * for any number of characters and ? for one character when a pattern is useful.
How do I find a number or date in Excel?
Enter the number or a recognizable part of it in Find. For dates, the displayed format and stored value can differ, so try the date as it appears on the sheet and check Look in if no match appears. A filter on the relevant column can be more useful when you need to review a range of dates.
How do I search and replace a value in Excel?
Press Ctrl+H on Windows or open the Replace tab in the Find and Replace window. Enter the existing value and its replacement, check the scope, and use Find Next to review matches before choosing Replace. Use Replace All only when you are confident every match should change.
Related
- Monthly Employee Work Schedule Template Excel Guide
- Mirror Image Flip in Excel: What Works and How
- Microsoft Excel Zoom Options: Change Worksheet View
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Align Cell Size in Excel for a Neater SheetTo align cell sizes in Excel, select the rows and columns you want to match, then use Home…
- Google Sheets Zoom: How to Enlarge Your SpreadsheetTo zoom in on Google Sheets, open the spreadsheet in a web browser and choose a larger percentage…
- How to Clear the Cache in Outlook on Windows and MacTo clear Outlook’s local cache, use the option that matches what is causing trouble: in classic Outlook for…
- Biweekly Timesheet Template for Google Sheets: SetupYes—make a biweekly timesheet in Google Sheets with one row for each of 14 days, columns for date,…
- Excel Table Row Number: Get the Position or Sheet RowIn Excel, a table row can mean either its position within the table or its actual worksheet row…
- How to Add a Dropdown List in Excel for Data EntryTo add a dropdown list in Excel for Microsoft 365 on Windows, put your choices in a worksheet…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.