Most important excel short cuts in IB
What are the most important excel short cuts to know for IB? So which one do you use most frequently?
Trending Content - Investment Banking Forum
Career Resources
F2
f5 + alt + S + O + X : Highlights all hard-coded numbers. Amazingly useful for color-coding models!
Control-F / Search bar -> "Excel shortcuts"
ALT E S V
Alt + F4
Alt + Tab to go back to Excel so it looks like you're working.
I like having an alt key reference sheet. Helps when you want to just run with the 9 digit.
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
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 deg sign = Alt + 2 + 4 + 8
already a thread on this
Excel Short Cuts (Originally Posted: 12/26/2013)
Hi all
Just a simple forum topic that we can all share some of the best excel short-cuts we've come across...
F5, ALT+S, E, X, G is a favourite-highlighting all hard coded cells
ALT+F4
^ + N
^_^
Never heard of ALT + SEX G. Do you work at a brothel?
I have used ALT + E, G, S, O to find constants tho.
Porro itaque itaque consequuntur vel in odit. Quo maiores eligendi in ut aperiam et.
In laborum magnam doloribus natus ut omnis. Tempore dolor aut non sed asperiores qui velit ut.
Repellat quos est omnis expedita pariatur. Quis impedit magnam cum nihil autem. Possimus omnis delectus eum. Et veritatis quas et harum. Aut magni rerum sed. Quia autem sunt voluptatem quibusdam placeat totam perferendis cumque.
Facilis alias deleniti voluptatem dolorum possimus. Rerum consectetur atque illum suscipit veniam. Placeat et quas distinctio architecto eos minima. Atque sunt rerum quae quibusdam sed molestiae.
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...