Shortcut keys
WindowsCtrl + `
MacCtrl + `
Ribbon path
Formulas → Show Formulas
What it does
Toggles between showing formula results and the actual formula text in all cells. Useful for auditing a sheet.
How to use this shortcut
- Open the Excel workbook and select the relevant cell, row, column, range, or sheet.
- Press the shortcut keys shown above for your platform.
- Confirm any dialog options if Excel opens a menu or prompt.
FAQ
What is the Excel shortcut for show formulas?
On Windows, use Ctrl + `. On Mac, use Ctrl + `.
Where is show formulas in the Excel Ribbon?
The Ribbon path is Formulas → Show Formulas.
What does show formulas do in Excel?
Toggles between showing formula results and the actual formula text in all cells. Useful for auditing a sheet.