Evaluate part of the formula
Master this Excel shortcut with our comprehensive guide
Excel Formula-Related Shortcuts
F9
Fn + F9
How to Use This Shortcut
Keyboard Shortcut
F9
Instructions
1. Select a portion of the formula in the formula bar
2. Press F9
3. Excel shows the result of the selected part without changing the formula
2. Press F9
3. Excel shows the result of the selected part without changing the formula
Keyboard Shortcut
Fn + F9
Instructions
1. Highlight part of a formula
2. Press Fn + F9
3. Displays calculated value of the selected section
2. Press Fn + F9
3. Displays calculated value of the selected section
💡 Pro Tip: Great for troubleshooting complex formulas step-by-step.
Quick Actions
More Excel Formula-Related Shortcuts
Alt + =
Ctrl + Shift + U