Formulas WIN MAC
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  
× Get In Touch With Us!