Problem using Ctrl + F to find a number on a spreadsheet

Status
Not open for further replies.

brmaa51

New Member
Joined
Jan 24, 2007
Messages
42
I'm using Excel 2016. I have always used Ctrl + F to find a number on a spreadsheet. Now, whenever I try to find a number on a spreadsheet (that I know is there) by using Ctrl +F, a dialog box pops up and states, "We couldn't find what you're looking for. Click Options for more ways to search." When I click on "Options" in the dialog box, I have to change "Look in: Formulas" to "Look in: Values". Is there something I need to set in "Excel Options" so that Excel will always find the data when I use Ctrl + F?
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
Status
Not open for further replies.

Watch MrExcel Video

Forum statistics

Threads
1,099,086
Messages
5,466,545
Members
406,486
Latest member
varmehta

This Week's Hot Topics

Top