All formulas start with =
| Formula | Description | Example |
|---|---|---|
| SUM(range) | Sum of values | =SUM(A1:A10) |
| AVERAGE(range) | Average of values | =AVERAGE(B1:B5) |
| MAX(range) | Maximum value | =MAX(C1:C20) |
| MIN(range) | Minimum value | =MIN(D1:D10) |
| Math | +, -, *, / operators | =A1*B1+10 |
| Type | Example | When Copied |
|---|---|---|
| Relative | A1 | Changes (A1→B2) |
| Absolute Column | $A1 | Column fixed ($A1→$A2) |
| Absolute Row | A$1 | Row fixed (A$1→B$1) |
| Absolute Both | $A$1 | Never changes |
| Ctrl+C | Copy cells (with format) |
| Ctrl+X | Cut cells |
| Ctrl+V | Paste cells (with format) |
| F2 | Edit cell |
| Enter | Confirm & move down |
| Tab | Confirm & move right |
| Escape | Cancel editing |
| Arrow Keys | Navigate cells |
| Delete | Delete selected image |
Are you sure you want to delete ""? This action cannot be undone.