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.
In this lesson, we cover shortcuts you can use when building, editing, or entering formulas.
Structured references are used to refer to Excel tables in formulas. In this video, we get into the nitty gritty with many examples.
In this video, we'll look at how to create a dynamic named range using the OFFSET function, the most common way to create dynamic names range with a formula.
In this brief video, we look at how to debug a formula using the F9 key. If you work with formulas a lot, this is one of the most useful skills you can learn.
In this video, we'll look at how to create a dynamic reference to a named range with the INDIRECT function. This is one way to switch ranges on the fly.