Most important excel short cuts in IB
What are the most important excel short cuts to know for IB? So which one do you use most frequently?
Trending Content - Investment Banking Forum
| +221 | Why UBS Is the Worst Place to Start Your IB Career | 35 | 3h |
| +162 | ONLY THESE BANKS OR YOU STRUCK OUT | 41 | 3h |
| +65 | Firm Thinks I'm Lying About Offer | 20 | 1d |
| +59 | Indiana University Fraternity Pipelines | 36 | 2h |
| +50 | Rogo AI | 20 | 16h |
| +46 | Elite Boutique interview questions | 11 | 1h |
| +44 | Suspended for a Year | 19 | 11h |
| +39 | Stay at Weak Dealflow Team or Lateral? | 12 | 2d |
| +39 | UBS 2nd Year Analyst Q&A (2026) | 16 | 1h |
| +23 | 1st Half 2026 (1H26) RX IB & RX Co. Rankings | 16 | 15h |
Career Resources
F2
f5 + alt + S + O + X : Highlights all hard-coded numbers. Amazingly useful for color-coding models!
Control-F / Search bar -> "Excel shortcuts"
ALT E S V
Alt + F4
Alt + Tab to go back to Excel so it looks like you're working.
I like having an alt key reference sheet. Helps when you want to just run with the 9 digit.
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
Open Formatting = Ctrl + 1 Space All Columns = Ctrl+A then Alt + H + O +I Filter = Alt + A + T Underline = Alt + H + B + O Color = Alt + F + C Size = Alt + F + S Move/Copy Sheet = Alt + H + O + M Open Task Manager When Excel Freezes = Ctrl + Shift + Esc Add a deg sign = Alt + 2 + 4 + 8
already a thread on this
Excel Short Cuts (Originally Posted: 12/26/2013)
Hi all
Just a simple forum topic that we can all share some of the best excel short-cuts we've come across...
F5, ALT+S, E, X, G is a favourite-highlighting all hard coded cells
ALT+F4
^ + N
^_^
Never heard of ALT + SEX G. Do you work at a brothel?
I have used ALT + E, G, S, O to find constants tho.
Nihil qui saepe porro id. Sit harum dolores cumque quia vel mollitia dolores.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...