Excel Refresh or Calculate Shortcut

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on October 23, 2023

This tutorial will demonstrate how to calculate and refresh spreadsheets using shortcuts.

Calculate/Refresh Spreadsheet Shortcuts

In the Ribbon Formula Tab to the far right, you will see calculation options:

Calculation Options

  • Automatic: formulas automatically update as data is changed
  • Manual: Formulas do not update until you manually recalculate.

Shortcut to Calculate Entire Workbook / Refresh

  • Press F9 to calculate the entire workbook
  • This calculates all worksheets in all open workbooks

Shortcut to Calculate Entire Workbook

Shortcut to Calculate Active Workbook

  • Hold down Shift + F9 to calculate the active sheet.

Shortcut to CalculateActive Workbook

In this scenario, if you have multiple tabs, it will only update the tab that you have open

 

Active Sheet

Shortcut to Force Calculate

  • To force calculate, hold down Ctrl + ALT + F9
  • Calculate all workbooks in all open workbooks, regardless of whether they have changed since the last calculation.

Calculate Part of a Formula

While in Cell Edit Mode, this Excel Shortcut calculates part of a formula.

PC Shortcut:F9
Mac Shortcut:fn+F9
Remember This Shortcut:
F9 is also the standard shortcut to calculate. So, within a cell F9 calculates just the selected piece.

AI Formula Generator

Try for Free