Home > Excel Shortcuts By Category > Formulas
Excel Keyboard Shortcuts for working with Formulas
| Shortcut |
Action |
| = (+) |
Formula |
| F9 |
Calculate All |
| Alt
= (+) |
Auto Sum |
| Alt
F11 |
VB Editor |
| Alt
F6 |
Switch To VBA |
| Shift
F2 |
Edit Comment |
| Shift
F3 |
Paste Function |
| Shift
F9 |
Calculate Worksheet |
| Ctrl
/ |
Select Array |
| Ctrl
\ |
Select Differences |
| Ctrl
] |
All Dependents |
| Ctrl
` (~) |
Toggle Formula View |
| Ctrl +
Shift
/ |
Select Array |
| Ctrl +
Shift
[ |
Direct Precedents |
| Ctrl +
Shift
\ |
Select Unequal Cells |
| Ctrl +
Shift
] |
All Precedents |
| Ctrl +
Shift
6 (^) |
Exponent Format |
| Ctrl +
Shift
A |
Formula Arguments |
