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