Microsoft Excel Shortcuts


Your guide to a career in finance^TM

Quick Links:

Learn DCF and LBO Modeling

Learn MS Excel for Financial Services

Submit an Article

Bankingorbust in the News

Sample Interview Questions

2008 M&A Deals You Should Know

People in Finance You Should Know

Microsoft Excel Shortcuts

CLICK HERE to learn Microsoft Excel skills applied to jobs in financial services

Speed is a necessity for a junior banker. Using Excel shortcuts can dramatically save you time while constructing financial models. As you are continually evaluated on the job (even more so during a summer internship), the use of shortcuts help to make you appear more like a seasoned professional.

Many excel shortcuts can be accessed one of two ways:

A combination of the "Ctrl" key with a letter key
Accessing the menu bar with "Alt" and then selecting a function from the menu with subsequent letter keys

Functionally, the Ctrl commands are much faster.

File Management

New: Ctrl N or Alt F N
Open: Ctrl O or Alt F O or Ctrl F12
Close: Alt F C
Print: Ctrl P or Alt F P
Save: Ctrl S or Alt F S
Save As: F12 or Alt F A
Set Print Area: Alt F T S
Clear Print Area: Alt F T C
Insert Page Break: Alt I B
Page Setup: Alt F U
Print Preview: Alt F V

Formatting

Undo Last Action : Ctrl Z or Alt E U
Redo (Reverse Undo): Ctrl Y or Alt E R
Repeat Last Action: F4 or Ctrl Y or Alt Enter
Enter or Exit Cell or Formula Bar: F2
Absolute or Relative Reference: F4

Format Cells

Bold: Ctrl B
Italics: Ctrl I
Underline: Ctrl U
Strikethrough: Ctrl 5
Border Outline: Ctrl Shift 7
Remove Borders: Ctrl Shift -
Format Cells: Ctrl 1

Edit

Cut: Ctrl X
Copy: Ctrl C
Paste: Ctrl V
Paste Special - Formula: Alt ESF, Enter
Paste Special - Format: Alt EST, Enter
Paste Special - Value: Alt ESV, Enter
Copy Right: Select empty cells to the right of filled cell, then Ctrl R
Copy Down: Select empty cells below filled cell, then Ctrl D

Formulas

Sum Formula: Alt=
Function Wizard: Shift F3

Moving Around Excel

Quick move: Ctrl and Arrow in desired direction
Move To Column A: Home
Move To Cell A1: Ctrl Home
Move To Bottom Right Cell: Ctrl End
Page Left: Alt Page Up
Page Right: Alt Page Down
Next Worksheet: Ctrl Page Down
Previous Worksheet: Ctrl Page Up
Next Workbook: Ctrl Tab or Ctrl F6
Previous Workbook: Ctrl Shift Tab or Ctrl Shift F6
Go To: F5 or Ctrl G or Alt E,G