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
| +197 | Americas M&A League Table Q2 Updated | 79 | 3h |
| +131 | Restructuring: Anti-climactic Experience | 34 | 1d |
| +102 | IB Net Worth / Savings Check | 49 | 25m |
| +91 | Woman who emptied Knicks trashcan on street then stole it was DEI exec, worked at JPMorgan Chase | 24 | 13h |
| +80 | Stop sleeping on UBS - it’s pretty good | 26 | 2h |
| +52 | 2026 VAULT PRESTIGE RANKINGS | 29 | 1d |
| +39 | AI + Financial Modelling | 12 | 1d |
| +30 | Hardest interview experiences? | 16 | 23h |
| +28 | Summer before college | 17 | 13h |
| +26 | Current State of UBS in North America | 8 | 2d |
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.
Ut aperiam id autem exercitationem repellat ad repellendus iure. Quam quis sit fugiat sapiente. Voluptatibus tenetur ipsam rerum et quibusdam unde ut. Veniam est necessitatibus iure dolorum molestias sed nostrum. Mollitia distinctio quibusdam odio blanditiis ea nostrum quod. Atque nam nostrum eius et. Dolor sunt dignissimos nihil qui quibusdam.
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...