Finding a number on a spreadsheet

[brmaa51]

I'm using Excel 2016. I used to be able to find a number on a spreadsheet without any difficulty. Now, whenever I try to find a number on a spreadsheet that I know is there, 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", I have to change "Look in: Formulas" to "Look in: Values". What do I need to set so that Excel will always find the data?

 

[Rickhopes74]

I'm using Excel 2016. I used to be able to find a number on a spreadsheet without any difficulty. Now, whenever I try to find a number on a spreadsheet that I know is there, 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", I have to change "Look in: Formulas" to "Look in: Values". What do I need to set so that Excel will always find the data?

Hey. The easiest search for information in the table is "CTRL + F", after pressing this combination a window will appear where you can enter the data you need to search.

 

[brmaa51]

I have used Ctrl + F every time.