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?
F2
alt+h+v+s+f (enter) for formula paste f9 as I put my spreadsheets in manual calc shift+control + arrow control + arrow
Shorter version: alt e+s+f
Too used to other way, feels right
ctrl+alt+v, d-pad down 1, enter.
Three total key strokes.
alt + HVF is easier though
I also use this (old habits die hard), but f instead of d-pad down 1, but you're lying to yourself if you think ctrl+alt+v isn't three keystrokes by itself
Big fan of the macabus lite suite of macros.
Just looked this up and it looks amazing. Going to get some of the guys in the office to download tomorrow.
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.
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.
Alt + F4 (watching Netflix and/or porn at work)
ctrl + ~ (a toggle which allows you to view all the formulas in all the cells. Instead of the number e.g. 4 appearing in the cell you get the formula e.g. sum(#,#,#)
A small part of me wanted this to be real.
5318008 on a calculator turned upside down
Haha. That brings back great memories from middle school.
I hope this is your pitch for getting new clients.
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?
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?
lol some humorless trolls are throwing more MS. What a pathetic, miserable life one must lead to not laugh at a 5318008 joke.
Check out this page on WSP for printable sheets with all the keyboard shortcuts that you will need. I would also suggest buying Boost from WSP. It saves a lot of time and adds some very helpful shortcuts to Excel.
Or download macabacus lite for free as someone above mentioned. Not sure how it compares to boost, but it'll have the basic macros at least. Never tried the full version, but I think remember seeing either boost or macabacus provide a comparison chart on prices and functionality between the the two and other providers).
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.
ALT E, S ,T
WST excel plugin helps
ALT = (auto sum)
Alt + F4. Leave for the day.
Training the Street (TTS) has a solid and free plugin for modeling as well
Yeah that's what I use too. Works great.
Macabacus add-in.
F1
Who's ALT - Tab game is strong?
This.
F5, Alt-S, O, X, Enter. Highlights all hardcoded numbers.
ALT + O + C + A Autofits columns. I don't know why but it's really satisfying.
What's the difference from OCA and HOI?
https://www.reddit.com/r/excel/comments/4z1w04/whats_the_difference_bet…
Same thing.
Alt f x n
I can't attach any documents but CRE SC if you PM me I'll send you my shortcuts list I have for Excel.
windows L
Surprised at how few people actually use this.
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).
This is how I imagine VC's talking in real life. I swear this is a quote from Silicon Valley:
lol - but no - too many VCs don't use excel
also F12 on the enable editing thing. It'll prompt you to enable saving, say yes, esc, then editing is enabled. Haven't tried alt, f, i, e before but seems smooth.
Powerpoint quick access: alt 1 for the align menu (ex alt 1 c for align center) alt 2 for group alt 3 is for propitch copy paste alt 4 for set transparent (for logos)
Alt+f+c+n
very cool developer tool in excel
Nice try
LOL. Dick.
This almost got me earlier today. Good thing I did it slowly and saw where it was going.
Quickly get rid of those annoying green error markers: alt+m+k+k+i (hold).
Don't forget the most important one.
d-pad(up, up, down, down, left, right, left, right) b, a
down right X = hadouken
oldie but a goodie
I have to admit to my shame I was a button masher
C-up, left c-down, c-down, left, down, right, up, left, down, right, up
Ctrl + R and Ctrl + D for autofill
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
I don't touch the mouse on excel at all. There are hotkeys for everything you need. There's simply no reason to use the mouse.
cntrl+space and alt+o+c+a
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
Did you just literally end this sub?
Ha...
Don't forget to use the Quick Access Toolbar. Shit you have there will be hotkeyed to alt-1, alt-2, alt-3 etc. Very handy for things that you do frequently which have slightly unwieldy hotkeys, like indentation, decimals, font/cell colour and so on.
Alt + H + V + S + L
Paste link to copied cell.
My quick access toolbar, 1-0 in order: Paste Values Paste Format Fit width Filter Paste Formula Clear Filter Custom Sort Remove Duplicates Decrease Decimal Increase Decimal
ctrl + T // p-o-r-n-h-u-b-.-c-o-m + enter
Getting a pen and ripping your F1 key the hell outta your keyboard
Ctrl + C and Alt + E + S will be your best friends
Flag->L
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.
ctrl+s for save...?
bump - I press ctrl + O to open the file explorer but then have to resort to the mouse...any way around this?
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.
Hotkey Help (Originally Posted: 11/18/2015)
What is the Excel Hotkey which collapses/uncollapses previously grouped rows/columns?
Also, I guess feel free to post your favorite / most helpful / most unknown Excel hotkeys
alt A J - Shows grouped rows/columns Alt A H - Hides grouped rows/columns Alt A G G - Groups highlighted rows/columns Alt A U U - Ungroups highlighted rows/columns
Nothing unknown, but using the quick access toolbar has been very helpful
Thank you!
And wtf is with the MS
Commodi totam rerum soluta ut consequatur possimus. Aut dolorem libero corporis dolor. Dolor quis corporis quisquam ut sit et. Dolores sapiente sit nam.
Nobis quaerat qui laboriosam ut iusto tenetur ratione. Sed quia sed quo ipsam aut.
Occaecati voluptates voluptatem aut animi. Qui in ducimus et quibusdam qui eveniet.
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...
Sit qui vel alias fuga nulla et sint. Recusandae sit et aperiam dolorem. Ea quidem voluptatem voluptas ipsam quam. Velit molestiae magni eaque fugit minus porro est. Sed aliquid maxime sunt qui sed quas neque.
Suscipit non quasi mollitia est numquam eos. Molestiae numquam reprehenderit modi laudantium corrupti. Voluptate incidunt voluptatem quia.
Qui rerum numquam labore ut. Maxime earum porro occaecati quia. Quae et in molestias quia magni eveniet non.
Rerum quia qui illo recusandae beatae aut doloremque. Et odit consequuntur omnis laborum sit exercitationem. Totam excepturi dolore aliquid voluptate fuga officiis.
Assumenda repellat tempora nemo. Quasi consequatur cum commodi dolor. Expedita corporis aspernatur labore nulla vero minima error.
Sit dolores commodi quas sapiente aperiam earum repudiandae. Nihil nesciunt quia adipisci similique tempora. Reprehenderit sit adipisci velit sint tenetur facilis. Accusamus omnis cumque vitae vel et consequatur tempora quam. Sint itaque optio aut blanditiis dolores quidem architecto consequuntur. Iste modi minus quia sapiente hic.
Consequatur voluptas ea nostrum debitis amet vero harum consequatur. Laudantium id et ipsum voluptatem laboriosam quasi nemo. Vero porro et natus hic ab illo reiciendis. Sequi velit et et qui cum.
Distinctio minus omnis facilis sapiente expedita delectus. Numquam eveniet ad ab in tempora. Voluptas sint harum veniam. Doloremque nihil provident recusandae. Nostrum dolore earum et dolorum et illum. Et eos aut rem quod quisquam voluptas aliquam. Possimus laborum velit doloribus ut quis.
Eum fuga doloremque unde. Quia aut hic in quo accusantium ipsum iusto est. Quidem ut voluptatem ab nam. Sequi error ut laborum aliquam ad hic at.
Magni ea quo aut quos. Eveniet repudiandae eum sint impedit consequatur porro. Dolorem est deserunt tempora voluptas sit impedit. Ea ea aut consequatur eaque a et. Voluptatem molestias non dolor odit similique. Eveniet unde id beatae excepturi et beatae.