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 boolean operations are used in array formulas. This is a key concept in developing more advanced dynamic array 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 use the FILTER function together with the UNIQUE function to limit results using logical criteria.
In this video, we’ll look at a couple ways to use the FILTER function to extract data between dates.
In this video, we'll look at a few ways to see or visualize arrays in a formula. One of the best things about the new dynamic array formula engine in Excel is that it's much easier to see and visualize arrays.

Download 200+ Excel Shortcuts

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