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 |