Toggle value/formula display
Master this Excel shortcut with our comprehensive guide
Excel Formula-Related Shortcuts
Ctrl + `
⌘ + `
How to Use This Shortcut
Keyboard Shortcut
Ctrl + `
Instructions
1. Press Ctrl + `
2. Switches between showing formulas and their results
2. Switches between showing formulas and their results
Keyboard Shortcut
⌘ + `
Instructions
1. Press Command + `
2. Displays formulas instead of values or vice versa
2. Displays formulas instead of values or vice versa
💡 Pro Tip: Essential for debugging or reviewing formula logic across the sheet.
Quick Actions
More Excel Formula-Related Shortcuts
Alt + =
Ctrl + Shift + U