Common Hotkeys - What do you use?

CRE SC's picture
Rank: Orangutan | 328

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?

Comments (73)

Oct 24, 2016

F2

Oct 24, 2016

alt+h+v+s+f (enter) for formula paste
f9 as I put my spreadsheets in manual calc
shift+control + arrow
control + arrow

Oct 24, 2016

Shorter version: alt e+s+f

Oct 25, 2016

Too used to other way, feels right

Oct 25, 2016

ctrl+alt+v, d-pad down 1, enter.

Three total key strokes.

Learn More

Side-by-side comparison of top modeling training courses + exclusive discount through WSO here.

Oct 27, 2016

alt + HVF is easier though

Oct 24, 2016

Big fan of the macabus lite suite of macros.

    • 2
Oct 24, 2016

Just looked this up and it looks amazing. Going to get some of the guys in the office to download tomorrow.

Oct 24, 2016

Alt + F4 (watching Netflix and/or porn at work)

    • 11
Oct 24, 2016

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(#,#,#)

Oct 25, 2016
    • 7
Oct 25, 2016

A small part of me wanted this to be real.

    • 1
Best Response
Oct 25, 2016

5318008 on a calculator turned upside down

    • 18
    • 1
Oct 25, 2016

Haha. That brings back great memories from middle school.

    • 1
Oct 26, 2016

I hope this is your pitch for getting new clients.

...

Oct 25, 2016

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.

    • 2
    • 1
Oct 25, 2016

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).

    • 1
Oct 25, 2016

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.

    • 2
Oct 25, 2016

ALT E, S ,T

Oct 25, 2016

WST excel plugin helps

Oct 25, 2016

ALT = (auto sum)

Oct 25, 2016

Alt + F4. Leave for the day.

    • 2
Oct 25, 2016

Training the Street (TTS) has a solid and free plugin for modeling as well

    • 1
Oct 25, 2016

Yeah that's what I use too. Works great.

Oct 31, 2016

This macro crashes for me so regularly

Oct 25, 2016

F1

    • 2
Oct 25, 2016

Macabacus add-in.

Oct 25, 2016

Who's ALT - Tab game is strong?

Oct 31, 2016

This.

Oct 25, 2016

F5, Alt-S, O, X, Enter. Highlights all hardcoded numbers.

Oct 25, 2016

ALT + O + C + A
Autofits columns. I don't know why but it's really satisfying.

Oct 25, 2016

What's the difference from OCA and HOI?

//Signed//
MLang

Oct 26, 2016
Oct 25, 2016

Alt f x n

    • 1
    • 1
Oct 25, 2016

I can't attach any documents but @CRE SC if you PM me I'll send you my shortcuts list I have for Excel.

Oct 25, 2016

windows L

Oct 27, 2016

Surprised at how few people actually use this.

//Signed//
MLang

Oct 25, 2016

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).

    • 9
    • 1
Oct 31, 2016

This is how I imagine VC's talking in real life. I swear this is a quote from Silicon Valley:

"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"

    • 1
Nov 9, 2016

lol - but no - too many VCs don't use excel

Oct 25, 2016

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)

    • 1
Oct 25, 2016

Alt+f+c+n

very cool developer tool in excel

    • 4
Oct 25, 2016

Nice try

Oct 25, 2016

LOL. Dick.

Oct 25, 2016

This almost got me earlier today. Good thing I did it slowly and saw where it was going.

Oct 25, 2016

Quickly get rid of those annoying green error markers: alt+m+k+k+i (hold).

Oct 25, 2016

Don't forget the most important one.

d-pad(up, up, down, down, left, right, left, right) b, a

Oct 26, 2016

down right X = hadouken

oldie but a goodie

Oct 26, 2016

I have to admit to my shame I was a button masher

Nov 1, 2016

C-up, left c-down, c-down, left, down, right, up, left, down, right, up

Oct 25, 2016

Ctrl + R and Ctrl + D for autofill

Oct 25, 2016

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

Oct 26, 2016

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.

Oct 31, 2016

cntrl+space and alt+o+c+a

Oct 31, 2016

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

Nov 1, 2016

Did you just literally end this sub?

Nov 5, 2016

Ha...

Oct 31, 2016

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.

    • 1
Nov 1, 2016

Alt + H + V + S + L

Paste link to copied cell.

Nov 1, 2016

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

Nov 1, 2016

ctrl + T // p-o-r-n-h-u-b-.-c-o-m + [ENTER]

    • 1
Nov 5, 2016

Getting a pen and ripping your F1 key the hell outta your keyboard

Nov 5, 2016

Ctrl + C and Alt + E + S will be your best friends

Nov 12, 2016

Flag->L

Nov 12, 2016

ctrl+s for save...?

My drinkin' problem left today, she packed up all her bags and walked away.

Nov 12, 2016

bump - I press ctrl + O to open the file explorer but then have to resort to the mouse...any way around this?

Nov 12, 2016

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

Nov 12, 2016
Comment
Nov 12, 2016
Comment
Nov 12, 2016
Nov 12, 2016
Comment