Keyboard Shortcuts - I'm a huge nerd
(Baboon, 110
Points)
on 9/21/06 at 5:49pm
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





nothing wrong
nothing wrong with the mouse, you only save like 2 seconds by doing the short cuts. But good list anyway :)
Thanks, thats a good one
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.
Not an Analyst
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?
I sympathize tremendously
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.
Id say they save you 2
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
Shift-Space is select
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
I've got a couple that for
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)
All the Ctrl-Shifts are
All the Ctrl-Shifts are massive time savers.
----------------
Account Inactive
Re: nothing wrong
nothing wrong with the mouse, you only save like 2 seconds by doing the short cuts. But good list anyway :)
Do you have any idea what you are talking about? I hope you say that in an interview.
Yeah. In training, we did
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.
I sometimes use the mouse if
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.
Paint Brush
is there a hot key for the paint brush, what about outlining cells?
Shortcut Question
Is there a shortcut to tab between frames on a webpage?
Re: Paint Brush
is there a hot key for the paint brush, what about outlining cells?
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.
good call
good call
Correct me
you save a lot more time
My recent favorite
Shortcuts
--------------
Either you sling crack rock or you got a wicked jump shot
Excel: I don't like Ctrl 0
Blast from the past
Does anyone know where the
Others added, but here is the original
Seen this?
--
Support WSO.com and visit these links!
Financial Modeling Training
Guide to Finance Interviews
Thanks...Much appreciated
Office '07
a
F4 is quicker than CTRL+y in Excel
Anyone know how to move from
F2?
thanks for the Alt + "=" .
optional key on keyboard
F1
rip the F1 key off your
F9 - Update :) F9 -
sick post
it's
yeah
WSO Conference 2013
Private Certified User Chat
Crtl + Page Up/Page Down =
Excel Keyboard Shortcuts
Simpleshortcuts
Column/row width
^^ Consultant in the house,
P.P.P.S. My favorite
P.P.P.P.S.
good
I'm really suprised
couldnt get it to work for fill color!!
no, this should work for
oh cool, thanks! Its funny