Recalculating Worksheets and Workbooks


Excel normally recalculates all cells in a workbook automatically when the value in any cell changes. But if you work with complex workbooks, you may need to turn off automatic recalculation (on the Calculation tab of the Options dialog box) to prevent lengthy recalculation from slowing down your work. You can then force recalculation manually when needed by using the following keyboard shortcuts.

Shortcuts for Recalculating Worksheets and Workbooks

Recalculate all the worksheets in all the open workbooks

[F9]

This command recalculates all the cells that have changed and the cells they affect. If the workbooks are highly complex, recalculation may take a long time.

Recalculate the active worksheet only

[Shift] - [F9]

If your changes are limited to the active worksheet, use this shortcut to restrict recalculation to that worksheet.

Recalculate all calculations in all the worksheets in all the open workbooks

[Ctrl] - [Alt] - [F9]

This command recalculates even cells that have not changed. You shouldn t need to use it often.

Recheck all formulas, then recalculate all calculations in all the worksheets

[Ctrl] - [Alt] - [Shift] - [F9]

This Vulcan Nerve Pinch four-key shortcut is the ultimate in recalculation: Excel rechecks all formulas in all the worksheets in the open workbooks, then recalculates all the cells, even those that have not changed.




Windows XP and Office 2003 Keyboard Shortcuts
Windows XP and Office 2003 Keyboard Shortcuts
ISBN: 0072255005
EAN: 2147483647
Year: 2003
Pages: 117

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net