Excel 2013 Shortcuts

www.wallstreetprep.com

Excel 2013 Reference Sheet Formatting shortcuts Bold Ialic Underline Forma Box Copy Pase Pase Only Formas Pase Only Formulas Pase Only Values Cu Repea Undo Delee cell conens Delee all cell atribues Delee cell commen Ouline border Remove border Inser a commen

Auditing shortcuts CTRL + B CTRL + I CTRL + U CTRL + 1 CTRL + C CTRL + V ALT ALT + E + S + T ALT + E + S + F ALT + E + S + V CTRL + X CTRL + Y CTRL + Z Delee ALT ALT + H + E + A ALT ALT + H + E + M SHIFT + CTRL + & SHIFT + CTRL + _ SHIFT + F2

Workbook navigation shortcuts Toggle Excel workbooks Spli Screen Freeze pane New workbook Prin Open workbook Save workbook Acivae menu bar Min / Resore Ribbon Prin preview Close window Close program

CTRL + TAB ALT ALT + W + S (F6 o jump rom pane o pane) ALT + W + F + F CTRL + N CTRL + P CTRL + O (CTRL + F12) CTRL + S ALT ALT or F10 CTRL + F1 CTRL F2 CTRL + F4 ALT + F4

Cell navigation shortcuts Go o end o coniguous range Selec a cell range Highligh coniguous range Move o beginning o line Move o cell “A1” “A1” Move o cell above Move o cell o he righ Move o cell o he lef Delee cell and ge inside Delee cell/selecion Show ormulas/values Fill selecion w/ enry

CTRL + Arrow keys SHIFT + Arrow keys SHIFT + CTRL + Arrow keys Home CTRL + Home SHIFT + ENTER TAB SHIFT + TAB TAB BACKSPACE BACKSPACE DELETE CTRL + ~ CTRL + Ener

Other useful shortcuts Excel Opions Recalculae all workbooks Ge inside a drop-down lis Display “Inser Funcion” box Display “Name” box Ener array ormula

ALT ALT + F + T F9 ALT ALT + up/down arrow keys ALT ALT + I + F (SHIFT F3) CTRL F3 SHIFT + CTRL + Ener

Trace immediae precedens Trace immediae dependens Remove racing arrows Evaluae ormula Track changes Zoom o selecion Go o preceden cells Go o dependen cells Go back o original cell “Go o”

ALT ALT + M + P ALT ALT + M + D ALT ALT + M + A + A ALT ALT + M + V ALT + R + G ALT ALT + W + G CTRL + [ CTRL + ] F5 + Ener F5

Tab navigation Move/ Copy a ab Change ab name Moving o lef/righ abs New ab Inser workshee

ALT + H + O + M ALT ALT + H + O + R CTRL + Pg Up/Down SHIFT + F11 ALT ALT + I + W

Row/column shortcuts Selec column CTRL + Space Selec row Shif + Space Delee row(s) / column(s) CTRL + ‘minus sign’ Add row(s) / column(s) CTRL + SHIFT + ‘plus sign’ Group / ungroup rows and columns SHIFT + ALT + lef / righ arrow key Fi column widh ALT ALT + H + O + I

Data editing shortcuts Selec All Fill Down Fill righ Find Replace Flash Fill Edi cells Sar a ormula Inser AuoSum ormula

CTRL + A CTRL + D CTRL + R CTRL + F CTRL + H CTRL + E F2 = (equal sign) ALT ALT + “+“ (hold down ALT) ALT)

Data editing shortcuts when inside cell Sar new line in same cell ALT ALT + ENTER Highligh wihin cells SHIFT + Arrow keys Highligh coniguous iems SHIFT + CTRL + Arrow keys Delee preceding characer BACKSPACE BACKSPACE Delee characer o he righ DELETE Anchor “Fix” Cells F4 Cancel a cell enry ESC Inspec cell values in cell edi mode F9

Excel Utilities Inser a pivo able Inser a daa able Sor a able Auofiler selecion Record a Macro

ALT ALT + N + V ALT ALT + D + T ALT ALT + D + S ALT ALT + A + T ALT ALT + L + RS

Note: Some hird-pary uiliies, macros and add-ins can overwrie naive shorcu keys

www.wallstreetprep.com

Boost Excel Add-In

Download Boos a wspanalytics.com

The Boost Excel Add-In is an all-in-one suie o ime-saving keyboard shorcus, ormating ools, and audiing ools designed specifically or people who build financial models in Excel. Download a ree rial a wspanalyics.com.

Essential Shortcuts Number Cycle

Crl Shif 1

Toggle hrough commonly used number ormas

Color Cycle

Crl ‘

Toggle hrough commonly used colors

Border Shorcus

Crl Al Shif + Arrows

Easily apply lef, righ, op, and botom border

Power Trace Precedens

Crl Shif [

Easily navigae hrough preceden cells o long ormulas

Power Trace Dependens

Crl Shif ]

Easily navigae hrough dependen cells o long ormulas

Power Fill Righ

Crl Shif R

Auomaically fill daa o he righ unil he desired poin

Auocolor cells

Crl Al A

Auocolor inpu and ormula cells based on color preerences

Capure Painbrush Syle

Crl Al C

Capures up o 5 cell ormas

Apply Painbrush Syle

Crl Al V

Applies previously capured cell ormas

Boos Browser

SEC Filings Wizard Buton

Open he laes 10K or 10Q or a company direcly ino Excel

=BOOST() Codes

Type =Boos() in a cell

Inegrae marke daa like share price & EBITDA direcly ino Excel

WSP Models Library

WSP Models Library Buton

Access Wall Sree Prep’s Comprehensive Model Templaes

Other Helpful Shortcuts Sizing  Zoom In` Zoom Ou Increase Fon Size Decrease Fon Size Increase Decimal Decrease Decimal Shif Decimal Righa Shif Decimal Lef

Alignment & Borders Crl Al = Crl Al Crl Shif F Crl Shif G Crl , Crl . Al Shif . Al Shif ,

Cener Cycle Horizonal Cycle Verical Cycle Inden Cycle Border Cycle Border Ouline Border None

Rows Crl Shif C Crl Shif H Crl Shif V Crl Shif I Crl Shif B Crl Shif 7 Crl Shif -

Dates & Formulas Numbers Currency Cycle Percen Cycle Muliple Cycle

Crl Shif 4 Crl Shif 5 Crl Shif 8

Colors Blue-Black Cycle Fill Color Cycle Auocolor Cycle No Auocolor Cycle Auocolor Shee Auocolor Workbook

Crl ; Crl Shif K Crl Al . Crl Al Z Crl Al S Crl Al Q

Dae Cycle Year Cycle Las Audied Cell Error Wrap Pase Exac Formulas Pase Exac Transpose

Crl Shif 2 Crl Shif A Crl Shif \ Crl Shif E Crl Al E Crl Al T

Navigation Workshee Loop Firs Workshee Las Workshee Goo Max Goo Min

Crl Al PgUp /PgDn Crl Al Home Crl Al End Crl Al Shif . Crl Al Shif ,

Dashboard Shortcuts General Setings Shorcu Manager Prin Shorcus Quick Save Gridlines Toggle Disable F1 key

Crl Shif S Crl Al Shif S Crl Al Shif P Al Shif S Al Shif G Crl Al Shif N

Text Underline Cycle Case Cycle Lis Cycle Wrap Tex Swiches Cycle

Crl Shif U Al Shif C Crl Al Shif L Crl Shif W Crl Shif Y

Inser Delee Group Deails Show Deails Hide Deails Expand All Hide All Heigh Cycle Auo Heigh Ungroup

Al Shif Inser Al Shif Delee Al Shif Down Arrow Al Shif End Al Shif Home Al Shif = Al Shif Al Shif Page Up Al Shif Page Down Al Shif Up Arrow

Columns Inser Delee Group Deails Show Deails Hide Deails Expand All Hide All Widh Cycle Auo Widh Down Ungroup Power Hide

Crl Al Shif Inser Crl Al Shif Delee Al Shif Righ Arrow Crl Al Shif End Crl Al Shif Home Crl Al Shif = Crl Al Shif Crl Al Shif Page Up Crl Al Shif Page Al Shif Lef Arrow Crl Al H