auto-calc entire sheet?

[roo3d]

I created a spreadsheet and several of the columns have equations using data entered in other columns.
I successfully dragged the little black plus sign at the corner of each column down and it copied the equation with the appropriate blocks corresponding in each line.
The problem is that each box is either blank or displays the answer of the first equation when I first copy the equation, until I go to that box and click on the end of the equation in that box, and hit space and enter, then it fills in the appropriate answer in that box.
The pain is that there are over 600 boxes to do that for, and I update the equations and data often.
Is there a way to get the entire sheet to update all the calculations in each box with one or two clicks?
I tried looking for an answer but couldn't find one, I would appreciate some advice.
- Rick

[DiGro]

Did you try F9 ?

That should recalculate your sheet
_________________
DiGro

Windows 7 Home Premium and OOo 3.3 NL (Dutch)

[roo3d]

that worked, thank you very much