How to use same formula throughout the spreadsheet??

[whiteteeth]

I would like to use the same formula throughout the spreadsheet, although the
cell numbers and values will be different. For example =b1-SUM(c1:f1). How
do I format it so this calculation takes place for each row of cells but with
their respective cell numbers and values?

 

[JulieD]

Hi

i'm assuming that you've got the formula say in A1 and you want it in A2, A3
.....
to do this, click on the cell with the formula
move your mouse over the bottom right hand corner of the cell and you'll see
a little +
double click on the + this should copy the formula down as far as there is
data in cell B1
- if the double click doesn't work or you want to go down more lines, drag
the little + downwards

Hope this helps
Cheers
JulieD

 

[Peo Sjoblom]

Just copy it and paste it or use the mouse to frag it using the fillhandle

Regards,

Peo Sjoblom