| Toggle absolute & relative references |
F4 |
⌘
T
|
| Open Insert function dialog |
Shift
F3
|
Fn
⇧
F3
|
| Autosum selected cells |
Alt
= |
⌘
⇧
T |
| Toggle formulas on and off |
Ctrl
` |
Fn
` |
| 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/collapse formula bar |
Ctrl
Shift
U
|
⌃
⇧
U
|
| Display function arguments dialog box |
Ctrl
A |
^
A
|
| Define Name |
Ctrl
F3 |
Fn
^
F3
|
| Define names from labels |
Ctrl
Shift
F3
|
Fn
⌃
Shift
F3
|
| Paste name into formula |
F3
|
|
