Excel Shortcuts Quick Reference

-

Workbook 

CTRL+O Opens a workbook

CTRL+N Create a new workbook

CTRL+P Displays the print dialog box

CTRL+W Closes the selected workbook 

CTRL+F2 Displays print view 

F9 Calculates all open workbooks 

SHIFT+F9 Calculates the active worksheet 

CTRL+F10 Maximize / restore workbook 

SHIFT+F11 Inserts a new worksheet 

F12 Displays the Save As dialog box 


EDITING 

CTRL+SHIFT+ Enters the current time 
CTRL+              Enters the current date 
CTRL+C         Copies the selected cells 
CTRL+S         Save the workbook
CTRL+D         Copies topmost cell of a range into the cells below 
CTRL+R         Copies leftmost cell of a range into cells to right
CTRL+F         Find dialog box 
CTRL+H         Replace dialog box 
CTRL+K         Edit hyperlink 
CTRL+T         Create Table dialog box 
CTRL+V         Paste 
CTRL+X         Cuts the selected cells 
CTRL+ALT+V Paste Special Dialog box 
CTRL+SHIFT+~ Applies general format 
CTRL+Z         Undoes last action 
SHIFT+F2         Adds / edits comment 
F4                         Toggles between absolute and relative references 
F7                         Spell check 
ALT+=                 Autosum 
ALT+F11         Opens VB Editor 
ALT+D+P         Opens pivot table wizard 
ALT+F8         Opens Macro Dialog box 
ALT+A+M         Removes duplicates 
ALT+A+E         Text to columns Wizard 
ALT+ENTER Enters a new line 
ALT+D+L         Data validation 

Formatting 

CTRL+SHIFT+$   Applies currency format with two decimal places 
CTRL+SHIFT+% Applies percentage format with no decimal places. 
CTRL+SHIFT+#    Applies date format 
CTRL+SHIFT+@ Applies time format 
CTRL+SHIFT+!         Applies the Number format with two decimal places, thousands separator 
CTRL+1                 Displays the Format Cells box 

General 

CTRL+~          Toggles values and formulas  
SHIFT+F3          Insert Function dialog box 
CTRL+F3          Name manager box 
ALT+M+V          Evaluate formula box 
CTRL+SHIFT+U Expand /collapse of the formula bar  
CTRL+F1          Displays or hides the Ribbon 
CTRL+SHIFT+L  Applies / removes filter 
CTRL+-          Delete column, row, cell 
CTRL+9 or 0  9 - Hide row, 0 – Hide column

Navigation 

TAB             Left cell to right cell 
SHIFT+TAB     Right cell to left cell 
CTRL+G or F5   Go To dialog box 
CTRL+END     Moves to last used cell           
CTRL+Home    Moves to the first used cell 
ALT+PAGE     Moves one screen to the DOWN right in a worksheet. 
CTRL+PAGE Moves to the next sheet in 
ALT+PAGE UP Moves one screen to the left in a worksheet 

Selection 

F8                                 Toggles extend mode 
CTRL+SPACEBAR Selects an entire column 
SHIFT+SPACEBAR Selects an entire row 
CTRL+A                 Selects the entire worksheet 









Comments

Post a Comment

Best Blogs

IB Interview Questions: M&A : Level 1 M&A Questions

-
Image
1. Why do companies merge? While are many reasons that companies merge the underlying driver of most M&A deals to expedite growth and/or generate cost savings to create value for the owners of the business. When people say that M&A is an ‘art’ and a ‘science’, what does that mean? The science refers to the mechanical valuation methods (Comps, DCF, etc.), but the art is in making a judgment call on valuation based on the outputs of the various valuation methodologies. 2. Who can pay more when buying a company: a Financial buyer or Strategic buyer? Why? Strategic (i.e. corporate) buyers can typically pay more than Financial (i.e. Private Equity) buyers because strategic buyers typically have overlapping operations that can be removed post-merger to generate cost savings (i.e. Synergies). 3. When are sponsors and corporate buyers on equal footing? When a Financial buyer already owns a competing asset, they can generate synergies (which justifies a higher price) and thus are on mor...
Read more

Getting into Investment Banking: A Comprehensive Guide

-
Image
Introduction Breaking into investment banking (IB) is no small feat, whether you're pre-MBA or post-MBA, from a target or non-target school. While high GPAs and test scores are standard, they are often not enough to stand out. Here’s a strategic approach to help you embark on a successful investment banking career. 1. Network Extensively When your application lands at an investment bank, it’s usually reviewed by a small team of bankers responsible for recruiting from specific schools. Given the competitive nature of this field, networking is crucial. Why Networking Matters: Decision-making bankers are more likely to advocate for you if they know you. Especially vital for non-target school students. Engage with alumni and other connections at your target firms. How to Network: Start reaching out to analysts and associates a few months before core recruiting starts. Look for non-target alumni if you're from a non-target school; they often help each other out. Demonstrate Interest...
Read more