Excel find and replace initial settings

%3CLINGO-SUB%20id%3D%22lingo-sub-1214973%22%20slang%3D%22en-US%22%3EExcel%20find%20and%20replace%20initial%20settings%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1214973%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EEvery%20time%20I%20use%20control%20%2B%20F%20to%20find%20something%20in%20excel%2C%20the%20initial%20settings%20are%20%22Look%20in%3A%20Formulas%22%20the%20box%20%22match%20entire%20cell%20contents%22%20is%20checked.%20I%20doubt%20I've%20ever%20actually%20used%20these%20settings%20so%20I%20was%20wondering%20if%20there%20was%20a%20way%20to%20make%20my%20initial%20settings%20so%20that%20whenever%20I%20use%20control%20%2B%20F%2C%20the%20settings%20are%20%22Look%20in%3A%20Values%22%20and%20%22Match%20entire%20cell%20contents%22%20is%20not%20checked%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1214973%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EApp%20Services%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello,

Every time I use control + F to find something in excel, the initial settings are "Look in: Formulas" the box "match entire cell contents" is checked. I doubt I've ever actually used these settings so I was wondering if there was a way to make my initial settings so that whenever I use control + F, the settings are "Look in: Values" and "Match entire cell contents" is not checked?

 

Thanks for your help.

0 Replies