Hi,

Select the cells and press Ctrl key and drag.

Challa Prabhu

"F.G." wrote:

Hi,

Data is as follow:
Name ID Birthday
c1 James 123456 01/01/1900
c2

I want to copy c1 in c2 by dragging but excel autofill series
automaticly by incerementing values by one:

Name ID Birthday
c1 James 123456 01/01/1900
c2 James 123457 01/01/1901

Each time I have to go and change the option on Autofill from fill
series to copy cells.

Is there a way to turn on/off the autofill option ?

Thank you
FG