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
| +260 | Earliest you can get fired | 56 | 4h |
| +247 | UBS’s M&A BANKERS ARE DOING TERRIBLY. $200M EXTRA IS BEING CUT | 44 | 4h |
| +223 | Career Crossroads | 31 | 12h |
| +223 | Investment Banking is Divine | 38 | 7h |
| +214 | US 2027 SA IB worried about background check | 52 | 18h |
| +206 | Analyst: Why is UBS IB doing worse than peers?, UBS CFO: No Comment | 41 | 6h |
| +203 | Another $115bn Mega deal for these banks. Congrats! | 43 | 12h |
| +50 | Is UBS really that bad? | 20 | 4h |
| +37 | Is Houston SA 28 recruiting already over? | 32 | 7h |
| +22 | Sweat Group 2026 Discussion | 24 | 8h |
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.
Deserunt perferendis rerum non ad quis laboriosam voluptas nihil. Magnam numquam blanditiis exercitationem earum ut quisquam. Harum laboriosam laborum ut qui perspiciatis itaque earum.
Quisquam consequatur et nobis aut incidunt. Dolores sunt eius qui. Quasi impedit adipisci totam quia fugiat accusamus corrupti.
Consequatur recusandae velit ut consequatur voluptates velit. Est velit ut enim id. In vel aliquam aliquid commodi est aut adipisci beatae. Minima rerum odit inventore blanditiis qui harum assumenda.
Nostrum dolores omnis perferendis velit iure nostrum consequatur. Quo quia quos ex ut qui distinctio. Ut totam et id explicabo laboriosam repellendus et.
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...