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 |
Ctrl + Shift + & | Apply border |
Ctrl + Shift + _ | Remove border |
F4 | Toggle absolute/relative reference |
Ctrl + ` | Show/hide formulas |
Ctrl + Shift + Enter | Array formula |
Tab | Accept AutoComplete suggestion |
Shift + F3 | Insert Function dialog |
Alt + = | AutoSum |
F9 | Calculate worksheets |
Ctrl + [ | Select precedent cells |
Ctrl + ] | Select dependent cells |
Ctrl + Shift + U | Expand/collapse formula bar |
=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 |
=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 |
=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 |
Ctrl + Shift + L | Toggle auto filter |
Alt + D, S | Sort dialog |
Alt + A, T | Apply filter |
Ctrl + T | Create table |
Alt + D, P | Pivot table |
Ctrl + Shift + F | Advanced filter |
Ctrl + 9 | Hide rows |
Ctrl + Shift + 9 | Unhide rows |
Ctrl + 0 | Hide columns |
Ctrl + Shift + 0 | Unhide columns |
Alt + H, O, I | Auto-fit column width |
Alt + H, O, A | Auto-fit row height |
Shift + F11 | Insert new sheet |
Ctrl + Page Up | Previous sheet |
Ctrl + Page Down | Next sheet |
Alt + E, L | Delete sheet |
Alt + E, M | Move/copy sheet |
Alt + O, H, R | Rename sheet |