⚡Formulas
How to show all formulas in a sheet in Google Sheets
Toggle between showing cell values and showing the formulas in every cell.
Ctrl + ~
📋 Step-by-Step Guide
- 1.Open Google Sheets in your browser.
- 2.Select the cell(s) you want to work with.
- 3.Press Ctrl + ~ to show all formulas in a sheet.
🎯 Shortcut Keys by Platform
| Platform | Shortcut |
|---|---|
| 💻 PC / Windows | Ctrl + ~ |
| 🍎 Mac | Ctrl + ~ |
| 💻 Chrome OS | Ctrl + ~ |
💡 Pro Tips
- You can combine this shortcut with the other Common Actions shortcuts to speed up your workflow.
- If you forget this shortcut, press Ctrl + / (or ⌘ + / on Mac) to see all available keyboard shortcuts in Google Sheets.
❓Frequently Asked Questions
📚 Explore All Google Sheets Shortcuts
Discover 111 keyboard shortcuts to boost your productivity
View All Shortcuts ➜Related Shortcuts
⚡ Accelerator Keys
See shortcuts, hints & docs right inside Google Sheets.
Download Accelerator Keys Now