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
| +244 | Who Killed Wall Street | 69 | 2h |
| +198 | Worlds Worst MDs Competition (2026 Edition) | 47 | 8m |
| +170 | UBS Healthcare | 42 | 2h |
| +166 | Only Indians cold emailing | 51 | 2h |
| +125 | Lindsay Clancy - Thoughts from A2 | 22 | 3d |
| +58 | More diversity needed in the industry | 11 | 1d |
| +53 | Shana tova - happy new year | 9 | 2h |
| +49 | Did My Team Set Me Up to Miss VP? | 24 | 6h |
| +48 | NYC Wall Street Run Club | 13 | 21h |
| +43 | EB (EVR/CVP/LAZ) vs MBB (Bain/BCG) | 22 | 14h |
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