Can Autofill be Defaulted to copy cells instead of fill series

  • Thread starter Thread starter Barry A&P
  • Start date Start date
B

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
 
Hi Barry,

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

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


Gord Dibben MS Excel MVP
 
you get so used to doing things in certain ways, a simple tip in technique
helps

Thanks guys
 
Back
Top