F2 | Edit active cell |
| Ctrl + C | Copy |
| Ctrl + V | Paste |
| 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 | Clear cell contents |
| Ctrl + - | Delete cells/rows/columns |
| Ctrl + Shift + + | Insert cells/rows/columns |
| Ctrl + B | Bold |
| Ctrl + I | Italic |
| Ctrl + U | Underline |
| Ctrl + 1 | Format Cells dialog |
| Ctrl + Shift + $ | Currency format |
| Ctrl + Shift + % | Percentage format |
| Ctrl + Shift + # | Date format |
| Ctrl + Shift + ~ | General number format |
| Alt + Enter | New line within cell |
| Alt + H + O + I | Auto-fit column width |
F4 | Toggle absolute/relative reference |
| Ctrl + ` | Show/hide formulas |
| Ctrl + Shift + Enter | Array formula (legacy) |
Tab | Accept AutoComplete suggestion |
Shift + F3 | Insert Function dialog |
| Alt + = | AutoSum |
F9 | Calculate worksheets |
| Ctrl + [ | Select precedent cells |
| Ctrl + ] | Select dependent cells |
=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 |
=ROUND(number, decimals) | Round number |
=TODAY() | Current date |
=NOW() | Current date and time |
=VLOOKUP(value, range, col, match) | Vertical lookup |
=HLOOKUP(value, range, row, match) | Horizontal lookup |
=XLOOKUP(value, lookup, return) | Modern lookup (365+) |
=INDEX(range, row, col) | Return value at position |
=MATCH(value, range, type) | Find position of value |
=INDIRECT(ref_text) | Create reference from text |
=OFFSET(ref, rows, cols) | Offset from reference |
=CONCATENATE(text1, text2) | Join text strings |
=TEXTJOIN(delim, ignore, range) | Join with delimiter (365+) |
=LEFT(text, n) | Extract left characters |
=RIGHT(text, n) | Extract right characters |
=MID(text, start, n) | Extract middle characters |
=LEN(text) | Get text length |
=TRIM(text) | Remove extra spaces |
=SUMIF(range, criteria, sum_range) | Conditional sum |
=COUNTIF(range, criteria) | Conditional count |
=SUMIFS(...) | Multiple criteria sum |