← Back to Home
📗
Office Applications
Microsoft Excel
Excel formulas, shortcuts, and functions
⌨️ Navigation
| Shortcut | Description |
|---|---|
| Ctrl + Home | Go to cell A1 |
| Ctrl + End | Go to last used cell |
| Ctrl + Arrow | Jump to edge of data region |
| Ctrl + G | Open Go To dialog |
| Ctrl + Page Up/Down | Switch between worksheets |
| F5 | Go To dialog |
⌨️ Selection
| Shortcut | Description |
|---|---|
| Ctrl + A | Select all cells |
| Ctrl + Shift + End | Select to last used cell |
| Ctrl + Space | Select entire column |
| Shift + Space | Select entire row |
| Ctrl + Shift + Arrow | Extend selection to edge |
| Shift + Click | Select range between cells |
⌨️ Editing
| Shortcut | Description |
|---|---|
| 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 |
⌨️ Formatting
| Shortcut | Description |
|---|---|
| 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 |
⌨️ Formula Shortcuts
| Shortcut | Description |
|---|---|
| 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 |
📐 Common Formulas
| Command | Description |
|---|---|
=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 |
=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 |
=XLOOKUP(value, lookup, return) | Modern lookup (365+) |
=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 |
=IFERROR(formula, value) | Handle errors |
=SUMIF(range, criteria, sum_range) | Conditional sum |
=COUNTIF(range, criteria) | Conditional count |
=ROUND(number, decimals) | Round number |
=TODAY() | Current date |
=NOW() | Current date and time |
💡 Tips & Tricks
- Double-click column border to auto-fit width
- Use $ for absolute references (e.g., $A$1)
- Ctrl + Click to select non-adjacent cells
- Drag fill handle to copy formulas/patterns
- Use Flash Fill (Ctrl + E) for pattern recognition
- Press F4 while editing to cycle through reference types
- Name ranges for easier formula reading (Formulas > Name Manager)