drag a cell down in a column

[William Franks]

when you drag a cell down in a column a drop down list
becomes available and i would like to make the default
option to be copy cell instead of fill series. Is there a
way to do this?

 

[JulieD]

Hi William

haven't really got an answer for you but to cause a autofill list to copy
rather than fill hold your Control key down while you drag (and make sure
you let the mouse go before the control key) - hope this helps somewhat

Cheers
julieD

 

[Gord Dibben]

William

Right-click and drag then hit "c"

Gord Dibben Excel MVP