To clarify, I'm not looking for lists of helpful Excel shortcuts as those already exist. Are there any specific shortcuts that you have found, looked up, or hard-coded that you enjoy using?
| +271 | Is UBS really that bad? | 51 | 9m |
| +258 | Investment Banking is Divine | 40 | 1d |
| +219 | Another $115bn Mega deal for these banks. Congrats! | 45 | 1d |
| +216 | US 2027 SA IB worried about background check | 53 | 1d |
| +206 | Analyst: Why is UBS IB doing worse than peers?, UBS CFO: No Comment | 41 | 2d |
| +206 | Leaked Interview Questions to Recruiting Services | 68 | 2d |
| +40 | Is Houston SA 28 recruiting already over? | 34 | 1d |
| +31 | How do you manage nerves in IB technical interviews? | 7 | 12h |
| +27 | FIG Pigeonholes you - is it true? | 8 | 2d |
| +27 | 2026-27 IB Energy Top Banks | 8 | 1d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Ripping out the F1 key.
ctrl + shift + L? Or you just like using uppercase Ls?
yeah i missed the ctrl. but i do like uppercase Ls as i was an avid blunt roller
Selecting all hardcoded numbers: 1. F5 2. Alt + S 3. O 4. X ENTER
Alt + F4
Some of my faveorites, in no particular order:
F12: Save as F7: Spell check Alt + E + S: Paste Special Alt + H + O + I: Auto fit column width Alt + =: Auto sum Ctrl + Shift + %: Percentage formatting Ctrl + 1: Formatting dialog Ctrl + G, then Alt + S: Go to special Alt + H +0/9: Move decimal places out/in
Windows + L -> beer
I didn't even know the F1 key had any function, so I don't know what good tearing it out does.
My favorite shortcut is to have other people do it for me. Very effective and time saving technique for me.