Hi Barry,

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

Andy

"Barry A&P" wrote:

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