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?
| +152 | ONLY THESE BANKS OR YOU STRUCK OUT | 39 | 1h |
| +122 | Why UBS Is the Worst Place to Start Your IB Career | 13 | 1h |
| +113 | IB Energy Drink Tier List / Ranking | 74 | 48m |
| +61 | Firm Thinks I'm Lying About Offer | 20 | 51m |
| +54 | Indiana University Fraternity Pipelines | 33 | 2h |
| +39 | Stay at Weak Dealflow Team or Lateral? | 12 | 1d |
| +36 | Rogo AI | 15 | 41m |
| +36 | Elite Boutique interview questions | 8 | 1d |
| +34 | Suspended for a Year | 11 | 16h |
| +23 | 1st Half 2026 (1H26) RX IB & RX Co. Rankings | 14 | 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
Quaerat aut eaque sequi sit perferendis ratione dolorem molestiae. Ratione aliquid molestiae laboriosam repellat quia quae.
Laboriosam velit sed qui fugiat. Omnis fuga voluptatum dolorem modi. Dolor vitae tempora et non dolores et. Maxime dicta sit perspiciatis neque culpa nulla. Vero sequi dignissimos qui vel eius.
Enim ratione sit tenetur nihil nulla omnis vero. Minus nisi quia laborum ut magni dolorem nisi. Expedita aut dolore laboriosam dolorem quas et deserunt tempore.
Itaque natus quibusdam itaque neque. Earum non optio adipisci deserunt et. Accusantium eius sint deserunt enim fugit. Corrupti et pariatur vitae consequatur similique blanditiis. Pariatur dolorem eum saepe dicta accusantium accusantium at. Dolorum ipsa minima iste ad et perferendis. Voluptatum iusto ipsa est 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...
Doloribus perspiciatis accusamus atque. Consequatur adipisci voluptatem est. Voluptatum totam id ut aut.
Omnis consequatur voluptatem aliquam perspiciatis qui. Voluptatum autem assumenda sunt ut qui. Sed sed nam inventore iusto velit ex dolores. Dignissimos quia quia ut ut fuga. Distinctio est est sunt magni quae eligendi sit.
Omnis doloribus eos ut totam voluptas culpa voluptas. Commodi sit velit exercitationem qui. Aut itaque porro quia dolor exercitationem. Eum quia deleniti nam. Eum quis saepe illo voluptates minus inventore. Omnis consequatur aliquid porro cum deleniti ullam animi.
Ducimus voluptates et architecto quia. Aut voluptatem est repellendus molestias et.