Favorite Excel Shortcuts
Hi everyone,
I just started my internship and am using a lot of excel. What are your favorite shortcuts and/or functions to use?
Thanks
Trending Content - Investment Banking Forum
| +395 | Evercore Intern Seizure | 61 | 28m |
| +78 | JPM M&A is Gone??? Purely Coverage Banking??? | 35 | 13h |
| +57 | How do I understand vs. just memorizing? | 11 | 23m |
| +48 | Losing my personality in Banking | 9 | 1d |
| +42 | Associate & Above IB exits | 18 | 2h |
| +39 | The good and bad with Wells Fargo | 8 | 38m |
| +33 | Incoming IB Analyst: Best Ways to Prepare? | 12 | 43m |
| +30 | Tech to IB Pivot | 20 | 13h |
| +29 | Sent my Claude prompt to 200+ Teams chat. MD wants to see me Monday. | 18 | 5h |
| +27 | Which groups are ideal for laterals? | 12 | 1d |
Career Resources
F12 + “v189” + enter. Fuck excel…
Favorite combo:
alt + f4-close - Quit Application
Windows + L - Lock the Computer
Alt W V G - grid lines
Associate explained this trick over the phone as “Alternate wide v****a go”
No gridlines
F1
The alt button is your friend: when you need something on the ribbon, make it a habit to go there using alt - h/n/p/… and so on. Also in practically every dialog box, you can use the alt in combination with a letter (usually underlined) instead of having to use your mouse
alt w f f so that your dates row and category column remain visible
Someone else mentioned alt w v g to show and hide gridlines
Alt w n to open a new window of the same document which you can put on a different screen, really helps to navigate and play around with a model
Ctrl+alt+v x Enter, good for pasting a cell format without the borders
Ctrl+0/Ctrl+9/Ctrl+shift+0/Ctrl+shift+9: hide or show rows and columns
Shift/Ctrl+Space: select row/column
Ctrl+shift+’+’: insert before or above
Ctrl+’-‘: delete
Alt a g g/alt a u u: group and ungroup rows or columns
Alt a h/Alt a j: hide/show grouped cells
Ctrl+%: percentage number format
Clicking the X in the top right corner and logging off