G
Guest
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.
function off???
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.
automatically increase the value by one. IS there a way to trun thisMaya said:
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
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???
:
: 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???
:
G
Guest
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
3, even though I want to copy the C column into the next row... not the D column. Any suggestions?
3, 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
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 celaddress you want to add $'s to, use F4 to toggle through the 4 possibl
permutations.
Al
G
Guest
Alf
You just saved me hours of work! Can't thank you enough!
You just saved me hours of work! Can't thank you enough!
A
AlfD
You're welcome.
Al
Al