Pages
Already tried googling. So I know there's a shortcut to anchor a part of cell using F4 when you're in your formula bar.
But, if I want to put brackets around some parts in my formula bar, is there a shortcut?
E.g.
I'm trying to type =(A5+B3)*5
I have =A5+B3 typed in the formula bar, is there any button or built in short cut to put brackets around all the contents? Or any related features?
Comments (245)
No default Excel short cut for that
Want to Vote on this Content?! No WSO Credits?
Already a member?
7,548 questions across 469 investment banks. The WSO Investment Banking Interview Prep Course has everything you'll ever need to start your career on Wall Street. Technical, Behavioral and Networking Courses + 2 Bonus Modules. Learn more.
Alt+F4
Want to Vote on this Content?! No WSO Credits?
Already a member?
Want to Vote on this Content?! No WSO Credits?
Already a member?
Alt + W + H
Want to Vote on this Content?! No WSO Credits?
Already a member?
Alt + F + C + N
Want to Vote on this Content?! No WSO Credits?
Already a member?
I wrote a macro for you. Just add this into the VBA editor. Alt + f11 will open the editor. Then click "insert" then "new module"
Then paste this code:
Sub addbrackets()
Dim x As Integer
Dim strFormula As String
ActiveCell.Copy
ActiveCell.Select
strFormula = Selection.FormulaR1C1
x = Len(strFormula)
y = Left(strFormula, x - (x - 1))
Z = Right(strFormula, x - 1)
Selection.FormulaR1C1 = y + "(" + Z + ")"
Application.CutCopyMode = False
End Sub
I've tested it and it works.
"Look, you're my best friend, so don't take this the wrong way. In twenty years, if you're still livin' here, comin' over to my house to watch the Patriots games, still workin' construction, I'll fuckin' kill you. That's not a threat, that's a fact.
Want to Vote on this Content?! No WSO Credits?
Already a member?
Keyboard Shortcuts - I'm a huge nerd (Originally Posted: 09/21/2006)
I think we need a dedicated thread for huge ibanking nerds like myself who are always on the lookout for new and better keyboard shortcuts.
Some have been posted in node 881 (link below) and I will consolidate those shortcuts into this thread. I
Want to Vote on this Content?! No WSO Credits?
Already a member?
nothing wrong with the mouse, you only save like 2 seconds by doing the short cuts. But good list anyway :)
Want to Vote on this Content?! No WSO Credits?
Already a member?
Do you have any idea what you are talking about? I hope you say that in an interview.
Want to Vote on this Content?! No WSO Credits?
Already a member?
Good job man. Very impressive and helpful. Although I must admit that for an analyst, you must have a lot of time to do this.
Want to Vote on this Content?! No WSO Credits?
Already a member?
3 months away from VP. I'm between projects and waiting for a client's go-ahead. Having a blast reading these boards though. The scars from my analyst years are still fresh enough to remember. A banker has to keep his skills fresh! How can I ask for something if I couldn't do it myself?
Want to Vote on this Content?! No WSO Credits?
Already a member?
I sympathize tremendously with someone who is totally intolerant of being bored.
This seems like a clear act of desperation in trying to avoid being bored. I salute you, sir.
Want to Vote on this Content?! No WSO Credits?
Already a member?
Id say they save you 2 seconds per action while making a model...shortcuts save a considerable amount of time. And dont forget alll the alt + letters combinations in excel. Its just quick menu use, not exactly shortcuts, but they are incredibly time saving
Want to Vote on this Content?! No WSO Credits?
Already a member?
Shift-Space is select row.
Ctrl-Space is select column.
Works well in conjunction with Ctrl-9 and -0, which I didn't know about, instead using the second windows key, AKA "action key" and "h". But on a ThinkPad there is no action key so that is useful.
Shift-Ctrl + 1-0 will do instant formating.
1 is number with two decimals; 4 is currency format, 5 is percent format, etc... Play around with them.
Ctrl-y can be used to repeat the action again and again. Very useful, especially when working with tables in word. A tip for word this reminds me of is to never delete colums in a table. Erase the contents and merge the column, line by line, with the adjoining column. This will allow you to maintain formating better.
Being able to navigate excel with the keyboard only saves a lot of time.
Account Inactive
Want to Vote on this Content?! No WSO Credits?
Already a member?
I've got a couple that for some reason people don't seem to know:
Ctrl + Shift + - (minus): remove all borders in selection.
^ This one saves me a considerable amount of time
Ctrl + Shift + 7: Apply border around selection.
Alt + ; : Define Styles dialog
Ctrl + ; : Insert current date
Ctrl + 1 : Format cells dialog (duh, the most used)
Want to Vote on this Content?! No WSO Credits?
Already a member?
All the Ctrl-Shifts are massive time savers.
Account Inactive
Want to Vote on this Content?! No WSO Credits?
Already a member?
Yeah. In training, we did all our work with the mouse turned over so we couldn't use it. The mouse is definitely not a tool you want to admit to relying on in this business. Those two seconds start to rack up when you're doing something hundreds of times.
Want to Vote on this Content?! No WSO Credits?
Already a member?
I sometimes use the mouse if I'm particularly bored with a task to mix it up a bit but I inevitably get annoyed and go back to the keyboard. Most of the shortcuts I know about I've found out by accident...tough to remember a long list of them from day one.
I remember in my first week being taken through the comp template by a senior analyst and him telling me "you need to play that keyboard like a piano" which at the time I thought was amusing/ sad. I totally get it now though.
Want to Vote on this Content?! No WSO Credits?
Already a member?
is there a hot key for the paint brush, what about outlining cells?
Want to Vote on this Content?! No WSO Credits?
Already a member?
Don't know of a hot-key for the paintbrush, although you can Alt, then Ctrl-Tab your way through any item in the toolbar. Besides, if by the paintbrush you mean the format painter, why not just copy and Alt-e-s-t?
Ctrl + Shift + 7 inserts a border outline for the selected group of cells.
Want to Vote on this Content?! No WSO Credits?
Already a member?
Is there a shortcut to tab between frames on a webpage?
Want to Vote on this Content?! No WSO Credits?
Already a member?
'ctrl'+'tab' to switch between tabs on firefox
Want to Vote on this Content?! No WSO Credits?
Already a member?
good call
Want to Vote on this Content?! No WSO Credits?
Already a member?
,but I still think that shortcuts are a bit hyped up.
I don't really think they save that much time. (being worth 2 seconds of efficiency each) I could save more time per day by going on one less 2 minute restroom break.
Want to Vote on this Content?! No WSO Credits?
Already a member?
you save a lot more time than that with keyboard shortcuts.
all the alt e-s's will save you a lot of time.
the key is having both hands on the keyboard at all times--very efficient.
Want to Vote on this Content?! No WSO Credits?
Already a member?
Alt+shift left/right arrow to group/ungroup rows or columns
Want to Vote on this Content?! No WSO Credits?
Already a member?
Anyone that says shortcuts don't save time doesn't know them.
Force yourself to use them for a week and thank us later.
Either you sling crack rock or you got a wicked jump shot
Want to Vote on this Content?! No WSO Credits?
Already a member?
Excel:
I don't like Ctrl 0 and 9 - better to use Alt D G G and Alt D G H to hide rows so that you can get them back when wanted, easily.
To fill things quickly and change font colors quickly, move those two buttons into your first row of action keys, near the beginning. If you hit Alt and release (highlights the menus) then hit Ctrl+tab, it'll drop you down to the tool bars.
For powerpoint:
Alt R A T (or R A L, R A R, R A B) to align objects to top, left, right, bottom respectively
Alt E O O open embedded object
Alt V C G to set grayscale mode so you can fix those little boxes in the bottom corner hiding your logo.
Alt V I I to get some drawing guidelines (not gridlines, lines you can physically move yourself)
For all you haters, live a few days in the analyst's cube and you'll thank your lucky stars for shortcuts.
Want to Vote on this Content?! No WSO Credits?
Already a member?
nice. very nice.
Want to Vote on this Content?! No WSO Credits?
Already a member?
Incoming analyst season I see...
Want to Vote on this Content?! No WSO Credits?
Already a member?
Does anyone know where the thread can be reached which had the list? I accessed it a few weeks back but do not see it in the thread anymore.
Thanks
Want to Vote on this Content?! No WSO Credits?
Already a member?
I suppose this shows that I am an even bigger nerd; I saved the list.
F4 in explorer = drop down url box
Windows + D; Windows + M = desktop
Alt + Tab = change applications
F5 = refresh
shift + F5 clears the cache in case explorer gives you an old version of the page
Window-E = launch windows explorer
General
Control + Esc = open start button in windows
Good general recommendation = pry out your F1 key and just leave the void. Your IT people will freak out, but keep it nearby to show them you still have it. This avoids bringing up the aEUoeHelpaEU in a given application when you fat finger the F2 key.
F12 is Save As in most applications
Control + Print Scrn = takes a picture of the screen aEU" good when something canaEU(tm)t be copied from the internet aEU" just paste it into powerpoint or word and crop it.
In most applications:
Control + C = Copy
Control + X = Cut
Control + V = Paste
Control + S = Save
Control + P = Print
Control + O = Open file
Control + Z = Undo
Control + Y = Redo
Alt + underlined letter + underlined letter etc. navigates you through the drop-down menus.
In Excel:
F2 to audit a cell aEU" highlights precedents in color
Control + ] = go to dependants
Control + [ = go to precedents (these are my favorites - auditing functions)
Control + N = New spreadsheet
Control + 1 = Format Cells
Control + page up/page down = navigates through Tabs aEU" Shift at the same time highlights them. Be very wary of highlighting multiple tabs and making changes as the changes are made in all highlighted cells.
F4 = perform previous function (also a key function)
Control + 2 or Control + B = Bold
Control + 3 or Control + I = Italics
Control + 4 or Control + U = Underline
Control + 9 = Hide rows
Control + 0 (zero) = Hide Columns
Lock rows and columns in a formula using F4
F5 = Go to (either type a cell reference or it should have a list of aEUoenamedaEU cells)
Type words into Name Box to create an absolute reference to that cell (as in name a box Interest_Rate will always reference that cell throughout the model aEU" very useful)
Alt + Enter to do a aEUoesoft returnaEU in excel aEU" same cell but on a separate line
Alt + the = sign = sum the above numbers
Control + ~ = show all formulas (this can be scary if hit accidentally aEU" just do Control ~ again to undo this)
Control + Curser = goes to last input in a series of inputs
Shift + Control + curser = highlight an area (typically to format a series of numbers)
Control + F = Find aEU" great if you have word references
Control + A = Select all (good for globally changing font etc.)
In Powerpoint
Control + G = Gridlines
Highlighting an object while holding the Control key moves the item on either a vertical or horizontal plane; holding the shift key copies the object and (when the control tab is held) moves it on a horizontal or vertical plane
F5 goes to slideshow mode
Want to Vote on this Content?! No WSO Credits?
Already a member?
Mad comprehensive list yo. Hahaha. Good one.
Want to Vote on this Content?! No WSO Credits?
Already a member?
All keystroke combinations for all programs on all operating systems... link is for Excel 2003, but feel free to browse around http://keyxl.com/aaab2f6/9/Microsoft-Excel-spreadsheet-keyboard-shortcuts.htm
--
Support WSO.com and visit these links!
Financial Modeling Training
Guide to Finance Interviews
Want to Vote on this Content?! No WSO Credits?
Already a member?
Thanks...Much appreciated
Want to Vote on this Content?! No WSO Credits?
Already a member?
Have any of you made the transition to '07? Comments?
Want to Vote on this Content?! No WSO Credits?
Already a member?
F4 is quicker than CTRL+y in Excel
Want to Vote on this Content?! No WSO Credits?
Already a member?
Anyone know how to move from a cell to the fx bar to edit something?
Thanks!
Want to Vote on this Content?! No WSO Credits?
Already a member?
F2?
Want to Vote on this Content?! No WSO Credits?
Already a member?
thanks for the Alt + "=" . it is really helpful. i used to rather write the formula on the keyboard than having to click the sigma sign with the mouse.
and you need the keyboard shortcuts, not for the 2 seconds,but it is just that using the mouse becomes really irritating and annoying, anyone who works a lot with excel should know that. sometimes you do stuff that take a few more seconds with the keyboard just not to use the mouse, and having to lift your hand, take it off the keyboard and click the mouse, then putting your hand back to the keyboard. it is just annoying.
btw, i am not doing an internship in IB but somewhere else. i hope i get one next summer.
Want to Vote on this Content?! No WSO Credits?
Already a member?
i find the key on many keyboards next to the control key that looks like a mouse pointer.... which is used as a function key can be very handy in excel. they are the same shortcuts that you can get to with other shortcuts but often cuts down one key.
i.e.) paste special
(alt e s)
or
(special s)
yeah its just one key but might help.
Want to Vote on this Content?! No WSO Credits?
Already a member?
I always hit F1 instead of F2 and was about to DDT my monitor one night when I found out Ctrl+F1 takes away the help menu....
Want to Vote on this Content?! No WSO Credits?
Already a member?
rip the F1 key off your keyboard.... but wait until you are pissed off because it feels really good to do it.
Want to Vote on this Content?! No WSO Credits?
Already a member?
I like that idea...makes you feel like you really did some damage
Want to Vote on this Content?! No WSO Credits?
Already a member?
F9 - Update
:)
F9 - Update
F9 - Update
F9 - Update
F9 - Update!!!!!!!
Want to Vote on this Content?! No WSO Credits?
Already a member?
sick post
Want to Vote on this Content?! No WSO Credits?
Already a member?
To all you newbies out there, Take note. There is a reason this thread is the 2nd most forwarded thread on WSO.
Shortcuts can make your life 100x easier as an analyst. And you save MUCH more than 2 minutes per day.
Ace PE Interviews
HF Interview Course
Want to Vote on this Content?! No WSO Credits?
Already a member?
Crtl + Page Up/Page Down = Move between tabs in an Excel Workbook
Want to Vote on this Content?! No WSO Credits?
Already a member?
You can access these free and other xls mumbo-jumbo here:
http://www.WallStreetPrep.com/community/excel_resources.php
Want to Vote on this Content?! No WSO Credits?
Already a member?
This is a good custom excel shortcuts add-in:
http://simpleshortcuts.net
Want to Vote on this Content?! No WSO Credits?
Already a member?
Does anyone know a short-cut to auto adjust the column width or row height to fit the text in those cells? (equivalent of double clicking ie. in between the A and B column labels at the top)
Want to Vote on this Content?! No WSO Credits?
Already a member?
^^
Consultant in the house, biatches.
Control - Space, Alt - O, C, A
or
Shirt - Space, Alt - O, R, A
P.S. Some use of the mouse is actually quicker (i.e. selecting a background color in the formatting dialog box--do you really want to hit the arrow that many times?)
P.P.S. Thanks for reminding me about Alt - = and Control - ] and Control - [.
Want to Vote on this Content?! No WSO Credits?
Already a member?
P.P.P.S. My favorite formating command of all time, center across selection, is Control - 1, H, Tab, C, C, Enter, Enter
Merging cells is for noobs.
Want to Vote on this Content?! No WSO Credits?
Already a member?
It's A, not H - but I'm sure most idiots could figure that out.
Want to Vote on this Content?! No WSO Credits?
Already a member?
good stuff. Thanks
Want to Vote on this Content?! No WSO Credits?
Already a member?
I'm really suprised no one has mentioned the following (which has made my life so, so much easier):
To truly unlock the power of Excel - create your own shortcuts. To assign a shortcut key to any of the toolbar buttons, do the following.
As you might have discerned, the possibilities with this feature are endless. I've created shortcuts for cell justification, adding the "," for thousands, indenting. These shortcuts esstially eliminate the need to alt > release > ctrl + tab your way to these buttons.
When you're in customize mode (step #2 and #3 above) you can also move all the toolbar buttons into a more favorable position to (if you must) make your alt > release > ctrl + tabbing a little faster (e.g. move your border button or your text style and size all the way to the left)
My favorite shortcut of all:
In the customize dialogue box (step #2 above), go to the "Commands" menu tab and find the Font Color and Fill Color buttons (in the Format category). Drag these two items, into the Format menu at the very top of Excel and place them where you please in the menu (towards the top). Then go to this format menu (where you just dragged the button) and right click on it - this will drop down a similar menu as above (step #5) where you can make the same changes as you did in the decimal place example above (e.g. make sure the Name box is set to "&Font Color" - note, whichever letter the "&" preceeds will be your shortcut key). Then do the same thing to the Fill color button, setting the Name box to: "Font C&olor".
Now monkeys you can alt + o + f and alt + o + o your way to font and cell coloring bliss. Might take a bit to get used to, but now I find that if i'm using a computer that doesn't have these keys programmed, I go insane.
you're welcome
Want to Vote on this Content?! No WSO Credits?
Already a member?
Wow so amazing, i just showed a couple other analysts in my office lol.
But I couldnt get the "image and text" to show for fillcolor and fontcolor. Is this something just available for excel2007??
Want to Vote on this Content?! No WSO Credits?
Already a member?
Is the functionality Canadian mentioned in his post for assigning special hotkeys available in 2007? If so would someone please walk me through how to use it? So far all I have been able to do is customize toolbar, which brings up a big dialog box (cannot right click on background images at this point as mentioned in the post), but you can still find the command, click "add", which puts it in the "quick access" toolbar, and "alt + #" (0-10, in the order added) is the given hotkey. I cannot figure out how to change the standard numerical 0 - 10 hotkey assignment to a linking of my choice.
Also if anyone has that TTS turbo macro everyone keeps mentioning i'd really appreciate the hookup.
Want to Vote on this Content?! No WSO Credits?
Already a member?
no, this should work for 2003, it works for me
i should have specified..
you dont have to check off Image and Text for any of the shortcuts in the menus (font and cell color in this case). Just make sure the "Name" box shows:
for Font Color -> "&Font Color"
for Fill Color -> "Fill C&olor"
This shortcut now functions like any other menu short cuts (like alt + e + s, for example) as opposed to the toolbar shortcuts that i outlined. So for example, for Font Color hit alt + o + f and then use your cursor key to find the desired color then hit enter. go have a ball.
Want to Vote on this Content?! No WSO Credits?
Already a member?
oh cool, thanks!
Its funny to say but finding out some of these tricks is so F'ing exciting
Want to Vote on this Content?! No WSO Credits?
Already a member?
Shortcuts DO save you time, and makes life just a lost easier.
Also, knowing shortcuts makes you seem like a better analyst even if you aren't any smarter, another way to differentiate yourself in a sea of homogeneity.
So yeah, learn shortcuts.
People saying that its not worth it: you guys will eventually unwillingly pick these up and utilize them, whether you want to or not, and you'll see firsthand once you actually hit the job that they are incredibly useful.
See my WSO Blog, See my AMA
Want to Vote on this Content?! No WSO Credits?
Already a member?
canadian: is there an easy way to save your preferences in excel to a jump drive and transfer them? I've set up some customized shortcuts on my home computer and now would like to transfer these to my work computer (rather than re-establish all of the customized shortcuts)?
The same question applies for outlook preferences, calendars, contacts, etc.
Want to Vote on this Content?! No WSO Credits?
Already a member?
All of these are great. For those of you who have the TTS Turbo macro, learn to use it (the font color
toggle, number format toggle, and the decimal toggle are my favorite features, among others). For those of you who do NOT have their macro, find somebody who does and get it from them.
A few other shortcuts that haven't yet been mentioned (at least I didn't see them after briefly glancing through the thread...apologies if these are repeats), all for versions that are NOT 2007, which I'm convinced was sent to torture bankers:
Windows key + E opens explorer, allowing you to quickly access files by typing in the letter of each step in the file path and navigating with the arrows. Once you arrive at the folder, Cntrl + Tab to go over the the window to hit enter on the file you'd like to open. Try it and you'll see what i mean.
Alt + D goes to the address bar in internet explorer.
Alt + G goes to the Google toolbar if you have it installed
Alt + F, W, Enter to start a new folder (dunno if that's also the case in Vista)
Alt + F4 closes applications
Cntrl + F4 closes files
Cntrl + tab to switch through different open Excel workbooks
Alt, F, U for page setup in excel. Then hit S, Alt+R to set rows to repeat at top. Helpful for printing massive financial statements and keep the dates at the top
Alt, W, F to freeze panes. Same key combo unfreezes them.
Shift + F2 inserts a comment. Alt, E, A, M clears comments. Use go to special to highlight all comments and then delete 'em in one whack.
F5 is go to in Excel. Learn this. Learn to name cells (Cntrl+F3) and use that in conjunction F5 for quick navigation through really monster models.
F5, S is go to special, which opens up whole worlds. Learn to hit F5, Alt + S, O, X to highlight all hardcoded numbers (careful, doesn't count intracell sums). F5, Alt + S, W for row differences: useful for auditing models (highlight the block of links and if one of your contiguous links references a different row than its neighbors, it'll highlight it...really best for big monthly models)
Cntrl + [ to go to the first precedent in a cell. Then hit F5, Enter to go back to where you came. This is HUGE when it comes to auditing models and checking links on disparate tabs.
Alt, T, U, D traces dependents (useful in flat sheet models). Alt, T, U, T traces precedents
Alt, O, D brings up conditional formatting. Nice for highlighting credit stats when doing lbo models. If you blow a prospective covenant, it'll highlight it automatically. You can set covenants in a box in Excel and link the covenants to the conditional formatter. Don't hardcode it into the formatter, you'll eventually make a mistake.
=PROPER is a great function for cleaning buyer or contact lists. Reference the crappy text, and it'll capitalize the first letter of every word.
Learn to use Find and Replace (Cntrl + F, Alt + P, Alt + E) to make big sweeping changes to clean data or sometimes even do some mass formula changes.
Another data cleaning tip: Learn to use text to columns (Alt, D, E) to scrub shitty imported data from clients' equally shittily-maintained accounting systems.
Learn to paste special link (Copy, then Alt, E, S, Alt+L) to quickly link things
Okay that's enough for now, I'm just tired of writing. Suffice to say, there are lots and lots more where those came from. If you really want to learn shortcuts, make yourself learn all the toolbars so you can use hotkey combos instead of clicking around up there. Also get an Excel book and use that to find obscure formulas that can sometimes be useful. Taking a class with TTS or some other firm also helps. Most of these places have a list of commonly used shortcuts you can put up in your cube (hugely helpful), but I imagine many such sheets can be found online. Ask senior analysts and senior associates how to do things. Above all, be disciplined and make yourself learn them, and try and find more efficient ways to do things that you find cumbersome.
Good luck and happy modeling!
<><><><><><><><><><><><><><>
Once more into the breach, dear friends.
Want to Vote on this Content?! No WSO Credits?
Already a member?
has anyone heard any rumors about banks making a switch to 2007? I wonder what kind of impact that would have on the productivity of analysts. Obviously a lot of the shortcuts, etc. are the same, but there may be a period of a few weeks where people are getting up to speed.
Any thoughts?
Want to Vote on this Content?! No WSO Credits?
Already a member?
can somebody post the origina thread that he was talking about? Because i didnt see the link
thanks
Want to Vote on this Content?! No WSO Credits?
Already a member?
oops.
Want to Vote on this Content?! No WSO Credits?
Already a member?
haha fantastic thread.
pop quiz for all you self proclaimed excel gurus.
How do you COPY AND PASTE formulas, but RETAIN the exact linking (ie, there is no relative movement of the source cells)?
And im talking like at least 50 cells of complex formulas (so don't tell me SELECT A SINGLE CELL, hit f2, SHIFT HOME, CTRL C, and paste).
Want to Vote on this Content?! No WSO Credits?
Already a member?
ctrl + alt + F9
Want to Vote on this Content?! No WSO Credits?
Already a member?
Anyone know a decent way to use shortcuts in Internet Explorer or Outlook? Pretty much the only time I need a mouse is clicking on links or opening attachments in emails.
Want to Vote on this Content?! No WSO Credits?
Already a member?
ctrl `
Want to Vote on this Content?! No WSO Credits?
Already a member?
bump
Want to Vote on this Content?! No WSO Credits?
Already a member?
bump
Want to Vote on this Content?! No WSO Credits?
Already a member?
You use it all the time to audit models, and the more complex the model, the more it helps to use this shortcut.
Want to Vote on this Content?! No WSO Credits?
Already a member?
Thanks for the shortcuts. A lot o them are pretty useful.
Want to Vote on this Content?! No WSO Credits?
Already a member?
I found this two page PDF titled "Commonly Used Excel Shortcuts for Excel 2007". I think it might be given out by Goldman Sachs to its summer analysts. I couldn't copy and paste it below because of its PDF format but you can find it at this link. http://gottamentor.com/viewDocument.aspx?d=857
Want to Vote on this Content?! No WSO Credits?
Already a member?
That document was made by Training the Street, hence the title: "Excel Shortcuts by Training the Street". It's handed to out to all participants in the Training the Street training program -- my bank included.
--
Support WSO.com and visit these links!
Financial Modeling Training
Guide to Finance Interviews
Want to Vote on this Content?! No WSO Credits?
Already a member?
I was wondering if anyone had a sheet of paper with all of the toolbar/menu shortcuts from excel 2003 (ex/ paste special--> ALT,e,s).
I had them all of in a document that a friend printed out for me, but I can't find. It was a bit more comprehensive then the Training the Street version.
Want to Vote on this Content?! No WSO Credits?
Already a member?
If you'd read the entire thread... http://keyxl.com/aaab2f6/9/Microsoft-Excel-spreadsheet-keyboard-shortcuts.htm
--
Support WSO.com and visit these links!
Financial Modeling Training
Guide to Finance Interviews
Want to Vote on this Content?! No WSO Credits?
Already a member?
I suspect your background is computer science application. Because you know those guys like my friends have passion in new OS and Type commands.
Their desktop is always black and small charaters are bliking.
Lask year I'm still using Linux-Fedora, Later my OS corrupt and I quit it.
Maybe you will be on a way headed to GEEK
Want to Vote on this Content?! No WSO Credits?
Already a member?
Definitely i'm also fond of using keyboard shortcut in daily job, 'cause it can ease my nerve instead of cliking the damn mouse and improve the sentivity.
Anyway, i'm usually using 80% of your posted.
Thanks man~
Want to Vote on this Content?! No WSO Credits?
Already a member?
I don't know if this has been posted already, but when entering in formulas, you can use the "+" key on the number pad instead of the "=" key to start of your formula.
Personally, I've found it annoying having to look down to find the "=" key. Huge discovery, imo.
Want to Vote on this Content?! No WSO Credits?
Already a member?
The + key is the = key.
Want to Vote on this Content?! No WSO Credits?
Already a member?
nevermind, I didn't realize you meant the big plus key.
Want to Vote on this Content?! No WSO Credits?
Already a member?
Is there a shortcut to highlight a cell or a series of selected cells?
Want to Vote on this Content?! No WSO Credits?
Already a member?
To highlight cells you just hold down shift and use the arrow keys to select the cells you want.
Want to Vote on this Content?! No WSO Credits?
Already a member?
If you're trying to highlight contiguous cells, just select the cells and hit Shift + F8.
Want to Vote on this Content?! No WSO Credits?
Already a member?
I should have been more clear. Is there a shortcut to highlight/fill the contents of a cell (yellow, green, etc..)?
When you select a cell and press Ctrl+b the contents are bolded. Is there a similar keyboard shortcut to fill in the cell with color?
Want to Vote on this Content?! No WSO Credits?
Already a member?
There isn't a shortcut for that, but what I've done is moved the font color dropdown and the cell color drop down to the top left of the screen. If you're in Excel 2003, you just hold down Alt, click on the icon, then move it wherever you want. I moved mine just to the left of where it says "File". That way, if I want to change the color of a cell, I just hit "Alt" and I'm right there. Then you just use the arrow keys to choose the color.
I've actually rearranged my entire menu bar to only show what I use.
Want to Vote on this Content?! No WSO Credits?
Already a member?
.
Want to Vote on this Content?! No WSO Credits?
Already a member?
thanks a lot these tips should be quite helpful...I'm currently a junior interviewing for SA positions.
Want to Vote on this Content?! No WSO Credits?
Already a member?
im not sure if anyone mentioned it but Alt + W + S splits up the screen in Excel.
Very useful when linking cells in the model
Want to Vote on this Content?! No WSO Credits?
Already a member?
Let's say you're updating an excel chart in powerpoint. What is the series of shortcuts that allows you to paste in the updated excel chart into the page so that it has the same sizing as the chart its replacing (so that you don't have to stretch horizontally or vertically to get the size to match)??
Want to Vote on this Content?! No WSO Credits?
Already a member?
I realize a lot of people are hating on 07... but when I press alt, it shows a letter/# in front of every menu option making it easy to just hit the letter - this even works great for coloring. I shift + arrow the columns I need to color, then I hit alt, h, h, and select the color i want with arrow keys. If I have the color defaulted in, I just hit alt, h, h, enter. Very quick IMO?
Still not sure if I want to spend the next 30+ years grinding away in corporate finance and the WSO dream chase or look to have enough passive income to live simply and work minimally.
Want to Vote on this Content?! No WSO Credits?
Already a member?
Anyone know the shortcut to skip a column when highlighting across the page?
Are you a CEO, CFO or other executive facing these or similar charges?
Why should you go to jail for a crime someone else noticed?
Want to Vote on this Content?! No WSO Credits?
Already a member?
Not sure if you mean every-other column, but when highlighting, press F8 (while already holding shift, so essentially Shift+F8), and you're free to navigate while maintaining any cells already highlighted.
Also, not sure if this got covered in the three years of comments here, but for those who dislike Ctrl+0/9 for hiding columns/rows, simply include shift in either command to un-hide the column/row. And you don't have to press Ctrl/Shift + Space first to hide or unhide. The command works based on which cell(s) you have highlighted when hiding/unhiding.
Want to Vote on this Content?! No WSO Credits?
Already a member?
Sorry I'm a freshman here but I don't find the "link" mentioned in the post
Weeps may endure through the night, but joy cometh in the morning.
Want to Vote on this Content?! No WSO Credits?
Already a member?
Thanks for all the shortcuts freeminimalist, i'm still faster than most of the SAs after texting and napping!
Want to Vote on this Content?! No WSO Credits?
Already a member?
I love that this turned into a big Fuck you to the guy who was all about it only saving two minutes a day.
If I had asked people what they wanted, they would have said faster horses - Henry Ford
Want to Vote on this Content?! No WSO Credits?
Already a member?
good job man, but as an analyst you have to do alot more !!!
[url=http://electronicbookreadingdevice.com/]KindleWire... Reading Device Electronic Book Reader[/url]
Want to Vote on this Content?! No WSO Credits?
Already a member?
Love the post. Here's a good one: if you have a ton of windows open and you need to get to your desktop, (windows button + D) is an absolute game-changer. Do it again to return the windows to their original state. Money in the bank.
Also, to print preview in Excel, try (CTRL + F2) - way more efficient than Alt + F + W + V in '07.
Want to Vote on this Content?! No WSO Credits?
Already a member?
I don't really think they save that much time. (being worth 2 seconds of efficiency each) I could save more time per day by going on one less 2 minute restroom break.
Resume Writing Services
Want to Vote on this Content?! No WSO Credits?
Already a member?
I just compiled a concise list of what I think are the most useful keyboard shortcuts in Excel 2003, 2007, and 2010. IMHO, these are the shortcuts that every i-banker memorizes within a week of starting. Let me know if I missed any obvious ones...
Here is the link:
http://smartshortcuts.com/shortcuts
Want to Vote on this Content?! No WSO Credits?
Already a member?
Should put in some ppt shortcuts for instance ALT + Shift = has saved me a ton of time trying to footnote my assumption
Want to Vote on this Content?! No WSO Credits?
Already a member?
I am new to this forum and trying to figure out this..
Want to Vote on this Content?! No WSO Credits?
Already a member?
Bump. Would anyone be willing to provide the TTS Turbo Macros .xla? Would really appreciate it.
Thanks in advance!
Want to Vote on this Content?! No WSO Credits?
Already a member?
Bump indeed. I would think that for any serious resume writer or keyboard jockey, using macros and keyboard shortcuts would be absolutely key.
Want to Vote on this Content?! No WSO Credits?
Already a member?
very useful
1y Associate in IBD
Want to Vote on this Content?! No WSO Credits?
Already a member?
Can anyone send me the link?
Want to Vote on this Content?! No WSO Credits?
Already a member?
7,548 questions across 469 investment banks. The WSO Investment Banking Interview Prep Course has everything you'll ever need to start your career on Wall Street. Technical, Behavioral and Networking Courses + 2 Bonus Modules. Learn more.
Excel 2010 Keyboard Shortcut Guide (Originally Posted: 06/28/2010)
Has anyone seen a Wallstreet prep (or something similar) Keyboard Shortcut guide for Excel 2010?
Thanks
Want to Vote on this Content?! No WSO Credits?
Already a member?
bump
Want to Vote on this Content?! No WSO Credits?
Already a member?
I haven't used 2010, but likely they haven't changed the shortcuts much from '07 to '10.
http://www.WallStreetPrep.com/extrafiles/finmodeling/downloads/xlshortcuts07.pdf
Financial Modeling Training
Guide to Finance Interviews
Banking Resume
Want to Vote on this Content?! No WSO Credits?
Already a member?
What bank uses Excel 2010 (or even 2007)?
Want to Vote on this Content?! No WSO Credits?
Already a member?
Just about all of them use 2007.
Financial Modeling Training
Guide to Finance Interviews
Banking Resume
Want to Vote on this Content?! No WSO Credits?
Already a member?
actually 100% wrong. all of them use 2003 verified UBS, CS, Citi, baml, GS, barcap
Want to Vote on this Content?! No WSO Credits?
Already a member?
Does anyone know of specific bulge bracket banks that use 2003? Please list them if possible.
Want to Vote on this Content?! No WSO Credits?
Already a member?
BAML uses 2003
Want to Vote on this Content?! No WSO Credits?
Already a member?
Citi /GS use 2003
Love all, trust a few, do wrong to none.----William Shakespeare
Want to Vote on this Content?! No WSO Credits?
Already a member?
Yeah, Citi uses 2003. They are testing 2007 now and will upgrade in the autumn.
Want to Vote on this Content?! No WSO Credits?
Already a member?
I can't think of any BB that doesn't use 2003 or proprietary software.
Want to Vote on this Content?! No WSO Credits?
Already a member?
Last GS model I got was .xlsx.
Hmm... I guess all BB don't use 2007.
Something to consider is there are some people who still insist on using 2003 even though their IT department has rolled out Office 2007. There's quite a few of those people in my office as well. Also, any templates saved as an 2003 .xls file and opened and manipulated in 2007 and saved again will look like a model created in Excel 2003.
Financial Modeling Training
Guide to Finance Interviews
Banking Resume
Want to Vote on this Content?! No WSO Credits?
Already a member?
It's going to be a nightmare when they start rolling out 2010
Want to Vote on this Content?! No WSO Credits?
Already a member?
Share : Excel Financial All Programs
Our Complete Excel Templates 2010 Collection provides all 180 business finance spreadsheets within 30 workbooks. Plus Excel add-ins and Risk Analysis spreadsheets which will help you manage financial assets, analyze investments, control cash flows, set up budgets and model financial statements and forecasts quickly and effectively.
[img]http://oursdownload.com/oursdownload.files/gol...
Try it now at http://oursdownload.com/financial-excel.html
Our Financial Excel workbooks include:
Project cash flows rate of return targeting using Excel Goal Seek. Adjust any individual income/cost/sale/recovery forecast and drive your project to the desired rate of return.
Investment-Calc spreadsheets analyses Present values and internal rates of return of periodic cash flows, future values of money flows, present values compounded between dates, present values of a recurring amount, present value of periodic investments, acquisition synergy net present values, cost of capital, terminal (to infinity) net present values.
30 page Guide to Investment Rate of Return Calculations with formulas including worked examples.
Master Budgeting for 1-10 departments. Consolidates individual budgets year to date and provides monthly variance analysis. 12 months departmental budgets consolidated.
The Fixed Asset Accounting workbook provides all you need to keep track of and forecast depreciation for a maximum 3,000 assets. Use Excel 97-2003, 2007 & 2008 to work with depreciation records, book values and disposals. It will save you many hours of work with MACRS tax depreciation and deferred tax balances. Recalculate or model asset balances at any month end date.
Instant Balance Sheets. For a more complete description copy this link into your browser.
Excel Costing templates provide standard costing models. Now includes Profit Margin risk analysis by simulating probable profit outcomes when different cost variances are consolidated.
Financial ratio analysis. Balance sheet, income statement and cash flow analysis calculates 50 key ratios, including operating ratios, shareholder returns, working capital, debt, sales days, inventory turnover, and liquidity.
FastPlan 9.16 for five year financial plans. Develop your 5 year financial forecast and transfom these into simulated balance sheets, income forecasts and cash flows.
Try it now at http://oursdownload.com/financial-excel.html
Want to Vote on this Content?! No WSO Credits?
Already a member?
Excel shortcut - Shortcut for increase/decrease decimal? (Originally Posted: 03/11/2008)
Ok this is really pissing me off...
anyone got a shortcut for increase/decrease decimal?
Financial Modeling Training
Guide to Finance Interviews
Banking Resume
Want to Vote on this Content?! No WSO Credits?
Already a member?
What is Crtl+1, tab tab tab, up up up/down down down getting tedious? The Training the Street macro has a short cut; can't remember if Fasttrack does or not but I'm pretty sure there isn't a native one if TTS built it into a macro. If all else fails just copy/paste format I guess...
Want to Vote on this Content?! No WSO Credits?
Already a member?
on dealmaven, ctrl + < or >
my dealmaven recently stopped working and its a real pain when you want to check #s to 3 decimal and bring them back to ctrl+1, i dont think there is a non-macro shortcut but would be interested if someone knows
Want to Vote on this Content?! No WSO Credits?
Already a member?
You can assign a shortcut key to the .001--> <---.01 buttons in your toolbar. I just dont remember how. I did it for the formula auditing buttons a while back. Im sure someone on here knows...
Want to Vote on this Content?! No WSO Credits?
Already a member?
Hold down Alt, click and move it next to File, which is where I placed it. Next time, all you have to do is hit alt then tab, or alt then ->.
Increasing/decreasing decimals used to aggrevate the shit out of me since there was no shortcut keys, until a friend shed some wisdom on the above mentioned.
Want to Vote on this Content?! No WSO Credits?
Already a member?
Yeah I just cannot believe that there is not a native shortcut for it...
Financial Modeling Training
Guide to Finance Interviews
Banking Resume
Want to Vote on this Content?! No WSO Credits?
Already a member?
no built in one... I built one in VBA, but it only works for plain integers and not percentages or currency terms, which makes it a bit annoying to work with. If you want that vba code pm me and I'll send mine over
Want to Vote on this Content?! No WSO Credits?
Already a member?
I already have other shit there unfortunately... firm-specific formatting bullshit. Thanks though. PM me the VBA code, I'll take a look. Thanks.
Financial Modeling Training
Guide to Finance Interviews
Banking Resume
Want to Vote on this Content?! No WSO Credits?
Already a member?
This came up on Bankers Ball a while back. Their suggestions are all kind of dumb and half-assed, but comment #1 nails it FTW.
http://bankersball.com/2007/10/21/little-known...
Want to Vote on this Content?! No WSO Credits?
Already a member?
Genius, thanks.
Financial Modeling Training
Guide to Finance Interviews
Banking Resume
Want to Vote on this Content?! No WSO Credits?
Already a member?
works well... but same issue as my macro, doesn't adjust for the currency or percentages. I mean I guess if you really needed to adjust it for various cells that aren't connected, just hit ctrl+1, alt+d, number of decimal places, then f4 to the other cells. Kind of long and annoying though, but what can you do.
Want to Vote on this Content?! No WSO Credits?
Already a member?
I'm using these macros - assign to hotkeys.
Sub IncreaseDecimal()
On Error Resume Next
Num_Format = Selection.NumberFormat
Left_Format = Left(Num_Format, InStr(Num_Format, "."))
Right_Format = Right(Num_Format, Len(Num_Format) - InStr(Num_Format, "."))
Selection.NumberFormat = Left_Format & "0" & Right_Format
End Sub
Sub DecreaseDecimal()
On Error Resume Next
Num_Format = Selection.NumberFormat
Left_Format = Left(Num_Format, InStr(Num_Format, "."))
Right_Format = Right(Num_Format, Len(Num_Format) - InStr(Num_Format, "."))
Selection.NumberFormat = Left_Format & Right(Right_Format, Len(Right_Format) - 1)
End Sub
Want to Vote on this Content?! No WSO Credits?
Already a member?
What do you mean? It works fine for me when moving decimals on a percentage (or any other format).
Want to Vote on this Content?! No WSO Credits?
Already a member?
really? wasn't working for me, let me remove the macro, and then reset it for that function, see if it works
Want to Vote on this Content?! No WSO Credits?
Already a member?
damn that bankersball shit is genius
Want to Vote on this Content?! No WSO Credits?
Already a member?
You should just install the add-in. It has macros for color, fill, alignment, number (format), decimal, and zoom. PM me if you need
Want to Vote on this Content?! No WSO Credits?
Already a member?
Is it free? If so, where can I download it from?
Want to Vote on this Content?! No WSO Credits?
Already a member?
Thats what I was talking about.... didnt remember how to do it though. I surprised none of you knew about it.
Want to Vote on this Content?! No WSO Credits?
Already a member?
Does anyone have the password for the TTS macro? I'd like to edit some of their macros but it's password protected. I'm sure someone has come across the pword somewhere.
Want to Vote on this Content?! No WSO Credits?
Already a member?
SimpleShortcuts lets you increase and decrease decimal places with a keyboard shortcut. It's free to download at http://simpleshortcuts.net.
Want to Vote on this Content?! No WSO Credits?
Already a member?
Excel Shortcuts -- Resource (Originally Posted: 01/11/2013)
WSO:
Just started a blog where I will post IB tips. I've included Excel resources on it that I hope are helpful to other bankers / prospective bankers. I'm looking for some feedback -- are there other Excel functions you guys commonly use that I should include? Also is this blog even helpful at all? Just looking for suggestions and helping other IB-ers out. Happy to get feedback.
bankerzhaus.wordpress[dot]com
Want to Vote on this Content?! No WSO Credits?
Already a member?
Checked it out. Very nice.
The Excel tips are a great resource. Keep it coming.
"Those who can give up essential liberty to obtain a little temporary safety, deserve neither liberty nor safety."- Benjamin Franklin
Want to Vote on this Content?! No WSO Credits?
Already a member?
Thanks for the Excel tips, always helpful
"I must create a system or be enslaved by another man's." William Blake
Want to Vote on this Content?! No WSO Credits?
Already a member?
Here's some more if you need to add any.
http://asap-utilities.com/excel-tips-shortcuts...
Want to Vote on this Content?! No WSO Credits?
Already a member?
thanks, guys. I'm thinking about expanding the site to questions that bankers have on the job -- aside from basic Excel / modeling stuff, what do you think would be helpful?
Want to Vote on this Content?! No WSO Credits?
Already a member?
Also -- if anyone is interested in writing, that'd be sweet. Just PM me.
Want to Vote on this Content?! No WSO Credits?
Already a member?
Good stuff, thanks. I think to avoid becoming overly repetitive of other similar sites, I would suggest sharing some of your own personal experiences since they will be unique.
Want to Vote on this Content?! No WSO Credits?
Already a member?
Awesome. Thanks for this.
Want to Vote on this Content?! No WSO Credits?
Already a member?
Some very good stuff in there. For anyone who isn't confident with Excel I strongly recommend a look, especially at part 2!.
See my other WSO blog posts>
Want to Vote on this Content?! No WSO Credits?
Already a member?
Thanks, guys -- appreciate the feedback. Don't want to sound like a spammer, but pass it on to anyone you think could squeeze some juice outta it. Going to update it with some acc/dil soon.
Want to Vote on this Content?! No WSO Credits?
Already a member?
Excel Shortcut Help- Showing fulll digits (regardless of how many decimals), for a short period of time (Originally Posted: 09/02/2015)
I remember a teacher once showing me a keyboard shortcut to show the entire figure of a cell for a moment of time.
ex. if the content shows 3.9, pressing something would show 3.9234234234 for a small amount of time.
Thanks in advance!
Want to Vote on this Content?! No WSO Credits?
Already a member?
F2 if it's a hard-coded number that's just rounded
Want to Vote on this Content?! No WSO Credits?
Already a member?
CTRL+~ if you need to see the whole sheet at once
Want to Vote on this Content?! No WSO Credits?
Already a member?
what do you mean for a short period of time? as in a few second and then it rounds it?
Want to Vote on this Content?! No WSO Credits?
Already a member?
F2, highlight the the cells in the formula, and then hit F9. Hit Esc to exit. Example: all cells are set to round to one decimal place. Cell A1 has 4.532, cell A2 has 6.983, and cell A3 has "=A1+A2" in it. Cell A3 would show 11.5. If you hit F2 in cell A3 and highlight the "A1+A2" part of the formula, F9 will show you 11.515.
Want to Vote on this Content?! No WSO Credits?
Already a member?
Are there Excel shortcuts for inserting rows/columns? (Originally Posted: 06/24/2009)
Thanks
Want to Vote on this Content?! No WSO Credits?
Already a member?
Wow..
Rows: Alt + I + R
Columns: Alt + I + C
Want to Vote on this Content?! No WSO Credits?
Already a member?
google plz kthx.
Want to Vote on this Content?! No WSO Credits?
Already a member?
The way I do it is hit shift+spacebar to highlight row and then hit shift+ctrl+= to insert a row (ctrl+spacebar for columns).
Want to Vote on this Content?! No WSO Credits?
Already a member?
ditto...
Want to Vote on this Content?! No WSO Credits?
Already a member?
For future reference, just google it
Want to Vote on this Content?! No WSO Credits?
Already a member?