It shouldn't if you have only one cell, of course if you have 1 in A1 and 2
in A2 and you select both those cell it will increment but if you just put
for instance 4 in A1 and copy down it shouldn't increase. Btw if you copy
down using the right mouse you can select if you want to copy cells or if
you want to fill a series




--

Regards,

Peo Sjoblom





"Gordon" <gerutzenatyahoodotcom wrote in message
...
Thank you for the prompt reply. However, when I do as you suggest, the
number increases by one for each cell as I drag down to a lower cell and
decreases by one for each cell as I drag to a upper cell. I just want the
number to stay the same without increasing or decreasing.
--
Gordon


"Ragdyer" wrote:

Simply left click on the fill handle (little black square in lower right
corner) of the selected cell, where the cursor changes from a fat white
cross to a skinny black cross,and drag wherever.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Gordon" <gerutzenatyahoodotcom wrote in message
...
In Excel 2003, how do I turn off the feature which increases or
decreases
the
value of a number by one as you drag from one cell to another. I just
want
to copy the same number from one cell to another by drag and drop.
--
Gordon