Configure AutoFill Options when the fill handle is dragged

%3CLINGO-SUB%20id%3D%22lingo-sub-324292%22%20slang%3D%22en-US%22%3EConfigure%20AutoFill%20Options%20when%20the%20fill%20handle%20is%20dragged%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-324292%22%20slang%3D%22en-US%22%3EHello!%3CBR%20%2F%3EWhen%20I%20drag%20the%20fill%20handle%20I%20always%20want%20to%20fill%20WITHOUT%20formatting.%20Once%20I%E2%80%99m%20doing%20it%20lot%20of%20times%2C%20I%E2%80%99d%20like%20to%20know%20if%20it%20is%20possible%20to%20configure%20excel%20to%20fill%20only%20the%20formulas(or%20patterns)%20without%20formatting%20the%20cells%20automatically%2C%20without%20the%20necessity%20of%20clicking%20the%20autofill%20options%20all%20the%20time%20I%20drag%20a%20cell.%3CBR%20%2F%3EThanks!%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-324292%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor
Hello!
When I drag the fill handle I always want to fill WITHOUT formatting. Once I’m doing it lot of times, I’d like to know if it is possible to configure excel to fill only the formulas(or patterns) without formatting the cells automatically, without the necessity of clicking the autofill options all the time I drag a cell.
Thanks!
0 Replies