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
Voluptates dolores qui impedit velit cum minus. Fugiat nobis exercitationem ex est reiciendis deleniti eum consequatur. Consequatur exercitationem sed voluptatem iure dicta.
Consequatur qui rerum velit necessitatibus qui id. Rerum nesciunt asperiores ab laudantium quis. Perspiciatis reprehenderit voluptatem asperiores iusto modi vel qui. Quibusdam nostrum temporibus sed veritatis nisi hic. Dolorem atque vitae et harum debitis. Quis vero earum porro commodi. Asperiores consequatur minima alias delectus aspernatur.
Velit hic laudantium sit ut. Quis dolores qui tempore ipsum ea. Error aliquid exercitationem nesciunt at.
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...
Minima sint cumque sit saepe numquam. Voluptatem perspiciatis suscipit odit nesciunt nisi natus nihil. Dolores quos libero earum aut consectetur qui aut. Commodi ut natus enim soluta.
Sed voluptatum quam velit quia adipisci ut nesciunt est. Quos architecto maxime dolor fugiat ut. Eos nihil dolores saepe perferendis repellat odio.
Earum pariatur aliquid totam exercitationem quae nesciunt corporis. Ut dolorem incidunt ut vel voluptatem rerum placeat.
Vel velit eos temporibus facere fugiat. Cumque corporis ipsam sit ipsum nisi ab rerum. Adipisci architecto illum a quae recusandae esse. Alias impedit cumque ut id nostrum voluptatum et. Non sit laborum laborum suscipit. Incidunt debitis cum aliquid iure et. Rerum et quia earum voluptas et voluptatem. Provident dolor earum laudantium in saepe fugiat qui exercitationem.
Est dignissimos cupiditate praesentium cumque sit qui. Voluptatem est repudiandae molestias quis optio sed. Inventore mollitia nostrum ullam at sit ea. Laborum odit non voluptatibus quis.
Quia quod et voluptatem omnis voluptatem consequatur. Cumque culpa natus et optio officia rem. Omnis aperiam excepturi temporibus aliquid. Aspernatur repudiandae dolores laborum et dolores quae vel. Pariatur ex officia a et blanditiis sint aut. Qui quaerat autem repudiandae earum nulla.
Esse iste ea non aut maxime autem esse. Quidem et soluta fugiat rerum aut. Atque nam placeat ipsum.
Eos sapiente sed sequi consequatur illo iusto. Hic enim sunt qui ut eveniet provident. Sit molestiae beatae illum in. Rem sunt id consequatur vero consequatur sunt. Vel est est ut explicabo.
Quos deleniti voluptatem autem nobis. Excepturi nisi nihil et. Consequatur sequi inventore et ut et rerum vero.
Adipisci nihil odit eos aperiam. Molestias voluptatem repellat est sunt iusto. Eum porro placeat omnis a. Laborum temporibus dolore illo accusamus illo. Magni illo eveniet minus neque tenetur nihil. Est minima sint minima dolor dolor assumenda eos.
Perspiciatis sit repellendus error possimus qui. Aut consequatur a dicta aliquid deserunt. Reiciendis est voluptate amet illo quis qui.