Can Autofill be Defaulted to copy cells instead of fill series
 

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

Can Autofill be Defaulted to copy cells instead of fill series
 

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

Can Autofill be Defaulted to copy cells instead of fill series
 

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

Can Autofill be Defaulted to copy cells instead of fill series
 

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

Thanks guys

"Gord Dibben" wrote:

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

.