FIND (binoculars) feature

Topic

New Reply

This may be a silly question, but is there a way to change the defaults on the FIND feature? Default of Search: = by rows and default for Look in: = Formulas. 100% of my searches are column,value. Thanks!

Reply | Quote

Replies

I asked this in the old Lounge and the answer was no, but once you have changed to columns/values it stays that way until you close XL.

Reply | Quote

What about recording the find in a macro with the options the way you want, adding an input box to the macro, then running that macro? You could assign that then to a custom button.

Reply | Quote