APPENDIX A
Keyboard Shortcuts
Provided is a table of Excel keyboard shortcuts. This is not a full list of shortcuts but is a selection based on their relevancy for modeling. The best method of learning these shortcuts is to refer to this appendix as you use Excel to tackle a situation.
Alt + = |
Insert the SUM formula |
Alt + F1 |
Insert a Chart Sheet |
Alt + F11 |
Display the VB Editor |
Alt + F8 |
Display the Macro dialog box |
Alt + Shift + F1 |
Insert worksheet |
F1 |
Open online Help or the Office Assistant |
F2 |
Edit active cell |
F5 |
Go to |
F7 |
Check spelling |
F9 |
Calculate all sheets |
F11 |
Create chart |
Shift + F2 |
Edit cell comment |
Shift + F3 |
Insert a function into a formula |
Shift + F5 |
Search |
Shift + F9 |
Calculate active worksheet |
Shift + F10 |
Display shortcut menu |
Shift ... |
Get The Basics of Financial Modeling now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.