Stop Autofill

[F.G.]

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

 

[Gord Dibben]

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


Gord Dibben MS Excel MVP

 

[Elisabeth]

Hold Ctrl as you drag.

 

[F.G.]

Hold Ctrl as you drag.
--
Elisabeth











- 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

 

[JE McGimpsey]

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.

 

[challa prabhu]

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

 

[challa prabhu]

Hi,

Select the cells and press Ctrl key and drag.

Challa Prabhu