Highlight all cells with formulas
Master this Excel shortcut with our comprehensive guide
Special Cells Shortcuts
Ctrl + `
Ctrl + `
How to Use This Shortcut
Keyboard Shortcut
Ctrl + `
Instructions
1. Press Ctrl + ` (backtick)
2. Displays formulas instead of values in the sheet
2. Displays formulas instead of values in the sheet
Keyboard Shortcut
Ctrl + `
Instructions
1. Press Ctrl + ` (backtick)
2. Shows all formulas in cells
2. Shows all formulas in cells
💡 Pro Tip: Quickly audit formulas for errors or inconsistencies.
Quick Actions
More Special Cells Shortcuts
Ctrl + Shift + 8
Ctrl + Shift + O
Alt + ;