# Manually Calculate Formulas and Functions in Excel

Author:

How to force Excel to recalculate all formulas and functions without editing or entering any data. This works great when you need to refresh linked data or update randomly generated values in Excel.

F9 - keyboard shortcut that recalculates the entire Excel workbook.

Shift + F9 - keyboard shortcut that recalculates only the currently visible worksheet.

Ribbon Menu: Formulas tab > Calculation section

## Notes

You can download the sample file for this tutorial to test this out with some basic RAND() functions.

Excel Function: RAND()

#### Question? Ask it in our Excel Forum

Our Excel Courses

#### Professional Input Forms in Excel

• Skill Level: All Levels
• |
• 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

#### Send Emails from Excel (Multiple Methods)

• Skill Level: All Levels
• |
• 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.

Similar Content on TeachExcel
Understanding Formulas and Functions in Excel
Tutorial: In this tutorial I will cover the basic concepts of Formulas and Functions in Excel. A for...
How to Input, Edit, and manage Formulas and Functions in Excel
Tutorial: In this tutorial I am going to introduce how to input, edit and manage excel formulas. To ...
Stop Formula Calculation in Excel - Increase Worksheet Performance
Tutorial: I'll show you how to stop formulas and functions from performing their calculations and u...
Guide to Referencing Other Excel Files with Formulas and Functions
Tutorial: Your guide to making cross-workbook formulas and functions. This includes an overview of p...
Guide to Making Your Macro Run Faster and Better in Excel
Tutorial: This guide will show you 4 different ways to make your macros run faster and more efficien...
Absolute and Relative Cell References in Excel
Tutorial: In this tutorial I am going to cover the difference between Absolute and Relative Cell Ref...
Tutorial Details
Excel Function: RAND()