Quick, clean, and to the point

Evaluate part of a formula

Windows shortcut 
Mac shortcut 

 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 absolutely LUV your explanations and examples! You have saved me a lot of time and frustration. Thank you, thank you, thank you. -Katalin
Excel foundational video course
Excel Pivot Table video training course
Excel conditional formatting video course
Excel formulas and functions video training course
Excel Shortcuts Video Course