What I’m trying to do is to find a given value in my sheet of which I know that it must be the result of a formula in some cell. If I try Find (Ctrl+F), it does not do what I want to accomplish.
What do you suggest?
Hi
I’m not sure I understand, sorry. If you want to find all occurrences of the value (calculated or not) you can try:
Edit▸Find & Replace▸Find: type the searched value▸Other options▸Search in: Values▸Find All
If you only want calculated values, do not close the dialog, keep the selection, Find:=▸tick Current selection only▸Search in: Formulas▸Find All
Regards
As far as Keyboard shortcuts go, Ctrl-F does not provide the option. One needs to use the (Find and Replace) Ctrl-H for access. Not intuitive.