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
|
|