Can I disable this automatic number advance thing?

I'm talking about dragging a cell's contents to a cell below it by using that
little plus sign in the corner, and it automatically advances a number in the
cell (or date in this case) to the next higher one. It can be handy, but can
I turn it off? Thanks.

If you right-click and drag, when you release the mouse button you'll ge
a popup that allows you to choose Copy cells (or Fill Series, etc).

Depending on your version of XL, you may also get a "smart button" that
allows you to modify how the fill is done.


In article <9BE06129-7579-4ECB-9374-BABBD541B0A9@microsoft.com>,
"Paul" <Paul@discussions.microsoft.com> wrote:

> I'm talking about dragging a cell's contents to a cell below it by using that
> little plus sign in the corner, and it automatically advances a number in the
> cell (or date in this case) to the next higher one. It can be handy, but can
> I turn it off? Thanks.

One way

Right click and copy down and when you release the mouse button select copy
cells


Regards,

Peo Sjoblom

"Paul" wrote:

> I'm talking about dragging a cell's contents to a cell below it by using that
> little plus sign in the corner, and it automatically advances a number in the
> cell (or date in this case) to the next higher one. It can be handy, but can
> I turn it off? Thanks.

That works. Thanks for the help.

"Paul" wrote:

> I'm talking about dragging a cell's contents to a cell below it by using that
> little plus sign in the corner, and it automatically advances a number in the
> cell (or date in this case) to the next higher one. It can be handy, but can
> I turn it off? Thanks.