Last Updated: November 21, 2025
Common Formulas
| Formula | Description |
|---|---|
=SUM(A1:A10)
|
Sum range |
=AVERAGE(A1:A10)
|
Average of range |
=QUERY(A1:D10, 'SELECT *')
|
Query data like SQL |
=IMPORTRANGE(url, range)
|
Import data from another sheet |
=GOOGLEFINANCE('GOOG')
|
Get stock prices |
=UNIQUE(A1:A10)
|
Get unique values |
=FILTER(A1:B10, A1:A10>5)
|
Filter data |
Keyboard Shortcuts
| Shortcut | Action |
|---|---|
Ctrl + /
|
Show keyboard shortcuts |
Ctrl + Alt + M
|
Insert comment |
Ctrl + Enter
|
Fill down |
Alt + Shift + 5
|
Strikethrough |
Ctrl + Space
|
Select column |
Shift + Space
|
Select row |
💡 Pro Tip:
Use =ARRAYFORMULA() to apply formulas to entire columns automatically!