# Excel Refresh or Calculate Shortcut

Written by

Reviewed by

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:

**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 Active Workbook**

- Hold down
**Shift + F9**to calculate the active sheet.

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

**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.