Excel Shortcuts

tExcel 2003 and 2007 / 2010

Quick Reference – The Most Important Keyboard Shortcuts for

Investment Banking & Private Equity

http://breakingintowallstreet.com

The Fundamentals

Ctrl + O

Ctrl + N

Ctrl + P

Ctrl + S

Ctrl + F4

Alt + F4

Esc

Ctrl + C

Ctrl + X

Ctrl + V

Ctrl + Z

Ctrl + Y

Ctrl + A

Ctrl + F

Ctrl + H

Alt + Tab

Open File

New File

Print

Save File

Close File

Close Excel

Exit Dialog

Copy

Cut

Paste

Undo

Redo

Select All

Find

Replace

Switch Windows

Rows & Columns

Ctrl + Spacebar

Shift + Spacebar

Alt + I + R

Alt + I + C

Alt + E + D

F4

Right Mouse

Button + E

Alt + D + G + G

Alt + D + G + U

Alt + D + G + S

Alt + D + G + H

Navigation & Data Selection

Arrow Keys

Ctrl + Arrows

Shift + Arrows

Shift + Ctrl +

Arrows

Shift + F8

Move Left, Right,

Up, Down

Jump to

Boundary

Select Multiple

Cells

Select to

Boundary

Select Multiple

Areas

Manipulating Cells

F2

Del

Ctrl + Arrows

Ctrl + Shift +

Arrows

Ctrl + F3

F5

Edit Cell

Delete Cell

Contents

Skip Word(s)

Highlight

Word(s)

Name Cell

Jump to Cell

Select Column

Select Row

Insert Row

Insert Column

Delete

Rows/Columns

Repeat Last

Action

Insert Cut Cells

Group Rows /

Columns

Ungroup Rows /

Columns

Show Rows /

Columns

Hide Rows /

Columns

Workbooks & Worksheets

Ctrl + N

Ctrl + Tab

Shift + F11

Alt + E + L

Ctrl + PgUp

Ctrl + PgDn

Alt + E + M

Shift + Ctrl +

PgUp/PgDn

Alt + O + H + H

Alt + O + H + U

Alt + O + H + R

Alt + O + H + T

New Workbook

Switch

Workbook

New Worksheet

Del Worksheet

Move to Left

Worksheet

Move to Right

Worksheet

Move / Copy

Worksheet

Select Multiple

Worksheets

Hide Worksheet

Show

Worksheets

Rename

Worksheet

Color Tab

Formatting & Cleaning Data

Ctrl + 1

Alt + E + S + T

Alt + E + S + V

Shift + Ctrl + ~

Shift + Ctrl + !

Shift + Ctrl + @

Shift + Ctrl + #

Shift + Ctrl + $

Shift + Ctrl + %

Shift + Ctrl + ^

Ctrl + B

Ctrl + I

Ctrl + U

Ctrl + 5

Ctrl + Shift + &...