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
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