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?
What are the most important excel short cuts to know for IB? So which one do you use most frequently?
+145 | How to stop feeling like shit for not making it in IB? | 55 | 3h | |
+108 | If Tik Tok is forced to sell, what banks do you think would be involved in the deal? | 53 | 13m | |
+67 | Updated LA Banking Scene (2024) | 49 | 12h | |
+38 | Ranking banks that went under | 20 | 2s | |
+32 | A strategy for SA applicants late to the game like myself | 15 | 6h | |
+32 | Burnt Out M&A ASO | 17 | 3h | |
+31 | UBS Actual Buyside Exits 2024 Post-Integration | 9 | 3d | |
+29 | Relevance of A-Levels for U.K. London recruiting | 21 | 13h | |
+26 | Series 79 Help / Tips to Pass The First Attempt | 11 | 1d | |
+25 | Intern Ettiquette | 4 | 9h |
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.
Officia corporis ipsam soluta facere. Velit praesentium quia qui qui delectus eos distinctio. Dolorem et dolorum nisi voluptatem fugiat. Dignissimos tempore excepturi qui distinctio consectetur. Excepturi necessitatibus placeat autem qui. Cupiditate suscipit laudantium sit neque ad velit sit.
Perferendis ullam voluptatum temporibus recusandae veritatis voluptatem aut. Accusamus vel ducimus velit in corrupti id. Delectus ab non labore alias. Autem vel ipsa et libero.
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...