Show Formulas
Windows
Ctrl+`
Shows formulas instead of results.
Tip: The ` key is usually left of the 1 key.
Excel Show Formulas Shortcut for Windows, Mac & Web
Shows formulas instead of results. Here's the keyboard shortcut for every version of Excel, plus other ways to do it.
Quick Answer
- Windows
- Ctrl+`
- Mac
- Ctrl+`
- Web
- Ctrl+`
How to show formulas in Excel with the keyboard
- Open Excel and go to where you want to show formulas.
- Press Ctrl + ` on Windows or Ctrl + ` on Mac.
Tip: The ` key is usually left of the 1 key.
Excel Show Formulas Shortcut for Windows
Press Ctrl + `.
Excel Show Formulas Shortcut for Mac
Press Ctrl + `.
Excel Show Formulas Shortcut for Excel Web
Press Ctrl + `.
Related Shortcuts
Frequently asked questions
What is the Excel show formulas shortcut?
On Windows, press Ctrl + `. On a Mac, press Ctrl + `.
Is there a Mac shortcut to show formulas in Excel?
Yes: Ctrl + `.
Does it work in Excel for the web?
Yes: Ctrl + `.
Verified 2026-10-07 · Last reviewed: 2026-10-07 · Microsoft's official shortcut list