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


Gord Dibben MS Excel MVP

On Sun, 24 Jan 2010 02:16:01 -0800, Andy
wrote:

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