Can Autofill be Defaulted to copy cells instead of fill series

[Barry A&P]

i know im just being lazy but i use the drag box to copy lots of data and it
always wants to copy as an incremental series and i want it to default to
just copy cells without having to open the autofill menu and select it..

Thanks
Barry

 

[Andy]

Hi Barry,

I had the same problem. All you have to do is press "Ctrl" while you are
dragging the data.

Andy

 

[Gord Dibben]

In addition you can right-click and drag......release and "Copy Cells"


Gord Dibben MS Excel MVP

 

[Barry A&P]

you get so used to doing things in certain ways, a simple tip in technique
helps

Thanks guys