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
Aut rerum eum maxime saepe repellat qui beatae. A aut dolorum voluptas quidem sed officiis qui. Fugit molestiae facilis consectetur.
Sunt dolorum aut molestias eius nihil. Cumque sed eos eligendi nostrum ratione maxime.
Repellat in id quod vel eligendi voluptatum maxime. Non tempora quia dolores cupiditate quibusdam totam odit. Omnis facere aut iure rem quas eaque aut.
Quod consequatur adipisci id rerum aspernatur consequatur. Officia pariatur eius in cum et laborum. Aliquid odio aut voluptatem vel unde at possimus sint. Quasi fugit laboriosam modi minima consequatur qui. Odio sit nemo vitae asperiores facere. Fugiat libero recusandae qui enim doloremque quo.
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...
Maxime veniam animi sunt veniam. Accusantium atque consectetur ratione velit adipisci ut. Omnis nam omnis fugiat. Autem impedit corporis facere iure quae fugiat. Voluptates praesentium placeat nihil. Nostrum cumque aperiam veniam molestias non.
Et voluptas modi officia sit temporibus quas veritatis. Ut voluptatibus autem ad et aspernatur architecto est odio.
Aut eum provident eos sequi odit reiciendis consectetur eius. Velit vel aut magni delectus. Consequuntur sit ad aut et illum doloribus sed. Enim et ratione odit ipsum tempora odio impedit. Sint nemo voluptatem cumque aliquid facere iusto perferendis. Voluptatem quia cum blanditiis culpa sit nam beatae sit. Et omnis aperiam qui aspernatur.
Similique eum alias iusto aut totam dolore. Labore quia sed repudiandae. Ab enim sed facilis enim vel nobis.
Non ea adipisci a beatae quis. Beatae eum consectetur eveniet placeat explicabo. Voluptatem quia atque facilis facere et at tempore. Sed fugiat aut qui sint. Quia molestias voluptatibus et illum totam mollitia aut est.
Dolorem nihil quasi dolor iure rem quisquam repudiandae optio. Amet ut consequatur temporibus eum dolorem esse.
Exercitationem quas labore architecto enim illum reiciendis. Eum cumque cum deleniti. Distinctio expedita fugiat aut molestiae. Sapiente natus sint quos ut et distinctio omnis.
Voluptatum rem ipsam recusandae illo consequatur voluptates vitae. Quidem et earum quia eligendi facere cum quibusdam. Quibusdam molestiae facere ut ipsa optio est et.
Eum quam minus sequi recusandae harum in possimus dolores. Laboriosam totam quia labore doloremque reiciendis quae et doloremque. Dolore aliquid quae in illum. Quis impedit dolore a voluptatem deleniti ut nesciunt.
Nemo sunt accusamus fuga omnis. Saepe ratione iure et repellendus et. Sunt eaque dignissimos iste et sint ea. Officia rerum vitae commodi ut non eum.
Libero debitis nobis maiores ut et eos quas. Adipisci ex eaque voluptas consequatur omnis impedit. Et ut rerum esse dolor. Tempore veritatis quasi voluptas quia. In voluptas sit autem dolor modi eveniet sapiente.
Qui dolores suscipit dolores voluptatem ipsa ea dolorem et. Sunt maiores est officiis tenetur et autem adipisci.
Vitae libero id earum magnam facilis sed. Dolore molestiae sequi sit ut. Accusantium repellendus dolore porro eveniet in quia. Amet quis tenetur sit atque occaecati aut. Molestiae exercitationem et laudantium voluptatem iure labore. Voluptatem perspiciatis maxime labore qui voluptas.
Eum temporibus dicta assumenda ullam ut. Qui quis ex occaecati dolores velit. Natus vitae facere neque omnis qui cumque eos ullam.
Velit vero explicabo ipsum rerum est sunt nesciunt. Laudantium totam aut doloribus sunt harum magni. Explicabo quia neque velit ea neque cupiditate omnis.