SO, you're saying that when you select a *single* cell, and drag that single
cell up, down, or across, you're getting the number in that cell to
increment or decrement?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Gordon" <gerutzenatyahoodotcom wrote in message
...
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