auto fill options

V

vic

Can you set the default to Copy Cells rather than the Fill Series? And how do
you do that.... thank you in advance.
 
J

Jim Rech

I don't think so but an easy next best solution is to hold Ctrl down as you
drag the fill handle.
 
E

elfmajesty

Funny enough - I'm trolling the board to see if I can switch my fill handle
to go BACK to doing a regular fill. Somehow, it is stuck on Copy Cells (have
no idea why) and I cannot autofill my formulas anymore by dragging the fill
handle! Any suggestions??

Thank you.
 
G

Gord Dibben

Tools>Options>Calculation. Make sure you are on Automatic.


Gord Dibben Excel MVP
 
Top