Copying and dragging

M

Maya

Everytime I copy and drag something from one cell to another it will automatically increase the value by one. IS there a way to trun this function off??
 
A

Andy B

Hi

I'm guessing here, but it sounds like you are using autofill, maybe by
accident, which will give you the results you are getting.
If you click and drag from the bottom right-hand corner (with the little
plus sign) you are using autofill, which will automatically increment your
value (list).
If you drag using the cell border (with the Ctrl held for copying) you
should find it'll do it as you expect.

Hope this helps.
--
Andy.


Maya said:
Everytime I copy and drag something from one cell to another it will
Click to expand...
automatically increase the value by one. IS there a way to trun this
function off???
 
P

Phaedrusz

It sounds like you're using the Autofill handle to copy. Once you fil
the cells, try this:

When Excel fills the cells, a small button appears near the autofil
handle. Click on it, and it will give you several options. Choose th
"Copy Cells" button, and it will copy the data, instead of completin
the series.


Tip1:Right click on the fill handle and drag and it'll give you th
option right away to copy, fill series, or even just to fill th
formatting only.

Tip2: if you're wanting to fill a series or copy cells down an entir
column or row, double click the fill handle. It will complete th
column for you without having to drag it
 
L

Lady Layla

Hold the control key down while you do this


: Everytime I copy and drag something from one cell to another it will
automatically increase the value by one. IS there a way to trun this function
off???
:
 
M

Maya

Thank you very much for the tip, it works for the single numbers, however, for the formula it does not work. When I copy and paste them or drag them, they still change from, say C1:C3 to D1:D3, even though I want to copy the C column into the next row... not the D column. Any suggestions?
 
A

AlfD

Hi!

Ah, well ... that's Excel doing exactly what it is designed to do.

You are using relative addressing: you seem to need absolut
addressing. You need some $ signs in the right places.

$A$1 copied anywhere will read $A$1 and reflect the contents of A1.

$A1 will copy down as $A2, $A3 etc. and across as $A1 in all cols.

A$1 will copy across as B$1, C$1 etc and down as A$1 in all rows.

Easy way to get $'s (joke ;)) is to use F4. With the cursor on the cel
address you want to add $'s to, use F4 to toggle through the 4 possibl
permutations.

Al
 
Top