| Toggle absolute and relative references | F4 |
⌘ T |
| Open the Insert Function Dialog Box | Shift F3 |
Fn ⇧ F3 |
| Autosum selected cells | Alt = |
⌘ ⇧ T |
| Toggle formulas on and off | Ctrl ` |
⌃ ` |
| Insert function arguments | Ctrl Shift A |
⌃ ⇧ A |
| Enter array formula | Ctrl Shift Enter |
⌃ ⇧ Return |
| Calculate worksheets | F9 |
Fn F9 |
| Calculate active worksheet | Shift F9 |
Fn ⇧ F9 |
| Force calculate all worksheets | Ctrl Alt F9 |
|
| Evaluate part of a formula | F9 |
Fn F9 |
| Expand or collapse the formula bar | Ctrl Shift U |
⌃ ⇧ U |
| Display function arguments dialog box | Ctrl A |
⌃ A |
| Define name | Ctrl F3 |
Fn ⌃ F3 |
| Define name using row and column labels | Ctrl Shift F3 |
Fn ⌃ Shift F3 |
| Paste name into formula | F3 |
|
| Accept function with autocomplete | Tab |
↓ Tab |