You can copy it down using the mouse and that little cross thing but i never
do it like that.
You can zip around in Excel without using the mouse.
For moving around, and copying, the mouse is mostly a waste of time.
This long to explain but really fast to do.
You should really take some time to learn function keys and the keyboard
shortcuts.
Real, real timesavers.
Type in the "a1 +(b1/100)" formula in c1
press enter.
press F5 and type into dialogue box the reference of the last cell in the
column.
In this case it would be c100.
Excell will position the cursor on c100.
In the C100 cell, type a zero.
with your left thumb, hold down the Ctrl key.
with your right index, press the Up arrow (not the Page up !)
Excel should position the cursor back in C1.
In fact Excel goes up and slams the brakes on
when he reaches a not-empty cell and, as your formula is in C1, then C1 is
not empty,
the cursor will stop there.
Now
with your left thumb, hold down the Ctrl key.
with your left index, hold down the Shift key
with your right index, press the Down arrow (not the Page Down !)
Excel will move the cursor down and slam the bakes on when he hits C100 !
Why ? because you held down Ctrl, and because of the zero you put in there
makes c100 the first not-empty cell.
But this time, he not only goes there but he selects all the cells on the
way down.
Why? because you held down the Shift key while you pressed the Down arrow.
Now press Ctrl +D to fill down the selected cells with the formula from C1.
This is long to explain but really fast to do.
Your hands don't leave the keyboard and there's not "footerin around" with
the mouse.
Have fun Fifi !
Gloria.
"Max" a écrit dans le message de news:
...
After entering the formula in C1, just copy the formula down the col as
far as required by dragging the fill handle* of C1. *the solid square at
the bottom right corner of C1
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"fifi" wrote in message
ups.com...
thanks Gloria I was going bout it the whole wrong way!
do you know if you want this to be done for all your rows do you have
to set up a macro for it to loop through the rows?i have over 100 rows
of this to be done. im really new to all this :(
Gloria Thrurk wrote:
Hi Fiona,
It's not really the format you want changing, it's the value.
When you have a "1" and a "4", the "4" you really want it to mean 0.04.
I think all you really wanna doo is divide the "4" by 100 and add it to
the
"1".
So, if you had
1 in cell A1 and
4 in cell B1
you could type in cell C1
= A1 + (B1/100).
That should do it.
Gloria.
"fifi" a écrit dans le message de news:
...
i have 2 cells of numbers that i want to merge together, for example
A B
1 4
2 11
3 7 etc
but i want the result to be "A"."B"
so row two would be... 2.11
but how do i get row one to be 1.04???
and row three should be 3.07