Evaluate part of a formula

Keyboard shortcut options for this action in excel: 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.

0 votes. 0 / 5