Common Hotkeys - What do you use?

Monkeys, I've been trying to find online if there are any macros or hotkeys for the paste formula option. I find myself using this option all the time in my modeling and really can't find another method quicker than just right clicking and clicking paste fx. If anyone has any advice on this let me know - perfectly alright with still right clicking though.

Onto the main topic - what are your favorite hotkeys to use? Besides F4, Ctrl+c, Ctrl+v, Ctrl+z, etc. What do y'all use in your modeling methods that makes your jobs quicker/more efficient?

 

Finally got my firm to start paying for Macabacus recently. I would 1bn:1 still pay out of pocket for it regardless, but it was nice to put a tick in the W column in this dumpster fire of a year.

"In order to be a really good investor, you need to be a little bit of a philosopher as well." -Dan Loeb  
 

Finally got my firm to start paying for Macabacus recently. I would 1bn:1 still pay out of pocket for it regardless, but it was nice to put a tick in the W column in this dumpster fire of a year.

"In order to be a really good investor, you need to be a little bit of a philosopher as well." -Dan Loeb  
 

Whoever threw MS at this should go crawl back under their bridge and get back to hunting children. If this doesn’t make you laugh and bring back fond memories, are you even capable of feeling happiness in the first place?

"In order to be a really good investor, you need to be a little bit of a philosopher as well." -Dan Loeb  
 

Whoever threw MS at this should go crawl back under their bridge and get back to hunting children. If this doesn’t make you laugh and bring back fond memories, are you even capable of feeling happiness in the first place?

"In order to be a really good investor, you need to be a little bit of a philosopher as well." -Dan Loeb  
 

lol some humorless trolls are throwing more MS. What a pathetic, miserable life one must lead to not laugh at a 5318008 joke.

"In order to be a really good investor, you need to be a little bit of a philosopher as well." -Dan Loeb  
 

The best shortcuts that I did were just recording formatting macros and adding them to my quick access toolbar so that you can use alt 1, alt 2, alt 3, etc. I have 1 and 2 as increase and decrease decimals, 3 as center across selection, and then 4-6 are standard formats that we use on my team.

Some common others that I use, alt + (autosum), alt h l s (color scale conditional formatting), alt e a a (clears everything in the cell), f7 (spellcheck), alt h m u (unmerging cells when cleaning up books that I inherit), alt h w (wrap text). Will add to this if I remember more that I use commonly.

 

Never.ever.mouse. Only to turn off the security banner. alt-e-s-f is paste formula rookie - spend some time in the alt-e-s menu - will save you years over your career.

Mouse is never quicker - first you have to take it out of your desk, then put batteries in it, turn it on, sync it to bluetooth, then you can start clicking like an intern. Mo mouse mo problems - ne touche pas.

Everything should/can be mouseless and faster. windows+arrow keys to move windows, alt-tab to tab through programs, windows key+type name of program to open shit. ctrl-w to close tabs, ctrl-w-tab-space to close docs without saving (no tab/space to save). ctrl9/ctrl0 and shiftctrl9/0 for hiding and unhiding rows/columns - you might need to change language settings on windows if its not picking up the unhide columns. windows+L to lock the computer - happens to be the perfect fit for pinkie and thumb with 1 hand. windows-down to hide windows. ctrl-arrow key helps navigate through text much quicker - throw in a shift to highlight what you're navigating through.

There are just too many good ones - get used to not modeling with a mouse, force yourself to hit alt and follow the letters on the ribbon to find what you need - after 2-3 months you'll learn all the commonly used ones.

favorite combo? In excel - alt-h-o-e-f-f-tab-tab-tab-tab-tab-down-down-right-enter-tab-enter that's my "locked up behind xanax bars" fill

~gentleman on the streets, freak in the spreadsheets

EDIT: You can get rid of the Enable Editing banner with alt-f-i-e or you can create your own quick access toolbar, so no, there is literally never a reason to use the mouse. While we're on the topic, adding an email button to the quick access toolbar in excel/word/ppt is another good practice too - alt+4+e is fewer keystrokes than alt-tabbing to outlook, and ctrl-n for new email (ctrl+1, ctrl+n if you're not already in the email section of outlook).

Move like lions do.
 

This is how I imagine VC's talking in real life. I swear this is a quote from Silicon Valley:

"In excel - alt-h-o-e-f-f-tab-tab-tab-tab-tab-down-down-right-enter-tab-enter that's my "locked up behind xanax bars" fill"
Be excellent to each other, and party on, dudes.
 

Fix your comments with this ez macro.... You're welcome.

Sub Comments_AutoSize() 'posted by Dana DeLouis 2000-09-16 Dim MyComments As Comment Dim lArea As Long

For Each MyComments In ActiveSheet.Comments With MyComments .Shape.TextFrame.AutoSize = True If .Shape.Width > 300 Then lArea = .Shape.Width * .Shape.Height .Shape.Width = 200 ' An adjustment factor of 1.1 seems to work ok. .Shape.Height = (lArea / 200) * 1.1 End If End With Next ' comment

End Sub Sub ResetComments() Dim cmt As Comment For Each cmt In ActiveSheet.Comments cmt.Shape.Top = cmt.Parent.Top + 5 cmt.Shape.Left = _ cmt.Parent.Offset(0, 1).Left + 5 Next End Sub

 

What I normally do is copy the path you want to save the file to from the file explorer window. The hot keys are Alt + D to highlight the path, then copy and alt + tab to switch back to excel. Then F12 to open save as and paste the path in the file name box and hit enter. It will pull up the folder from the path you pasted, then you can name your file and hit enter to save the file in your desired folder/location.

 

Aut dolores at explicabo facilis voluptas ut enim. Perferendis commodi aperiam culpa magni quis. Quam eum expedita quod deleniti sunt. Nam blanditiis omnis vero numquam.

Cumque at explicabo rerum rem molestiae. Eius doloribus distinctio quae et perspiciatis in ut. Qui consequatur eaque eius odio vero sunt exercitationem et. Vel molestias aut ratione molestiae sunt totam. Doloremque consequatur id sit autem magni quisquam ex.

Et nobis earum deleniti molestiae explicabo. Quo facere ad sint aut architecto. Consequuntur dolorum modi architecto velit omnis. Et cum sit quia ea.

 

Atque dolore explicabo aspernatur explicabo non. Voluptas et earum consequatur eos vero vel ex atque. Quibusdam eveniet ipsam expedita minus quidem modi omnis. Sed id voluptatem qui architecto nemo.

Autem sint necessitatibus deleniti ut dolor numquam quia. Aut accusantium expedita soluta quibusdam. Aut enim saepe dolores ipsum officiis velit fuga. Quisquam laudantium aliquam fuga optio in recusandae totam.

Ratione dolor quas ut qui voluptatum voluptas ut. Error possimus debitis laborum. Sunt officiis et nihil sit eum excepturi. Tempore voluptatibus nam sit a quasi quia illo. Aperiam quaerat qui non accusamus et necessitatibus qui. Non et voluptatem error provident reprehenderit vel odit.

 

Sed et laudantium molestiae incidunt est praesentium. Modi quod cum placeat sit distinctio mollitia. Eos et et laborum cupiditate. Maxime sit autem autem eaque impedit aut fuga animi. Officiis et omnis nesciunt accusantium error. Dolores adipisci delectus qui at id sit omnis.

Necessitatibus quis a officiis est. Atque incidunt explicabo autem magnam.

 

Laudantium minima aut distinctio tenetur totam laborum. Ut quia sed quia. Sit totam illo nesciunt ipsam eveniet sint a. Autem soluta ut in quae.

Officiis facere voluptatum impedit ut nihil enim odit. Veniam quidem consequatur quo explicabo fugit. Aperiam quis fugit a ratione beatae eveniet voluptate. Incidunt cupiditate et quia adipisci eos. Consectetur omnis maxime quia perferendis. Mollitia placeat asperiores consequatur culpa nihil accusantium.

Aut et assumenda et vitae aliquid quisquam. Et quaerat explicabo ut non. Modi eum est vitae ea. Officiis consequatur neque repellendus doloribus. Sunt sit labore itaque aperiam iusto mollitia consequuntur. Exercitationem dolorem dicta voluptate perferendis esse. Veniam voluptatum officiis quo dolores.

Architecto non voluptas dolore. Est praesentium quo dolorem. Sunt non quo quia qui quaerat sed debitis non. Quo dicta provident cupiditate fuga excepturi nihil.

Career Advancement Opportunities

March 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. (++) 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

March 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

March 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

March 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (86) $261
  • 3rd+ Year Analyst (13) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (202) $159
  • Intern/Summer Analyst (144) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
BankonBanking's picture
BankonBanking
99.0
3
Betsy Massar's picture
Betsy Massar
99.0
4
Secyh62's picture
Secyh62
99.0
5
kanon's picture
kanon
98.9
6
DrApeman's picture
DrApeman
98.9
7
dosk17's picture
dosk17
98.9
8
GameTheory's picture
GameTheory
98.9
9
CompBanker's picture
CompBanker
98.9
10
Jamoldo's picture
Jamoldo
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”