Google Sheets
An innovative cloud-based spreadsheet tool maximizing team productivity with real-time collaboration and AI features
Calculation support shortcuts that streamline complex calculations and analysis work with formula creation, formatting, and array formula features
Ctrl+~
Show formulas
Displays all formulas in cells.
💡 Hint: ~
🎯 Display all formulas in cells to streamline calculation logic verification
Ctrl+Shift+Enter
Insert array formula
Enters an array formula.
💡 Hint: Enter
🎯 Insert array formula to execute advanced calculations across multiple cells at once
Ctrl+E
Toggle expanded array formula
Toggles expansion of array formulas.
💡 Hint: Expand
🎯 Toggle expanded array formula display to aid understanding of complex formulas
F4
Toggle absolute/relative reference
Toggles between absolute and relative references while editing.
💡 Hint: F4
🎯 Toggle between absolute and relative references while editing formulas for flexible calculation setup
Ctrl+Shift+1
Format as number
Formats selected cells as numbers.
💡 Hint: 1
🎯 Format cells as numbers to ensure proper display of calculation results
Ctrl+Shift+5
Format as percent
Formats selected cells as percent.
💡 Hint: 5
🎯 Format cells as percentage to visualize proportion data
Ctrl+Shift+4
Format as currency
Formats selected cells as currency.
💡 Hint: 4
🎯 Format cells as currency for clear display of monetary data
Ctrl+Shift+6
Format as scientific
Formats selected cells in scientific notation.
💡 Hint: 6
🎯 Format cells in scientific notation for efficient display of large numbers
Shift+F1 → F1
Toggle formula help
Shows or hides formula help while editing.
💡 Hint: F1
🎯 Display formula help during input to support accurate function usage
F9
Toggle formula result preview
Toggles formula result preview while editing.
💡 Hint: F9
🎯 Display formula result preview to verify calculation accuracy beforehand