Formula Shortcuts in Excel

To do this action	Press in Windows	Press in Mac
Autosum Selection Of Cells	Alt+=	⌘ +⇧ +T
Calculate Active Worksheet	Shift+F9	Fn+⇧ +F9
Calculate All Worksheets	F9	Fn+F9
Cancel Entry In Formula Bar	Esc	Esc
Complete Entry In Formula Bar	Enter	Return
Copy The Value From The Cell Above	Ctrl+Shift+"	⌃ +⇧ +"
Create Chart In A New Sheet	F11	Fn+F11
Create Embedded Chart	Alt+F1	Fn+⌥ +F1
Define Name For References	Ctrl+F3	Fn+⌃ +F3
Display Function Arguments Dialog	Ctrl+A	⌃ +A
Display Message For Error Checking Button	Alt+Shift+F10
Edit Active Cell	F2	⌃ +U
Expand Or Collapse Formula Bar	Ctrl+Shift+U	⌃ +⇧ +U
Force Calculate All Worksheets	Ctrl+Alt+F9
Input Array Formula	Ctrl+Shift+Enter	⌃ +⇧ +Return
Insert a Function (Opens a Dialog Box)	Shift+F3	Fn+⇧ +F3
Insert Function Arguments	Ctrl+Shift+A	⌃ +⇧ +A
Invoke Flash Fill	Ctrl+E
Move To End Of Text When In The Formula Bar	Ctrl+End	Fn+⌃ +→
Move To Next Record Of Data Form	Enter	Return
Open Macro Dialog	Alt+F8	Fn+⌥ +F8
Open Visual Basic For Applications (VBA) Editor	Alt+F11	Fn+⌥ +F11
Paste a Name	F3
Select Text In Formula Bar To End	Ctrl+Shift+End	Fn+⌃ +⇧ +→
Toggle Absolute or Relative References	F4

For More Shortcuts (Click on the links below):

Excel Ribbon Tab Shortcuts for Windows

Shortcuts to Make Selections in Excel

Formatting Cell Shortcuts in Excel

Inside the Ribbon Shortcuts in Excel

Frequently Used Keyboard Shortcuts For Mac & Windows in Excel

Excel Cell Navigation Shortcuts For Mac & Windows