Beta
This is a new feature and we can’t wait to hear your feedback. Is it useful for your tasks? Is it easy to use? Just let us know viawebsiteoremail us.

Use with caution: beta features may contain some bugs and rough edges. To test the feature, take afree trialorupdateXLTools to version 5.3.1.

How to refresh and recalculate formulas only in a selected range of cells

When you work with large spreadsheets full of formulas, functions and cell references, it may be frustrating to wait as the spreadsheet is recalculated every time you change a single cell. In fact, it’s likely you have already switched from automatic to manual workbook calculation. And even so, you get only two options: calculate either the entire workbook, or the active worksheet. What if you need to recalculate a smaller range, or even just a single cell?

The Recalculate Range feature helps do just that:

  • Recalculate formulas in selected cells only
  • Simply select a range – and click ALT+F9 to refresh
  • Or set any custom shortcut you need

How to switch from automatic to manual calculation in Excel

The Recalculate Range feature will only work if you disable automatic spreadsheet calculation and switch to manual mode:

Open Formulas tab ClickCalculation options In the drop-down list, checkManual.

Now automatic calculations of the workbook are disabled. Recalculation of formulas can only be triggered manually, for example through Excel shortcuts.

How to recalculate a specific range in Excel

To recalculate a selected range only, use XLTools shortcut:

Select a range Use the keyboard shortcut combinationAlt + F9 Done! All cells with formulas in the range are recalculated.

Note:if your selected range contains formulas, functions, or references that depend on another range, to get correct recalculation results, the other range must be up to date.

To force recalculate an entire workbook or a worksheet, use Excel shortcuts:

  • F9– calculate all worksheets in all open workbooks
  • Shift+F9– calculate the active worksheet
  • Ctrl+Alt+F9– calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation
  • Ctrl+Alt+Shift+F9– check dependent formulas, and then calculate all cells in all open workbooks, including cells not marked as needing to be calculated

How to change default shortcut for the Recalculate Range

You can change the hot key combinations for the Recalculate Range at any time. Note, some shortcuts may not be available if they are reserved for other operations in Excel.

XLTools tab Settingsbutton Shortcutstab Set your own shortcuts OK.

Any questions or suggestions?
How can we help?