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
| +160 | UBS Tech layoff | 52 | 1d |
| +149 | Analyst: Why is UBS IB doing worse than peers?, UBS CFO: No Comment | 24 | 7h |
| +146 | UBS’s M&A BANKERS ARE DOING TERRIBLY. $200M EXTRA IS BEING CUT | 31 | 10h |
| +63 | Leaked Interview Questions to Recruiting Services | 36 | 1h |
| +59 | Are target prospects getting dumber? | 27 | 8h |
| +58 | How do YOU manage networking requests? | 17 | 15h |
| +37 | Quitting After First 4 months | 12 | 1d |
| +34 | MBB Pay Raises | 26 | 1d |
| +19 | Rothschild UK - Mining & Healthcare 2026 | 5 | 3d |
| +19 | Career Crossroads | 2 | 2d |
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