putting formulas in multiple boxes

[zachmarman]

Im very new to excel. What i cant figure out how to do is this, i have a
sheet with over 3500 rows of a number in wich i need to have it round its own
number in its own column. I know how to put in the formula for one box
(=ROUND(E7/0.83,2)example.) This is the correct formula to make H7 correct
but need to make this formula work down every row. Is there any way i can do
this without haveing to put this formula in every bix?

 

[Peo Sjoblom]

Make sure the help cell where you round is adjacent to the data

then all you have to do is to do the first formula, press enter, select the
cell with the formula again and
move the mouse cursor to the lower right corner of the cell and when it
changes from a fat cross to a thin
double click the left mouse button and the formula will copy down as many
rows as needed and it will change
E7 in the formula to E8, E9 and so on


--


Regards,


Peo Sjoblom