Favorite excel shortcut?
Was asked in an interview "What is your favorite excel shortcut?"
I responded, "ALT+A+S+S = Sort".
Any other favorites out there?
Was asked in an interview "What is your favorite excel shortcut?"
I responded, "ALT+A+S+S = Sort".
Any other favorites out there?
| +160 | As Lehman people reconvene at UBS, Barclays needs to hire (2023) | 23 | 6h |
| +126 | Is pay at BofA really that bad? | 62 | 2h |
| +88 | Day at Macquarie | 12 | 23h |
| +57 | Worlds Worst MDs Competition (2026 Edition) | 11 | 35m |
| +45 | How bad did I mess up | 10 | 1d |
| +44 | Is the life of a VP at a 'top-bank' really good? | 15 | 3d |
| +31 | Misrepresented Houston IB | 14 | 1d |
| +29 | No BB RO 2026 | 10 | 2d |
| +28 | JPM SMALL CAP or WF/JEF/RBC Coverage group | 13 | 20h |
| +24 | T(ouse)D Securities | 9 | 2d |
Career Resources
ALT+F4
Alt + f + h + e + a = send that mofo model out and hit the clubs
Its not excel, but control+alt+delete and then enter, followed by me quickly walking out the door to my car is my favorite shortcut.
Save time by doing the windows symbol button + L. Save even more time by setting up a mattress outside and hopping out the window. You'll be in your car before you know it.
alt + e + s + (v,t,f,x)...paste special always comes in clutch
I was going to say ALT + E + S + T, makes my life so much easier
.
Hit them with an Alt + L + DM or Alt + L + I + U and use it to mention that as a VBA God you can automate much of the work
CTL + Alt + Left Arrow
Ctrl + V
F1
ALT + Tab to Outlook, CTRL + N, type up email to analyst, ALT + S. Model done.
Any time I receive a model, ALT + M + N (Name Manager) and look at the shitshow of broken links to desktops of the client and other banks, cell names like "fuckbanking," "ebitda" (12 times) references to old versions of models or another deal entirely, etc.
If you haven't tried it, I strongly recommend it.
This is too true. Blows up your model size as well.
Highlight all constants: F5 + Alt S + O
Highlight all formulas: F5 + Alt S + F
Any of the Alt + E + S paste functions.
Alt, A, E, Enter, Enter, Enter
It get's rid of those stupid green triangles that pop up on cells.
CTRL + C, CTRL + V.
Alt + H O T
Gotta make sure those tabs colors are in order. Also useful for picking up hardesses.
ctrl + windows + Q
Veritatis tempora voluptatem qui dolorem laborum suscipit. Veritatis tempora et et qui libero. Qui alias nihil ut molestias dolores minus occaecati doloribus. Consequuntur et dolores eum aut unde non.
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...
Soluta iusto eveniet aliquid ut expedita placeat et. Voluptatem a in et quas minus in. Nihil ratione dolores id deserunt nesciunt. Officiis omnis et id numquam rem inventore dicta. Ut voluptas accusamus consequatur. Vel iure sit aut cumque velit sequi quibusdam. Cumque quo voluptatem et vel.
Nihil quia quia vitae qui ea hic id. Earum libero officia odio fugit. Quas illo aut velit sunt est eligendi error. Deleniti ducimus aliquam est sed dolorem quos harum. Cumque facilis quia est possimus blanditiis.