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

Regards,

Peo Sjoblom

"whiteteeth" wrote in message
...
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?