Forum Discussion
Find & Select
Is it possible to have the default in Find set to Values instead of Formulas
Yes but I don't usually look for cells containing part of a cell. I would search dining if I wanted to see all the dining tables, chairs, and benches in this file. I want to know if it is possible for the default in the "Look In" box to be Values
Thanks
Nope, there is no such setting. You may use macro on workbook run to change the settings, first I found is quite old Change Excel Find & Replace Options Defaults (excelforum.com), but you may google for more samples if such variant works with you.