F2 / Enter | Edit active cell |
| Ctrl + C | Copy |
| Ctrl + V | Paste |
| Ctrl + Shift + V | Paste values only |
| Ctrl + X | Cut |
| Ctrl + Z | Undo |
| Ctrl + Y | Redo |
| Ctrl + D | Fill down |
| Ctrl + R | Fill right |
| Ctrl + ; | Insert current date |
| Ctrl + Shift + ; | Insert current time |
Delete / Backspace | Clear cell contents |
| Ctrl + Alt + = | Insert rows/columns |
| Ctrl + Alt + - | Delete rows/columns |
| Ctrl + Alt + 9 | Hide rows |
| Ctrl + Shift + 9 | Unhide rows |
| Ctrl + Alt + 0 | Hide columns |
| Ctrl + Shift + 0 | Unhide columns |
| Ctrl + B | Bold |
| Ctrl + I | Italic |
| Ctrl + U | Underline |
| Alt + Shift + 5 | Strikethrough |
| Ctrl + \ | Clear formatting |
| Ctrl + Shift + 1 | Number format |
| Ctrl + Shift + 2 | Time format |
| Ctrl + Shift + 3 | Date format |
| Ctrl + Shift + 4 | Currency format |
| Ctrl + Shift + 5 | Percentage format |
| Ctrl + Shift + 6 | Scientific notation |
| Ctrl + Shift + L | Align left |
| Ctrl + Shift + E | Center align |
| Ctrl + Shift + R | Align right |
| Alt + Shift + 7 | Apply border |
| Alt + Shift + 6 | Remove borders |
F4 | Toggle absolute/relative reference |
| Ctrl + ` | Show all formulas |
Tab | Accept autocomplete |
| Ctrl + Shift + Enter | Array formula |
F1 | Full formula help |
F9 | Evaluate formula part |
=SUM(range) | Add all numbers in range |
=AVERAGE(range) | Calculate average |
=COUNT(range) | Count cells with numbers |
=COUNTA(range) | Count non-empty cells |
=MAX(range) | Find maximum value |
=MIN(range) | Find minimum value |
=IF(test, true, false) | Conditional logic |
=IFERROR(formula, value) | Handle errors |
=TODAY() | Current date |
=NOW() | Current date and time |
=VLOOKUP(key, range, col, match) | Vertical lookup |
=HLOOKUP(key, range, row, match) | Horizontal lookup |
=INDEX(range, row, col) | Return value at position |
=MATCH(value, range, type) | Find position of value |
=XLOOKUP(key, lookup, result) | Modern lookup function |
=FILTER(range, condition) | Filter data by condition |
=SORT(range, col, asc) | Sort range |
=UNIQUE(range) | Return unique values |
=GOOGLEFINANCE("symbol") | Stock quotes and financial data |
=GOOGLETRANSLATE(text, src, tgt) | Translate text |
=IMAGE(url) | Insert image from URL |
=IMPORTHTML(url, "table", n) | Import table from web |
=IMPORTDATA(url) | Import CSV/TSV data |
=IMPORTRANGE(url, range) | Import from another sheet |
=QUERY(data, query) | SQL-like query |
=ARRAYFORMULA(formula) | Apply formula to entire range |
| Ctrl + Shift + L | Create filter |
| Alt + D, S | Sort sheet by column A-Z |
| Ctrl + Alt + R | Sort range |
| Shift + F11 | Insert new sheet |
| Alt + Page Up | Previous sheet |
| Alt + Page Down | Next sheet |
| Alt + Shift + K | Display sheet list |