Copying information from one cell to another without modifying it.

Please tell me how to stop Excel from Adding 1 to my data when I copy it from
the first cell in a column to the rest of the cells in the same column. For
example, when I key WC123 and try to drag & copy this value to the cells
below, the result is WC124, WC125, etc..

Thanks.

Ken K. - 2191
--
akkrug

Ken try pressing the Ctrl key while you drag & copy

Works Great! Can't believe I was so brain-dead today that I forgot how to do
it.

Thank Ferg!!
--
akkrug


"akkrug" wrote:

> Please tell me how to stop Excel from Adding 1 to my data when I copy it from
> the first cell in a column to the rest of the cells in the same column. For
> example, when I key WC123 and try to drag & copy this value to the cells
> below, the result is WC124, WC125, etc..
>
> Thanks.
>
> Ken K. - 2191
> --
> akkrug

One more method.

Right-click and drag.

Release and select "Copy Cells"


Gord Dibben MS Excel MVP

On Thu, 27 Jul 2006 06:23:02 -0700, akkrug <[email protected]>
wrote:

>Please tell me how to stop Excel from Adding 1 to my data when I copy it from
>the first cell in a column to the rest of the cells in the same column. For
>example, when I key WC123 and try to drag & copy this value to the cells
>below, the result is WC124, WC125, etc..
>
>Thanks.
>
>Ken K. - 2191

Also works great! Thanks Gord!!!

Ken K. - 2191
--
akkrug


"Gord Dibben" wrote:

> One more method.
>
> Right-click and drag.
>
> Release and select "Copy Cells"
>
>
> Gord Dibben MS Excel MVP
>
> On Thu, 27 Jul 2006 06:23:02 -0700, akkrug <[email protected]>
> wrote:
>
> >Please tell me how to stop Excel from Adding 1 to my data when I copy it from
> >the first cell in a column to the rest of the cells in the same column. For
> >example, when I key WC123 and try to drag & copy this value to the cells
> >below, the result is WC124, WC125, etc..
> >
> >Thanks.
> >
> >Ken K. - 2191
>
>