Excel Find Not Working? Why Ctrl+F Can't Find a Value

When Excel Find is not working, the value you want is almost always in the sheet. Something about the search hides it: a selected range, the wrong Look in setting, a ticked option, a leftover format or an invisible space. This guide walks through each cause in the order to check them, so you can fix Ctrl+F in a minute instead of retyping your data.

First, open the full Find options#

Most fixes live behind one button, so open it before anything else. Press Ctrl+F on Windows or ⌘F on a Mac (Ctrl+F also works in Excel for Mac). You can also go to Home > Find & Select > Find. Then click Options >>.

You now see every setting that can block a match:

Excel remembers these settings until you close the program. So a box you ticked an hour ago can still affect your search now.

Is a range selected? Find only searches the selection#

If you select more than one cell before you press Ctrl+F, Excel searches only those cells. This is the quickest cause to miss. You highlighted column B a moment ago, and now Find can't see the value in column D.

The fix: click a single cell, then search again. With one cell selected, Find checks the whole sheet. To check other sheets too, set Within to Workbook.

Look in: Formulas vs Values#

This is the most common reason Ctrl+F can't find a number you can see. The Look in box decides what Excel reads in each cell:

• Formulas reads what's in the formula bar: the formula text, or the number as stored, without its formatting.
• Values reads what the cell shows: the result of the formula, formatted.

Say D5 shows 1,250 but holds =B5*C5. With Look in set to Formulas, Excel searches the text =B5*C5, so a search for 1250 finds nothing. Switch Look in to Values and it finds D5.

Formatting causes the same problem the other way round. A cell showing $1,250.00 stores just 1250. With Formulas, a search for $1,250 fails because the formula bar has no dollar sign or comma. Search for 1250 instead, or switch to Values.

Match entire cell contents and Match case#

These two boxes make the search stricter, so they often hide matches.

Match entire cell contents finds a cell only if your search text is everything in it. A search for North then skips "North Region" and "North " with a space at the end. Untick it to find the text anywhere inside a cell.

Match case finds only the same capitals. With it ticked, inv-1043 won't find "INV-1043". Leave it off unless capitals really matter.

Extra spaces and other invisible characters#

An extra space you can't see is enough to break an exact search. Data copied from websites, emails and other systems often has spaces at the start or end of a cell. "INV-1043 " looks the same as "INV-1043", but with Match entire cell contents ticked, Find won't match it.

To check a cell, compare its length before and after TRIM:

=LEN(A4)-LEN(TRIM(A4))

If the answer is above 0, the cell has extra spaces. TRIM removes spaces at the start and end and turns double spaces between words into one. The TRIM function guide covers the details, and the article on how to remove spaces in Excel shows how to clean a whole column.

One catch: text from web pages can contain a non-breaking space, which is character 160. TRIM doesn't remove it. Replace it first with =TRIM(SUBSTITUTE(A4,CHAR(160)," ")).

Hidden rows, leftover formats and wildcards#

Three more settings can make a value seem to vanish.

Hidden or filtered rows#

With Look in: Values, Find skips hidden rows and columns, including rows hidden by a filter. Either switch Look in to Formulas or show the rows first. The guide to hiding and unhiding rows and columns shows how to reveal everything at once.

A format left over from an earlier search#

If you once searched by format, Excel keeps that format in the dialog. The button next to Format then shows a small preview. Every cell without that format is ignored. To clear it, click the arrow next to Format and choose Clear Find Format.

Asterisks and question marks#

In Find, * means "any characters" and ? means "any one character". So searching for 5* finds 5, 50 and 5 kg, not just cells with an asterisk. To find a real * or ?, type a tilde first: ~* or ~?. The article on wildcards in criteria explains how the same symbols work in COUNTIF and SUMIF.

When Find works but your formula doesn't#

Sometimes Ctrl+F finds the value, but a formula still says it isn't there. Find compares characters, while formulas also compare types. The number 1043 and the text "1043" look identical, so Find matches both. MATCH, VLOOKUP and COUNTIF treat them as different values. If a lookup fails on data that Find can see, read how to fix numbers stored as text.

To search inside a formula, use FIND or SEARCH. Both return the position where the text starts, or #VALUE! if it isn't there:

Wrap SEARCH in ISNUMBER to get a simple TRUE or FALSE for "does this cell contain it?". The FIND function guide and the SEARCH function guide cover both, including wildcards, which only SEARCH accepts. For replacing text once you've found it, see Find and Replace in Excel.

Practise it#

Try the exercise on this page: it shows the exact problem that breaks Match entire cell contents. Then practise FIND and SEARCH in a live spreadsheet, where you type each formula and get instant feedback. Finish with the lesson on cleaning text to remove spaces and stray characters before they break your next search.