On Aug 21, 2:26 pm, Elisabeth
wrote:
Hold Ctrl as you drag.
--
Elisabeth



"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- Hide quoted text -

- Show quoted text -

Thank you Gord Dibben and Elisabeth. If you are close enough I'll
offer you a Starbuck drink.
F.G. East End 80 St. NY CUNY