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?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Problem using Ctrl + F to find a number on a spreadsheet
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 74,140
- Office Version
- 365
- Platform
- Windows
Duplicate: https://www.mrexcel.com/forum/excel-questions/1091612-finding-number-spreadsheet.html
Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).
Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).
Upvote
0
- Status
