Office Excel 2003 allows copying of cell contents with Cell Drag and Drop.
This works flawlessly for me with text, but with numbers, it automatically
creates a series, incrementing by one. I have to manually choose the Copy
Cells button from the Auto Fill Options box that comes up after the Drag and
Drop.

I seldom have to create series increments, but have to copy cells many
times, like general ledger account numbers, that cannot be incremented.

Can the default for the Auto Fill Options box be changed to Copy Cell
instead of Fill Series?

Thanks.
--
ed

I assume you mean text with numbers appended or pure numbers formatted as
text, if you have a single number and copy it by dragging it will not
increase. You cannot change the default but if you hold down ctrl while you
dragging it will copy the value if it is text number, however if it is a
true number it will increase


--
Regards,

Peo Sjoblom



"ed9213" wrote in message
...
Office Excel 2003 allows copying of cell contents with Cell Drag and Drop.
This works flawlessly for me with text, but with numbers, it automatically
creates a series, incrementing by one. I have to manually choose the Copy
Cells button from the Auto Fill Options box that comes up after the Drag
and
Drop.

I seldom have to create series increments, but have to copy cells many
times, like general ledger account numbers, that cannot be incremented.

Can the default for the Auto Fill Options box be changed to Copy Cell
instead of Fill Series?

Thanks.
--
ed

Right-click and drag.

Release and choose from Copy Cells or Fill Series.


Gord Dibben MS Excel MVP


On Thu, 5 Apr 2007 10:08:04 -0700, ed9213
wrote:

Office Excel 2003 allows copying of cell contents with Cell Drag and Drop.
This works flawlessly for me with text, but with numbers, it automatically
creates a series, incrementing by one. I have to manually choose the Copy
Cells button from the Auto Fill Options box that comes up after the Drag and
Drop.

I seldom have to create series increments, but have to copy cells many
times, like general ledger account numbers, that cannot be incremented.

Can the default for the Auto Fill Options box be changed to Copy Cell
instead of Fill Series?

Thanks.

Hi,

If you just drag the cell handle the contents just copies with the same cell
value. I hope you are pressing the Crtl key before dragging the handle.

Challa Prabhu

"ed9213" wrote:

Office Excel 2003 allows copying of cell contents with Cell Drag and Drop.
This works flawlessly for me with text, but with numbers, it automatically
creates a series, incrementing by one. I have to manually choose the Copy
Cells button from the Auto Fill Options box that comes up after the Drag and
Drop.

I seldom have to create series increments, but have to copy cells many
times, like general ledger account numbers, that cannot be incremented.

Can the default for the Auto Fill Options box be changed to Copy Cell
instead of Fill Series?

Thanks.
--
ed