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?

Comments (80)

 
Oct 24, 2016 - 8:23pm

F2

I had a flair for languages. But I soon discovered that what talks best is dollars, dinars, drachmas, rubles, rupees and pounds fucking sterling.
 
Oct 25, 2016 - 9:30am

ctrl+alt+v, d-pad down 1, enter.

Three total key strokes.

  • 1
 
Oct 23, 2020 - 9:36am

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

 

 
Oct 23, 2020 - 9:36am

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

 

 
Oct 23, 2020 - 9:39am

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

 

 
Oct 23, 2020 - 9:39am

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

 

  • 1
 
Jan 10, 2021 - 10:00pm

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

 

 
Oct 25, 2016 - 8:26am

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.

 
Oct 25, 2016 - 11:21pm

What's the difference from OCA and HOI?

//Signed// MLang
 
Oct 27, 2016 - 1:18pm

Surprised at how few people actually use this.

//Signed// MLang
 
Oct 25, 2016 - 5:23pm

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.
  • 11
  • 1
 
Oct 31, 2016 - 6:17pm

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.
  • 1
 
Oct 25, 2016 - 11:19pm

This almost got me earlier today. Good thing I did it slowly and saw where it was going.

 
Oct 25, 2016 - 5:16pm

Quickly get rid of those annoying green error markers: alt+m+k+k+i (hold).

Thanks, let me know if you ever need an introduction in the industry.
 
Oct 25, 2016 - 8:42pm

my firm bought the macabacus pro (like $10/mo or something) and it is definitely worth it. totally revamped and better than turbo tts trace precedents/dependents, autocolor, and hundreds of other embedded macros which make life easier

 
Oct 31, 2016 - 4:40pm

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

  • 1
 
Nov 12, 2016 - 9:18am

Navigating Windows shortcuts (Originally Posted: 08/29/2011)

Ok - So I am in Windows and I want to save a file (pressing F12) now this dialog box opens. How can I save the file in the right location without pressing tab 25x (and I of course do not want to use the mouse)
Also I want to create a new folder, so I press the mouse down button on the keyboard and then w, but this only works if no other file is currently preselected. How can I unselect it.

What other shortcuts do you use for Windows ( I am not talking about the office apps). Like backspace and typing the beginning letter of a folder etc.

Thanks.

 
Nov 12, 2016 - 9:19am

ctrl+s for save...?

My drinkin' problem left today, she packed up all her bags and walked away.
Start Discussion

Popular Content See all

Girlfriend vs PE
+81PEby Investment Analyst in Private Equity - Growth Equity">Investment Analyst in PE - Growth
I’ll never take WSO for granted again
+50OFFby Principal in Venture Capital">Principal in VC
What's so good about Evercore?
+37IBby Prospective Monkey in Investment Banking - Mergers and Acquisitions">Prospect in IB-M&A
I'm tired man
+29IBby Intern in Corporate Finance">Intern in CorpFin
Friends in IB are chilling hard, how can I get this?
+18IBby 3rd+ Year Associate in Private Equity - LBOs">Associate 3 in PE - LBOs

Total Avg Compensation

January 2021 Investment Banking

  • Director/MD (9) $911
  • Vice President (31) $349
  • Associates (141) $232
  • 3rd+ Year Analyst (18) $155
  • 2nd Year Analyst (86) $151
  • Intern/Summer Associate (89) $144
  • 1st Year Analyst (345) $134
  • Intern/Summer Analyst (298) $83

Leaderboard See all

1
LonLonMilk's picture
LonLonMilk
98.5
2
Jamoldo's picture
Jamoldo
98.4
3
Secyh62's picture
Secyh62
98.3
4
CompBanker's picture
CompBanker
97.9
5
redever's picture
redever
97.8
6
frgna's picture
frgna
97.6
7
NuckFuts's picture
NuckFuts
97.5
8
Edifice's picture
Edifice
97.5
9
bolo up's picture
bolo up
97.5
10
Addinator's picture
Addinator
97.5