Thank you for your suggestion to use the right-click and select "copy cells".
Is there any way to change the default so I don't have to go through a
2-step process? When I right click, the initial entry is indexed up or down
by one number and only when I select "copy cells" does it retain the same
number. I am working with Employee ID numbers and telephone numbers, so
these are not sequential numbers in adjacent cells.
--
Gordon


"Peo Sjoblom" wrote:

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