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 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.
This video shows how you can replace formulas with the results they return, a useful way to stop Excel from calculating new results.
In this video, we'll look at how to create a dynamic named range with the INDEX function. INDEX is a non-volatile function, so it won't recalculate whenever a change is made to a worksheet.
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.