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 quickly find formulas and trace how they are related to one another, using the concept of precedents and dependents.
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 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 at how to sort with SORTBY function using a custom list. We use the custom list to specify a custom order.
When working with more advanced formulas, especially array formulas, you need to know how to convert TRUE and FALSE values in Excel to their numeric equivalents, 1 and 0. In this video, we'll look at some ways you can convert TRUE and FALSE values in Excel to 1s and 0s.