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

Tip: 23 formula tips to save you time today
In this video, we run through more than 20 tips you can use to save time with Excel formulas today. We believe in making videos that are quick and to the point, so this is a rapid-fire list. We trust that you can rewind the video as needed :)
Tip: How to check and debug a formula with F9
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.
Tip: How to plot survey data in a bar chart
In this video, we demo how to plot results from a survey question in an Excel bar chart. Along the way, we use the COUNTIF function to build a summary table, and show a simple technique for creating an "other" bucket.
I just wanted to drop a line to say that I recent discovered your site and I absolutely LOVE it. Although other sites exist that try to showcase the same things your tutorials are easy to understand, follow and reapply. This site has quickly become my go to. -Joey
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Shortcuts Video Course
Excel Charts video training course