www.wallstreetprep.

com

Excel 2010 Reference Sheet

Formatting shortcuts

Tab navigation

Bold

CTRL + B

Move/ Copy a tab

ALT + H + O + M

Italic

CTRL + I

Change tab name

ALT + H + O + R

Underline

CTRL + U

Moving to left/right tabs

CTRL + Pg Up/Down

Format Box

CTRL + 1

New tab

SHIFT + F11

Clear cell

ALT + H + E + A

Outline border

SHIFT + CTRL + &

Row/column shortcuts

Remove border

SHIFT + CTRL + _

Select column

CTRL + Space

Insert a comment

SHIFT + F2

Select row

Shift + Space

Copy

CTRL + C

Delete row(s) / column(s)

CTRL + minus sign

Paste

CTRL + V

Add row(s) / column(s)

CTRL + SHIFT + plus sign

Paste Special

ALT H + V + S (ALT + E + S still works)

Group/ungroup rows & columns

SHIFT + ALT + left / right arrow key

Cut

CTRL + X

Fit column width

ALT + H + O + I

Repeat

CTRL + Y

Undo

CTRL + Z

Data editing shortcuts

Delete selected cells

CTRL + Minus sign

Select All

CTRL + A

Fill Down

CTRL + D

Fill right

CTRL + R

Workbook navigation shortcuts

Toggle Excel workbooks

CTRL + TAB

Find

CTRL + F

Split Screen

ALT + W + S (F6 to jump from pane to pane)

Replace

CTRL + H

Freeze pane

ALT + W + F

Edit cells

F2

New workbook

CTRL + N

Start a formula

= (equal sign)

Print

CTRL + P

Insert AutoSum formula

ALT + +

Open workbook

CTRL + O (CTRL + F12)

Save workbook

CTRL + S

Cell navigation shortcuts

Activate menu bar

ALT or F10

Go to end of contiguous range

CTRL + Arrow keys

Min / Restore Ribbon

CTRL + F1

Select a cell range

SHIFT + Arrow keys

Print preview

ALT + F + W + V (CTRL F2)

Highlight contiguous range

SHIFT + CTRL + Arrow keys

Close window

CTRL + W (CTRL + F4)

Move to beginning of line

Home

Close program

ALT + F4

Move to cell A1

CTRL + Home

Move to cell above

SHIFT + ENTER

Move to cell to the right

TAB

Other useful shortcuts

Excel Options

ALT + F + T

Move to cell to the left

SHIFT + TAB

Recalculate all workbooks

F9

Delete cell and get inside

BACKSPACE

Display a drop-down list

ALT + up/down arrow keys

Delete cell/selection

DELETE

Display Insert Function box

ALT + I + F (SHIFT F3)

Show formulas/values

CTRL + ~

Display Name box

CTRL F3

Fill selection w/ entry

CTRL + Enter

Enter array formula

SHIFT + CTRL + Enter

Auditing shortcuts

Data editing shortcuts when inside cell

Start new line in same cell

ALT + ENTER

Trace immediate precedents

ALT + M + P

Highlight within cells

SHIFT + Arrow keys

Trace immediate dependents

ALT + M + D

Highlight contiguous items

SHIFT + CTRL + Arrow keys

Remove tracing arrows

ALT + M + A + A

Delete preceding character

BACKSPACE

Evaluate formula

ALT + M + V

Delete character to the right

DELETE

Track changes

ALT + R + G

Anchor Fix Cells

F4

Zoom to selection

ALT + W + G

Cancel a cell entry

ESC

Go to precedent cells

CTRL + [

Go to dependent cells

CTRL + ]

Go back to original cell

F5 + Enter

Go to

F5

Note: Some third-party utilities, macros and add-ins can overwrite native shortcut keys

www.wallstreetprep.com

Boost Excel Add-In

Download Boost at
wspanalytics.com

The Boost Excel Add-In is an all-in-one suite of time-saving keyboard shortcuts, formatting tools, and auditing tools
designed specifically for people who build financial models in Excel. Download a free trial at wspanalytics.com.

Essential Shortcuts
Number Cycle

Ctrl Shift 1

Toggle through commonly used number formats

Color Cycle

Ctrl

Toggle through commonly used colors

Border Shortcuts

Ctrl Alt Shift + Arrows

Easily apply left, right, top, and bottom border

Power Trace Precedents

Ctrl Shift [

Easily navigate through precedent cells of long formulas

Power Trace Dependents

Ctrl Shift ]

Easily navigate through dependent cells of long formulas

Power Fill Right

Ctrl Shift R

Automatically fill data to the right until the desired point

Autocolor cells

Ctrl Alt A

Autocolor input and formula cells based on color preferences

Capture Paintbrush Style

Ctrl Alt C

Captures up to 5 cell formats

Apply Paintbrush Style

Ctrl Alt V

Applies previously captured cell formats

Boost Browser

SEC Filings Wizard Button

Open the latest 10K or 10Q for a company directly into Excel

=BOOST() Codes

Type =Boost() in a cell

Integrate market data like share price & EBITDA directly into Excel

WSP Models Library

WSP Models Library Button

Access Wall Street Preps Comprehensive Model Templates

Other Helpful Shortcuts

Sizing
Zoom In`
Zoom Out
Increase Font Size
Decrease Font Size
Increase Decimal
Decrease Decimal
Shift Decimal Righta
Shift Decimal Left

Alignment & Borders

Ctrl Alt =
Ctrl Alt Ctrl Shift F
Ctrl Shift G
Ctrl ,
Ctrl .
Alt Shift .
Alt Shift ,

Numbers
Currency Cycle
Percent Cycle
Multiple Cycle

Ctrl Shift 4
Ctrl Shift 5
Ctrl Shift 8

Colors
Blue-Black Cycle
Fill Color Cycle
Autocolor Cycle
No Autocolor Cycle
Autocolor Sheet
Autocolor Workbook

Ctrl ;
Ctrl Shift K
Ctrl Alt .
Ctrl Alt Z
Ctrl Alt S
Ctrl Alt Q

Dashboard Shortcuts
General Settings
Shortcut Manager
Print Shortcuts
Quick Save
Gridlines Toggle
Disable F1 key

Ctrl Shift S
Ctrl Alt Shift S
Ctrl Alt Shift P
Alt Shift S
Alt Shift G
Ctrl Alt Shift N

Center Cycle
Horizontal Cycle
Vertical Cycle
Indent Cycle
Border Cycle
Border Outline
Border None

Rows
Ctrl Shift C
Ctrl Shift H
Ctrl Shift V
Ctrl Shift I
Ctrl Shift B
Ctrl Shift 7
Ctrl Shift -

Dates & Formulas

Date Cycle
Year Cycle
Last Audited Cell
Error Wrap
Paste Exact Formulas
Paste Exact Transpose

Ctrl Shift 2
Ctrl Shift A
Ctrl Shift \
Ctrl Shift E
Ctrl Alt E
Ctrl Alt T

Navigation
Worksheet Loop
First Worksheet
Last Worksheet
Goto Max
Goto Min

Ctrl Alt PgUp /PgDn

Ctrl Alt Home
Ctrl Alt End
Ctrl Alt Shift .
Ctrl Alt Shift ,

Text
Underline Cycle
Case Cycle
List Cycle
Wrap Text
Switches Cycle

Ctrl Shift U
Alt Shift C
Ctrl Alt Shift L
Ctrl Shift W
Ctrl Shift Y

Insert
Delete
Group Details
Show Details
Hide Details
Expand All
Hide All
Height Cycle
Auto Height
Ungroup

Alt Shift Insert

Alt Shift Delete
Alt Shift Down Arrow
Alt Shift End
Alt Shift Home
Alt Shift =
Alt Shift Alt Shift Page Up
Alt Shift Page Down
Alt Shift Up Arrow

Columns
Insert
Delete
Group Details
Show Details
Hide Details
Expand All
Hide All
Width Cycle
Auto Width
Down
Ungroup
Power Hide

Ctrl Alt Shift Insert

Ctrl Alt Shift Delete
Alt Shift Right Arrow
Ctrl Alt Shift End
Ctrl Alt Shift Home
Ctrl Alt Shift =
Ctrl Alt Shift Ctrl Alt Shift Page Up
Ctrl Alt Shift Page
Alt Shift Left Arrow
Ctrl Alt H