[dba-Tech] Excel question, from a reader

"Excel Find and Replace Defaults
How do you permanently change the default values in the Options section of Find and Replace in Excel? I have to manually change the values EACH time I start Excel.

Currently "Search:" is defaulted to "By Rows". I want the default to permanently be "By Columns".

Currently "Look In:" is defaulted to "Formulas". I want the default to permanently be "Values".

My suspicion is this can only be changed by a change in the program code because Microsoft in it's so-called wisdom decided this isn't important for users and failed to put in a "Set As Default" option that allows the user to set the default options desired."

=========I haven't checked any options, but I suspect this can't be done -- maybe through a registry hack, but I don't think I recommend that to the average user. Might be simplier to just bypass the built-in interface and use a custom form to solicit the values. I do think this feature should be more flexible, and maybe it is -- I'll look a bit later, but if someone knows off the top of their head, please share! Thanks!
Susan H.