Stop Autofill

F

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
 
F

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
 
J

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.
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top