Formulas

Formula ActionWindows ShortcutMac Shortcut
AutosumAlt + =Option + =
Insert FunctionShift + F3Shift + F3
Edit FormulaF2F2
Apply Absolute ReferenceF4F4
Fill DownCtrl + DCommand + D
Fill RightCtrl + RCommand + R
Auto CalculateF9F9
Copy Formula OnlyCtrl + ‘Command + ‘
Array FormulaCtrl + Shift + EnterCommand + Return
Quick AnalysisCtrl + QControl + Q
Name ManagerCtrl + F3Control + F3
Evaluate FormulaShift + F9Shift + F9
 
%d