Comments (21)

Funniest
Sep 17, 2019

ALT+F4

    • 17
  • Associate 2 in CorpDev
Sep 18, 2019

Alt + f + h + e + a = send that mofo model out and hit the clubs

    • 2
Sep 17, 2019

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.

    • 6
Sep 19, 2019

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.

    • 1
Sep 18, 2019

alt + e + s + (v,t,f,x)...paste special always comes in clutch

    • 2
Learn More

7,548 questions across 469 investment banks. The WSO Investment Banking Interview Prep Course has everything you'll ever need to start your career on Wall Street. Technical, Behavioral and Networking Courses + 2 Bonus Modules. Learn more.

Sep 18, 2019

I was going to say ALT + E + S + T, makes my life so much easier

Sep 19, 2019

.

Sep 18, 2019

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

    • 3
Most Helpful
Sep 18, 2019

CTL + Alt + Left Arrow

Sep 19, 2019

Ctrl + V

Currently applying to medical school.

Sep 19, 2019

F1

    • 3
Sep 19, 2019

ALT + Tab to Outlook, CTRL + N, type up email to analyst, ALT + S. Model done.

Sep 19, 2019

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.

ferris bueller

    • 7
Sep 26, 2019

This is too true. Blows up your model size as well.

    • 1
Sep 19, 2019

Highlight all constants:
F5 + Alt S + O

Highlight all formulas:
F5 + Alt S + F

Any of the Alt + E + S paste functions.

    • 2
Sep 19, 2019

Alt, A, E, Enter, Enter, Enter

It get's rid of those stupid green triangles that pop up on cells.

Sep 20, 2019

CTRL + C, CTRL + V.

Sep 20, 2019

Alt + H O T

Gotta make sure those tabs colors are in order. Also useful for picking up hardesses.

Sep 23, 2019

ctrl + windows + Q

Sep 23, 2019
Comment
    • 2
Sep 26, 2019