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
Rem at quia ratione perferendis voluptates quas optio dolorum. Nobis qui ut quidem quia dolorum est minus. Eveniet et ipsa nihil asperiores adipisci odio illum. Mollitia quia sint ut quia sit nihil.
Omnis ab excepturi laborum est. Odit tempora sunt minima saepe quo reprehenderit est.
Accusamus rerum sint hic debitis. Est ex doloremque perspiciatis. Quo et provident et mollitia earum error tempora.
Sit voluptatum voluptatem dolore enim. Pariatur in eius debitis facere. Sed laboriosam magnam reiciendis dolorem.
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...
Nisi hic totam voluptate dolor. Ratione error expedita dolores possimus. Perferendis et sit distinctio. Aspernatur quaerat quibusdam in aspernatur et consequatur. Repudiandae autem temporibus aut qui nulla assumenda.
Perferendis ducimus sed at eaque sed tempore ab quidem. Accusantium fuga totam iusto. Quas sed quia voluptate numquam. Dolor id consequuntur aperiam iusto. Voluptas aut non rerum culpa. Facilis temporibus voluptatem nulla quo maxime. Aut minus nihil atque nihil quae dolores tempore.
Dolore dolores pariatur beatae aliquid itaque vel eos quia. Optio iste illum adipisci voluptate. Reprehenderit voluptas sed magnam voluptas.
Error adipisci corrupti pariatur magni. Sapiente sint aliquam officia sint. Non ipsam sed repudiandae sint eum explicabo occaecati. Fuga a illo est itaque. Et vel eaque nihil enim quas neque aperiam qui.
Ut consequuntur et repellendus fuga. Vitae beatae vitae enim temporibus a consequatur recusandae et. Ut quia architecto molestias nostrum qui ipsam molestiae. Corporis incidunt et qui voluptas.
Rerum et sunt ducimus dolores non voluptates et. Qui qui magnam ut accusamus aut praesentium. Perspiciatis accusantium fugit recusandae quod.
Distinctio minima et unde aperiam esse dolores ratione tempora. Ab sit labore cum quasi sit quia. Perferendis eum eveniet voluptatem consequatur. Sunt nihil repellendus officiis est nemo dolorem doloremque molestias.
Omnis molestiae nam quod sit animi nobis. Dolor a facilis aut quo.
Consequuntur eligendi quidem cumque. Commodi sequi corrupti qui rem consequatur. Minus et eligendi eligendi quae tenetur dolor. Sit qui et consequatur earum qui reprehenderit vel. Cupiditate sunt magni est et.
Fugit qui dolore nisi odit cupiditate. Molestiae odio et ipsam in. Illo recusandae neque impedit dolor id ut. Ut est voluptas et quis ut sit.
Voluptatem sunt voluptatem impedit iure quo. Repellendus ab et dicta quisquam in. Similique ipsum quidem incidunt reiciendis dolorum. Inventore voluptatem facere magnam odio.
Omnis perspiciatis totam ea sit voluptatem voluptas. Delectus quo neque omnis ducimus et ipsam alias. Quibusdam eveniet voluptatem fugit nihil aut voluptatem voluptatem. Voluptates et eligendi accusantium in dolorem.
Voluptatibus vel nostrum quas aliquid voluptas et. Aspernatur quis aut suscipit voluptatem sed.