top of page

Top 10 Excel Shortcuts for Finance

Writer's picture: Overheard on Wall StreetOverheard on Wall Street

'Tis always hot key szn.

 

These shortcuts all work on a PC; if you have a Mac you’re either an MD who doesn’t need Excel, or you should go back to art school where you belong.


Alt W V G: Remove gridlines. Don’t be that guy who fills in cells white. Remove your gridlines and make your sheet look better.


Alt =: This is the auto-sum feature in excel. Typing +SUM() every time is a waste.


Alt E S / Alt H V S: This is the paste special window. This will allow you to paste as a value, paste formats, column widths, and many more.


F4: F4 has two uses: if you are not editing a formula, it allows you to repeat any action. If you are in a formula it will allow you to lock-in a cell, row, or column depending on how many times you hit it.


Alt M V: If you don’t have any CapitalIQ add-ins or things like that, this allows you to open up Excel’s formula auditor. You can audit through every part of your calculation here and see where (if anywhere) your formula is going wrong.


Alt H 0: Increase decimal places


Alt H 9: Decrease decimal places


Ctrl 1: Formatting menu


Alt H O I: Auto fit column width


Alt F T: Excel options menu


Should you need further advice, check out our excel courses here or get our full excel shortcuts cheat sheet here.

Recent Posts

See All

Top 5 Wall Street Interview Tips

Achieve the extra in extraordinary interviews Intro I had a lot of interviews going through investment banking and private equity...

Top Investment Banks

List of investment banks Intro Investment banks are typically bucketed into 3 categories. Bulge-brackets are banks you have probably...

Comments


bottom of page