Exceljet

Quick, clean, and to the point

Evaluate part of a formula

Windows shortcut 
F9
Mac shortcut 
FnF9

Use this keyboard shortcut to evaluate parts of a formula. This is not really a keyboard shortcut per se, but rather just a trick you can use to find out how Excel evaluates parts of a formula as it calculated. This is a great way to check a formula to find out how it works, or to debug a formula when it isn't working properly. See this video for a demonstration of F9 to evaluate parts of a formula.

Related videos

The videos below demonstrate this shortcut.
The term "array" comes from programming, but you'll hear it often in the context of more advanced Excel formulas. In this video, we'll answer the question "what is an array?"
In this video we'll look how to use the FILTER function with Boolean logic to apply multiple criteria. The result is a filtered list where the color is Blue and the month is June
In this video, we'll look at how to plot over 3000 survey responses to a question in an Excel bar chart.
In this video we'll look how to use the XLOOKUP function with Boolean logic to apply multiple criteria.
In this video, we'll answer the question: What is an array formula? The term "array formula" is probably responsible for more confusion than just about any other concept in Excel.

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.