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
| +327 | Which Offer to Accept: UBS Analyst Role or Part Time Cashier at the Local Taco Bell | 41 | 2h |
| +249 | AI is insane | 32 | 2h |
| +227 | I Snuck Into UBS Office And Took A Shit On The Floor | 22 | 1h |
| +203 | 2026-27 IB Energy Top Banks | 22 | 6h |
| +186 | Useless associates | 29 | 2h |
| +174 | How do you manage nerves in IB technical interviews? | 16 | 2h |
| +167 | Differences in Restructuring Teams? | 31 | 9h |
| +154 | TPH V.S. Mizuho [HOU] | 22 | 8h |
| +149 | GF is an IB Analyst at a top BB, hates it, what exit options does she have? | 26 | 5h |
| +141 | Roku-Fox Deal - UBS Misses Out on yet another deals after years chasing this deal | 24 | 2h |
Career Resources
F12 + “v189” + enter. Fuck excel…
I prefer google sheets
Favorite combo:
alt + f4-close - Quit Application
Windows + L - Lock the Computer
https://macabacus.com/excel/keyboard-shortcuts
Alt W V G - grid lines
Associate explained this trick over the phone as “Alternate wide v****a go”
No gridlines
I’m a mouth breather + sleep apnea and I keep grindlines off - you’re looking for the word pedo
Let’s get some niche ones that make your life easier. Not like Ctrl C lol
These are my most used ones:
Shift + F2 - add a note to FN assumptions
Alt + S + R + T - FactSet refresh sheet
Alt + 9 - my paste special shortcut, use this all the time to paste values/formatting/comments/etc.
CTRL + Shift + :/“ - FactSet shortcut for changing cell colors
CTRL + Shift + 3/4/5/8/y - FactSet shortcut for number formatting
CTRL + Shift + [ - FactSet cell reference tracing
>Alt + 9
why this and not just Alt + Ctrl + V lol
You gotta add #2 and #4 to your quick access changed my life
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
Ctrl + PgUp/PgDown
F5 + Enter after using Ctl + [ to trace a formula. Game changer
Clicking the X in the top right corner and logging off
A couple that come to mind (some of these are FactSet shortcuts that I created):
- CTRL + 1: format cells
- CTRL + 2: trace precedents in a formula
- CTRL + 3: trace dependents in a formula
- CTRL + 4: change cell color (choose between e.g. black, blue, green, purple, red)
- CTRL + ALT + E: automatically change cell color based on the contents of the cell (blue for hard inputs, purple for FactSet data, green for links to other sheets, red for formula in same sheet, etc.)
- ALT + WVG: remove gridlines
- ALT + HOI: change column width
- ALT + FT: Excel options
- ALT + HP / ALT + H0 / ALT + H9 / ALT + HAL / ALT + HAR / ALT + HAC / ALT + HMC (self-explanatory)
- ALT + SRS (FactSet refresh selection)
- ALT + SRT (FactSet refresh worksheet)
- ALT + SRW (FactSet refresh workbook)
- Shift + F2: insert comment
- ALT + RD: remove comment
- ALT + HEA: clear all cell contents
- CTRL + Space: select column (subsequently CTRL + - to delete column or CTRL + Shift + + to add)
- Shift + Space: select row (subsequently CTRL + - to delete row or CTRL + Shift + + to add)
- CTRL + Page up / Page down (navigate worksheets)
Can go on and on but these are a few of the ones I use the most
Alt h o i
Alt h b a
For convenience
I’m a bigger fan of having cell width/height on the quick access toolbar. Going alt h o i or alt h o w is so slow on company laptops. For whatever reason, accessing the ribbon via alt commands is super slow
Not on Excel, but Alt H V T on PowerPoint
Shift+F10 combined with the alt shortcuts literally 100% replace the mouse by themselves.
What’s shift f10?
Right click
.....or just own a keyboard that has the rick click button between the RHS alt and ctrl keys....
alt E S L, if u know u know
Most underrated one yet
Very nice
Ctrl Page up/down, Alt H M C, Alt H 0/9
Alt h m c is for terrorists…
For titles yeah, but data no. When it’s requested it’s my fav to do idk why
For titles yeah, but data no. When it’s requested it’s my fav to do idk why
Not career advice, but feels pretty good to ALT + F4
Alt h m u = unmerge cells
I only know mouse shortcuts
F7
alt a s s bc im immature
just discovered this recently, love this one
My best tip would be to learn how to use the shortcut system. That way, you can learn the shortcuts for the specific functions you're using. Always start with pressing ALT and then just follow the guidelines to get to the function you want to use. With time, you will learn the shortcuts you use often by heart. The ones I use most often are various formatting functions.
Alt, A, E. Be clutching up for me
Alt, G, S, B.
Get Some Bitches.
Control + W
Hitting F2 like a maniac at 2am and hoping my analyst didn’t blow up the model
Veniam atque et minima qui. Officia incidunt sit et iusto. Libero quae quia magni inventore.
Excepturi debitis occaecati voluptatem illo culpa sint. Nobis saepe est ea laudantium quis. Enim ab impedit numquam dolores modi aliquid qui. Voluptas culpa repudiandae at cum est adipisci ea. Soluta voluptatem quas blanditiis et maxime tempore vitae. Iure cupiditate dolorem pariatur ipsa consequatur laudantium. Repudiandae tempore voluptate est doloribus accusamus iure officia architecto.
Voluptatibus dolore nulla voluptatem soluta similique doloribus. Et suscipit ut accusamus quia aliquid ratione earum illo. Soluta animi quibusdam maiores consequatur magnam sunt dolor corporis. Est molestias reprehenderit non velit aut quod. Totam explicabo adipisci exercitationem maiores enim.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...
Molestiae eos optio odio ut. Qui enim error assumenda aut. Molestiae tenetur quas omnis harum est.
Qui non qui placeat minima iusto hic. Provident soluta natus aut.
Voluptas voluptatibus exercitationem repudiandae eum consequatur nihil neque. Voluptas eos voluptatem modi nemo debitis necessitatibus at ullam. Esse inventore fugit sunt magni. Omnis laborum sit occaecati iure voluptas. Voluptates nemo quasi iste eum mollitia omnis. Nihil distinctio aliquam numquam ipsam voluptatem placeat. Expedita neque eius nostrum architecto non repellendus saepe.
Voluptatibus tenetur quo sapiente cumque quas ipsum laborum accusamus. Ab quia impedit totam culpa. Nulla omnis sapiente doloremque tenetur commodi. Iusto nihil incidunt fuga et quibusdam nemo ut. Qui iure dolorum ullam aut amet eos.
Ex provident distinctio animi et magni qui. Mollitia tenetur debitis corrupti mollitia porro possimus repellat. Aut eos placeat dolore vitae doloribus consequatur possimus quos. Sit voluptatem tempore exercitationem molestiae iste repudiandae modi. Id harum corporis iste nihil sint nobis. Laudantium deleniti adipisci ut eos explicabo eius repellendus. Sit temporibus ut harum mollitia pariatur quas suscipit.
Maxime unde est harum assumenda ducimus excepturi. Fugiat fugit iure veniam velit. Cumque autem minima et cum omnis. Minima neque quidem ut aut aliquam corporis.