About This 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 .
About This Shortcut
This shortcut will toggle the formula bar between a collapsed and uncollapsed state. It’s useful when you have a very long formula, or have added line breaks to a formula for readability .
