The currently selected cells, using Range Calculate. Alt-F9 If more than one Area is selected; each Area is calculated left-to-right and top-to-bottom, in the sequence that the areas were selected. If more than one worksheet is selected then only the selected range on the active worksheet is calculated. If one or more of the selected cells is part of a multi-cell array formula then all the cells in the array formula will be included in the calculation. If Calculation is set to Automatic both the time taken to calculate the range in Manual mode and the workbook recalculation time are shown.
The currently selected sheet(s), using Sheet Recalculate. Shift-F9. If more than one worksheet is selected all the selected worksheets are recalculated. If Calculation is set to Automatic both the time taken to recalculate the sheet(s) in Manual mode and the subsequent workbook recalculation time are shown. If MixMode sheets are selected by default they will be calculated
The currently selected sheet(s), using Sheet Full Calculate. Alt-Shift-F9. If more than one worksheet is selected all the selected worksheets are recalculated. If Calculation is set to Automatic both the time taken to recalculate the sheet(s) in Manual mode and the subsequent workbook recalculation time are shown. If MixMode sheets are selected by default they will be calculated
All enabled sheets in open workbooks. Recalculate. F9. MixMode sheets are not calculated unless Manual Calculation has been checked in MixMode options.
Calculate all open workbooks. Full Calculation. Ctrl-Alt-F9
Recalculate MixMode Sheets: All enabled sheets and any MixMode sheets in all open workbooks are recalculated. Ctrl-Shift-F9.
Select, run and time a macro.
To control the display of the calculation time see FastExcel Calculation Control -> FastExcel Settings. There are keyboard shortcuts for these calculation commands.
|