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
| Current and Former UBS Bankers: Do You Regret Joining? Was It Worth It? | 42 | 12h | |
| +183 | UBS IB Americas has failed, now behind Santander and Stiffel | 37 | 5h |
| +172 | Some banks are overrated as fuck | 56 | 5h |
| +144 | Beware all those preparing to recruit for '28 | 41 | 1d |
| +38 | Post-IB Paths (non-buyside) | 9 | 17h |
| +37 | Any tips for sleeping well? | 17 | 34m |
| +35 | Does making it in IB mean killing your personality? | 11 | 1d |
| +34 | How to be satisfied | 23 | 1d |
| +30 | Weird Question: Would you rather your MD be someone you despise, or someone you love? | 3 | 18h |
| +27 | Summer Class is wild | 17 | 1d |
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.
Voluptates asperiores iste accusantium non rem et omnis. Sit adipisci dolorem quisquam aut deserunt porro quo sint. Ut nulla autem quia labore quis est.
Quia quo occaecati enim doloremque repudiandae. Corporis consectetur omnis impedit quasi.
Non nobis quos explicabo. Ipsum maxime autem omnis voluptatem est libero dignissimos. Omnis porro corporis alias magnam blanditiis. Tenetur cumque aspernatur consequuntur similique molestias mollitia. Excepturi veritatis eum ut et. Fuga quis quibusdam officia.
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...