FWIW,
Another technique for creating ranges of identical values, is to select a
range of cells, columns and/or rows or both, contiguous or not, and then
simply type the value in the focus cell, and then hit,
<Ctrl> <Enter>
And the entire selection will be filled with that single cells data.
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Gordon" <gerutzenatyahoodotcom> wrote in message
news:500D5B6C-56C3-40B2-8043-(E-Mail Removed)...
> Thank you to both Peo and Raydyer..... I ran the test on a new
workbook
> and the entry did not increment or decrement. I have no idea why the
> workbook with the employee data does not respond in the same way.
However, I
> am able to hold down the control key as I drag and the increment and
> decrement does not occur. I will use this technique and consider the
issue
> "solved" without trying to understand why the two workbooks behave
> differently.
> --
> Gordon
>
>
> "Peo Sjoblom" wrote:
>
> > That's probably the reason, just to test, if you open a new workbook and
> > type 1 into A1 then copy down A1 it won't increase correct?
> > I believe there is nothing you can do about Excel trying to be helpful,
> > usually you can hold down ctrl when you do the copying and numbers that
> > won't normally increase will increase and those who normally increases
will
> > not. Other than that I don't think there is a setting you can change
> >
> >
> > --
> >
> > Regards,
> >
> > Peo Sjoblom
> >
> >
> >
> >
> >
> > "Gordon" <gerutzenatyahoodotcom> wrote in message
> > news:480A9677-3A9A-4803-B7C4-(E-Mail Removed)...
> > > 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
> > >> news:036783B5-4D4E-496F-80F8-(E-Mail Removed)...
> > >> > 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
> > >> >> news:F8D2AC17-D530-4669-8852-(E-Mail Removed)...
> > >> >> > 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
> > >> >>
> > >> >>
> > >>
> > >>
> > >>
> >
> >
> >
|
Similar Threads
