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

Right-click and drag then release and "Copy Cells"


Gord Dibben MS Excel MVP

On Tue, 21 Aug 2007 17:39:30 -0000, "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

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

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

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

Hi,

Do the following;

1. On the Tools menu, click Options.
The Options dialog box is displayed.
2. Click the Edit tab.
3. Verify whether the "Show Paste Options button" is selected.

Important: If the "Show Paste Options button" is cleared, select the
checkbox, otherwise you cannot Autofill the cells when you drag the handle.

4. Select the cell and drag the handle. The AutoFill Options tool tips is
displayed.
There are three option:
A. Copy Cells.
B. Fill Formating Only.
C. Fill without Formatting.

By default, Copy Cells is selected..

Note: If you want to increment a value press Ctrl and then drag the fill
handle of the cell.

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

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