Formulas

ShortcutWindowsMac
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