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
| +190 | Why UBS Is the Worst Place to Start Your IB Career | 32 | 6h |
| +160 | ONLY THESE BANKS OR YOU STRUCK OUT | 39 | 13h |
| +117 | IB Energy Drink Tier List / Ranking | 78 | 1h |
| +65 | Firm Thinks I'm Lying About Offer | 20 | 12h |
| +58 | Indiana University Fraternity Pipelines | 35 | 4h |
| +40 | Rogo AI | 20 | 1h |
| +39 | Stay at Weak Dealflow Team or Lateral? | 12 | 1d |
| +38 | Elite Boutique interview questions | 10 | 1h |
| +34 | Suspended for a Year | 16 | 27m |
| +23 | 1st Half 2026 (1H26) RX IB & RX Co. Rankings | 16 | 7m |
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