Favorite Excel Shortcut(s)?

Get Boost from WSP.

alt+e+s+v and shift+L

...-...

Take out F1 key paste special with math operations (eg. input the number "100" in a cell and Ctrl+C, and then paste special on a selection of numbers -> operation -> multiply, all the numbers selected are multiplied by 100) all the other paste specials (I just love paste specials including "transpose")

If you have the TTS macros then Ctrl+Shift+T is super helpful.

Alt + F4

Ctrl+Alt+Delete and enter

The link below will take you to a very basic modelling tutorial. You can get all 31 days at once if requested. Two of the lectures contain files full of short cuts, probably the most useful of which allows you to paste a link with row anchoring and copy across to the whole row. This alone more than doubles my modelling speed.

http://info.f1f9.com/31-day-financial-modelling-course

Full list of short cuts below.

https://www.google.co.uk/url?sa=t&source=web&rct=j&url=http://www.f1f9…

Second getting the Boost or TTS plugins if your bank doesn't already have a custom plugin. Macabacus works great also.

Ctrl + Insert -> Copy, Shift + Supr - > Cut,

Little Faster

alt + e + s + t

Really any of the paste special functions, but I like using the old 2003 shortcuts

Shortcuts suck, mouse is the way to go.

Some of my faveorites, in no particular order:

F12: Save as F7: Spell check Alt + E + S: Paste Special Alt + H + O + I: Auto fit column width Alt + =: Auto sum Ctrl + Shift + %: Percentage formatting Ctrl + 1: Formatting dialog Ctrl + G, then Alt + S: Go to special Alt + H +0/9: Move decimal places out/in

macabacus

If you have CapIQ, FactSet, Macabacus plugins, you can cycle through commonly used (or your own customized) number formats (dollar signs, percentages, decimals, multiples, etc). I found that to be a huge time saver when it came to formatting my models...that is of course until I had to do PE case interviews when I couldn't figure out how the hell change my leverage ratios into multiples...

Also, smart precedents / dependents is god send (also plug in). I don't even know how I'd go about auditing my excel sheets without it.

Alt+E+S = Paste special? I have it in Ctrl+Alt+V (english version) :S

My favorite: F4 = Repeat last action (e.g. instert row, paint cell in yellow, clear cell...)

Macabacus

Center cycle - makes center across selection super easy Underline cycle - makes single accounting underline super easy Cell color cycle Font color cycle Blue/black font cycle Disable F1 Add or subtract a "0" to change magnitude

Regular

Go to special Paste format Index/match

I think you're looking for hot keys/send key combos. My favorites below. Note mixed in "+" meaning held together versus sequentially entered, I'm sure you'll figure it out...

Open Formatting = Ctrl + 1 Space All Columns = Ctrl+A then Alt + H + O +I Filter = Alt + A + T Underline = Alt + H + B + O Color = Alt + F + C Size = Alt + F + S Move/Copy Sheet = Alt + H + O + M Open Task Manager When Excel Freezes = Ctrl + Shift + Esc Add a ° sign = Alt + 2 + 4 + 8

Hide Column/Row Alt + H + O + U + C/R Unhide Column/Row Alt + H + O + U + O/L Highlight Entire Column Ctrl + Space bar Highlight Entire Row Shift + Space bar Add/Delete Column/Row/Cell Ctrl + +/-

And every lazy man's favorite: Copy Everything Down Ctrl + D

My favorite: Ctrl + Alt + Left Arrow = Repeat last action (e.g. insert row, paint cell in yellow, clear cell...)

Alt H V V Alt + + Ctrl [

The only one I like that hasn't been mentioned:

Ctrl + \ = checks for inconsistencies among selected row.

Funny, I always thought I had just scraped the surface for excel shortcuts, but I actually use a ton of these on a daily basis...

Just saw this on chandoo for those of y'all who forget how to write index match formulas.

What it does is allows you to type iii which autocorrects to the reminder formula.

Copy the following line into AutoCorrect and then use iii as the text to replace

=INDEX( DblClk_to_Select_Column_to_return, MATCH( DblClk_Single_Lookup_Cell, DblClk_Lookup_Column, 0),0)

This way whenever you need INDEX MATCH you just type iii and AutoCorrect kicks in and you are 3 double clicks away from a robust formula.

AutoCorrect is found in the File, Options, Proofing Menu

I recently wrote a super short and easy macro that helps heaps with filling in empty cells in a tabular database, and now I use it all the time to get my datasets "database ready" to import into another database or a visualization software like Tableau.

It's basically to be used in cases where you export data and have, say, a single record of a county in Column A, but then 50 rows of data for that county in Column B, which leaves 49 empty rows below Column A until you get to the next county. Rather than manually filling in Column A a million times for each of the 100+ counties, the macro does it automatically (and it only runs once per keystroke shortcut so you have some degree of control over how HAM it goes on the dataset).

Here it is, I just saved it in a .txt file and paste it into a sheet whenever I need it:

Sub FillCells() ' ' ActiveCell.Select Selection.End(xlDown).Select Selection.Copy Range(Selection, Selection.End(xlDown).Offset(-1, 0)).Select ActiveSheet.Paste

End Sub

My favorite shortcut is skipping a "t" in "shortcut".

CTRL+[ then CTRL+G to go to last cell selected

Useful when checking crazy formulas that reference multiple cells

-XSX

Alt + E + S + T ----> Paste Formatting Alt + E + S + V ----> Paste as Values Alt + H + O + I ----> Auto-Fit Column Control + Y ----> Repeat Last Action Alt + H + B + .... ----> Edit Borders Alt + A + T ----> Toggle Filters Alt + H + H ----> Change Cell Color Alt + H + FS ---> Change Font Size Alt + W + F + F ---> Freeze Panes

Good amount that others have listed. A few more that are my faves: alt + d g g -> Group alt + d g u -> Ungroup (See how that last letter stands for group/ungroup??? insane) alt + hbs -> border all around (I remember this as harvard making you wellrounded. disclaimer: did not go to harvard) shift + space = select row control + space = select column when row/column is selected, alt + e d -> delete selection alt + ic -> insert column (you like that? there's more) alt + ir -> insert row (wow they're literally the first letters of their command)

All of the other formatting percentages, comma, dollar signs, blue font, green font etc. you can pick up by installing a formatting macro from either Training the Street or (my go to) a free one called Wall Street Training.

Just google WST macro. Download. In excel press alt + t i -> opens your macro plugins. Find the file you just downloaded and let magic occur. They should have instructions on which does what.

Lastly, not excel related but blew my mind first day. For word/powerpoint/outlook... select something you want the same format from -> control + shift + c (copies the format, including color, size, font, bullet layout, etc.) and then select text where you want that format to go -> control + shift + v (literally copy paste for formats).

Hope this helps. ;tldr cool stuffz

Windows + L -> beer

I have paste value, paste formula and paste format set as Alt+1, Alt+2 and Alt+3. Changed my life.

ALT, E, S, T.

NERDGASM

Favorite / most used has got to be CTRL + z

great post with similar info http://www.wallstreetoasis.com/blog/excel-stuff-to-learn-before-your-su…

Using macros with assigned hotkeys to change things to the right number format or reverse signs. Hngggh.

factset IFERROR wrap: ctrl + shift + E

love it

alt + hor change tab name alt + hot change tab color

Alt+ Enter after selecting a range to autofill with similar data. Haven't seen someone post this up yet.

Alt-F,X,O is pretty handy

Alt-blowjob

The highlight all constants one is pretty clever, didn't even know you could do that at all, but in general this thread is pretty sad. Not because people aren't offering useful shortcuts, plenty of good ones mentioned, but that this is what people spend their time doing at work

Rip out the F1 key so you can crank even faster in excel? Seriously? Can't risk wasting even a millisecond when you are pounding out spreadsheet after spreadsheet

Don't forget to take out the caps lock key and the insert key. Then the windows key, scroll lock key, and pause/break key. And finally all of the other keys until you're left with just a big fat spacebar

Some good shortcuts on here..

CTRL + [ to trace a formula back to its input (depending on the formula, doesn't always go where you want) F5 + Enter brings you back to your formula

And I changed the default quick keys a bit, so I can increase & decrease decimal with..

CTRL + 2 decrease decimal CTRL + 1 increase decimal

Up Up, Down Down, Left, Right, Left, Right, B, A, Enter.

Anytime you are typing in a formula that starts with Alt (such as the paste as values, paste as formula, etc.) you can start with "/".

Anytime I want to paste as values, I use "/ + E + S + V + Enter", which is a lot faster than pressing Alt in my opinion.

Ctrl + [

on a cell that looks to an input. takes you straight to the input/reference cell.

ALT + M + D - shows cells dependent on the cell you've selected ALT + M + P - shows cells precedent on the cell you've selected

Both are great at tracing and understanding how things are linking up

ALT + A + W + G - goal seek

Shift+F2

So many comments to add so little time.

1. I didn't even know the F1 key had any function, so I don't know what good tearing it out does.

2. My favorite shortcut is to have other people do it for me. Very effective and time saving technique for me.

ctrl + d to fill down

If you don't want to "rip out the F1 Key"

Copy: Application.OnKey "{F1}", ""

then F11 + and paste that in the text box and press enter. F1 will be disabled until you close the workbook.

Also for shortcuts, just use excel regularly and memorize Alt key shortcuts. Alt HIR, alt+ HIC, alt HBN, alt+ AT, alt+ HIS, alt+HOR, etc. etc. encompasses pretty much everything.

Not necessarily for Excel, but WINDOWS+LEFT/RIGHT/UP arrow to snap current window to screen edge. Haven't seen this for grouping: CTRL+ALT+RIGHT Arrow (/LEFT Arrow to ungroup).

Not really a shortcut but... Saving your workbook in the ".xlsb" format as opposed to ".xlsm" makes calculations faster, the file size smaller and overall the workbook becomes more efficient.

Also a couple of my favs...

alt a - v - v : to insert a data list (aka drop down menus) alt d - t : to make a data table (for SA analysis) [toggle] shift - F8 : it holds down the ctrl key for you while you select multiple cells [toggle] F8 : it holds down the shift key for you while your select another cell

Alt F D P A

Alt F + U + C + K

Also, to fill in surrounding cells (instead of CNTRL+R, then CNTRL+D, enter one hardcode in the top left, highlight the region, F2 then CNTRL+Enter.

If you have Factset, CNTRL+ALT+"," to copy cell formula references and formatting and CNTRL+ALT+"." to paste them is AMAZING.

Personally, IMO the fastest shortcuts are the ones that you create on your ribbon by recording macros, e.g., standard formatting for headers (fill, bold, center, etc.), Borders, Sorting data, center across selection. Instead of taking several steps to do these things, record the macro, and make it an ALT+1, ALT+2, etc. This saves hours of work for formatting.

Ctrl - Shift - [ to smart trace precedents Alt - E will take you to the precedent and allow you to change the reference

Ctrl-Alt-Right Arrow