These Excel shortcuts saved me 10+ hours a week when I was working in Investment Banking.
1. Ctrl + Page Up / Page Down: Move between worksheets instantly without touching your mouse.
2. Ctrl + Arrow Keys: Jump across large datasets instantly without scrolling.
3. Ctrl + Shift + Arrow Keys: Select entire ranges of data in one move.
4. F4: Toggle absolute and mixed references when building formulas.
5. F7: Run spell check across the worksheet.
6. Ctrl + [: Jump straight to the cell driving a number.
7. Ctrl + ]: Jump to cells that depend on the selected value.
8. Ctrl + 1: Open Format Cells and adjust number formatting.
9. Alt + =: AutoSum selected ranges quickly.
10. Ctrl + Shift + L: Turn filters on or off for a dataset.
Learning shortcuts like these won’t make you a great banker by itself, but they will make you much faster in Excel.
#excelshortcuts #exceltips #investmentbanking #financialmodeling #wallstreet