6

I have an Excel spreadsheet that has values being returned by formulas. When attempting to seach for these values using the keyboard combination CTRL-F, it returns that it cannot be found even though it exists.

How can i use CTRL-F to find the values? The version of Microsoft Excel is 2010.

Improve this question
2
  • Do you have the exact value or do you need the full Ctrl+F functionality?
    – Paul
    Commented Mar 3, 2014 at 3:37
  • @Paul - panhandel's answer helped resolve the issue
    – Motivated
    Commented Mar 3, 2014 at 18:00

1 Answer 1

Reset to default
6

The find window has options, craftily hidden behind the "Options > >" button to look in "formulas", "values", or "comments". The default is formulas, so just switch that to values.

Improve this answer
1
  • It is indeed hidden away.
    – Motivated
    Commented Mar 3, 2014 at 18:00

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .