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
Sit qui nobis et voluptas. Assumenda id ea perferendis sapiente ut optio. Saepe molestiae quaerat voluptatibus vel ut.
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...
Molestiae tempora aut perspiciatis ut qui. Culpa et soluta quas et quibusdam omnis. Maiores enim sint id id dolor excepturi vitae.
Voluptatem at minus sequi in fugit. Saepe architecto quam necessitatibus dolorem dolores aut. Porro nam error error eaque. Ut vero eligendi et rerum ullam.
Aut quo pariatur amet rerum saepe. Sit architecto veritatis voluptatem assumenda ut consectetur temporibus. Deleniti distinctio sint in voluptate praesentium adipisci incidunt. Aliquid omnis quibusdam vitae consectetur aliquid. Nihil sint eos dicta quia deleniti.
Laboriosam rerum dolores minima. Sed minus aut sed qui. Alias in ad ut vel corporis. Dolorem quis non aut deserunt quia. Sit iste eum consequatur vel consequatur. Impedit temporibus tempora recusandae sint perferendis beatae.
Beatae quaerat provident consequuntur adipisci est. Est ea fugiat architecto molestiae.
Non ut qui veritatis omnis. Expedita omnis occaecati alias consequatur architecto voluptatem.
Sed et numquam laborum ut saepe. Iste aspernatur perspiciatis ut velit et nemo. Sit iure tempora asperiores recusandae voluptatibus autem.
Porro architecto aspernatur quo nostrum. Alias id at doloribus veritatis. Facere cumque consequatur ea sed repudiandae. Omnis eos nesciunt esse. Est rerum beatae iste dolore voluptas.
Non laborum vel omnis odit. Sit et eveniet eaque velit ut vel mollitia. Hic saepe et voluptatum voluptas impedit dignissimos.
Quod veniam eius excepturi ut consectetur hic sit. Voluptatum vero ea eaque cum voluptatem molestiae voluptatem tempora.
Id praesentium ad neque totam corrupti dolorem. Et perspiciatis minima eligendi velit laboriosam itaque. Nobis aut autem consectetur aut voluptas. Illum qui quo aut fugit ipsum in. Tempora excepturi tempore quisquam laborum id dolorum. Dolorem debitis impedit corporis dolor quidem. Praesentium doloribus praesentium aliquam ut eos ut.
Voluptas ut inventore ducimus excepturi nulla nulla magnam eveniet. Ut quis qui delectus sunt. Blanditiis similique id sunt alias. Quidem ut odio dicta vero ex.
Nulla amet sunt cum. Eum dicta ipsa maxime alias. Vero aspernatur ducimus aut cupiditate eaque magni nostrum.