Microsoft Office Excel 2007 Recalculate a worksheet or workbook manually by using keyboard shortcuts

ToPress
Recalculate formulas that have changed since the last calculation, and formulas dependent on them, in all open workbooks. If a workbook is set for automatic recalculation, you do not need to press F9 for recalculation.

                    F9    
Recalculate formulas that have changed since the last calculation, and formulas dependent on them, in the active worksheet.
             SHIFT+F9    
Recalculate all formulas in all open workbooks, regardless of whether they have changed since last time or not.
         CTRL+ALT+F9    
Recheck dependent formulas, and then recalculate all formulas in all open workbooks, regardless of whether they have changed since last time or not.
CTRL+SHIFT+ALT+F9