Finding a word in a large Excel spreadsheet is quick with Find (Ctrl + F). You can search one sheet or the whole workbook, list every match at once, match whole cells or case, search formulas or values, and replace words in bulk. For filtering rows or checking whether a cell contains a word, formulas and filters work better. This guide covers all of it in Excel for Microsoft 365, Excel 2021, 2019, 2016 and Excel for Mac.
Quick Answer
Press Ctrl + F, type the word in Find what, and click Find All to see every matching cell, or Find Next to jump through them one by one. Click Options and set Within to Workbook to search every sheet.
Method 1: Find (Ctrl + F)
- Press Ctrl + F (or Home > Find & Select > Find).
- Type the word in Find what.
- Click Find Next to go to the next match, or Find All to list every match with its sheet, cell and value.
- In the Find All list, click a result to select that cell. Press Ctrl + A in the list to select all matching cells at once, for example to highlight them.
Tip: select a range before pressing Ctrl + F to search only that range.
Use the Search Options
Click Options >> to refine the search:
- Within: Sheet or Workbook.
- Search: By Rows or By Columns (changes the order of results).
- Look in: Formulas (what’s typed in the cell), Values (what’s displayed), Notes or Comments.
- Match case: finds “Invoice” but not “invoice.”
- Match entire cell contents: finds cells that contain only that word.
- Format: find cells with specific formatting, such as a fill color.
Wildcards
- * matches any number of characters: inv* finds invoice, inventory, invite.
- ? matches a single character: gr?y finds gray and grey.
- To find an actual * or ?, put a tilde before it: ~*.
Method 2: Replace a Word
- Press Ctrl + H.
- Enter the word in Find what and the new word in Replace with.
- Click Replace All, or Find Next and Replace to go one at a time.
Check Match entire cell contents to avoid replacing the word inside longer words. Press Ctrl + Z to undo.
Method 3: Filter Rows Containing a Word
- Click a cell in your data and press Ctrl + Shift + L to add filters.
- Click the filter arrow on the column header.
- Type the word in the Search box, or choose Text Filters > Contains.
Only rows containing the word remain visible.
Method 4: Formulas to Check for a Word
- Does a cell contain a word? =ISNUMBER(SEARCH(“invoice”,A2)) returns TRUE or FALSE (SEARCH ignores case; use FIND for case-sensitive).
- Count cells containing a word: =COUNTIF(A:A,”*invoice*”).
- Return matching rows (Microsoft 365): =FILTER(A2:C100,ISNUMBER(SEARCH(“invoice”,A2:A100))).
Excel for Mac and the Web
- Mac: press Cmd + F, or use the search box at the top right of the window. Replace is Ctrl + H or Edit > Find > Replace.
- Web: press Ctrl + F inside the workbook (not the browser’s own find), or use Home > Find & Select.
Results can land in hidden rows. Here’s how to hide and unhide rows and columns in Excel.
To count matches instead, see how to count how many times a word appears in Excel.
Troubleshooting
- “Microsoft Excel cannot find the data you’re searching for”: check Within (Sheet vs. Workbook), Look in (Formulas vs. Values), Match case and Match entire cell contents, and make sure you didn’t select a small range before searching.
- Numbers not found: a displayed value like 1,250 is stored as 1250. Use Look in: Values or search for the stored number.
- Hidden rows skipped: Find searches hidden cells when Look in is Formulas, but not always with Values. Unhide rows if needed.
Frequently Asked Questions
Can I search multiple workbooks at once?
Not with Find. Open each workbook and search, or use Power Query to combine them first.
How do I highlight all cells with a word?
Use Find All, press Ctrl + A in the results, close the dialog and apply a fill color. Or use Home > Conditional Formatting > Highlight Cells Rules > Text that Contains.
Does Find search charts or text boxes?
No. It searches cells, notes and comments only.
Summary
- Press Ctrl + F and type the word.
- Click Find All to list every match.
- Use Options for the whole workbook, case and whole cells.
- Use Ctrl + H to replace, filters to show rows, and SEARCH or COUNTIF in formulas.
Kermit Matthews is a freelance writer based in Philadelphia, Pennsylvania with more than a decade of experience writing technology guides. He has a Bachelor’s and Master’s degree in Computer Science and has spent much of his professional career in IT management.
He specializes in writing content about iPhones, Android devices, Microsoft Office, and many other popular applications and devices.