One way:

Right-click the fill handle and drag down. When you release the mouse
button, a popup will appear with Copy Cells at the top.



In article .com,
"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