Keyboard Shortcut For Excel And Financial Modelling

Open File - Ctrl + O

New File - Ctrl + N

Print - Ctrl + P

Save File - Ctrl + S

Save File As - F12

Close File - Ctrl + F4

Close Excel - Alt + F4

Exit Dialog - Esc

Copy - Ctrl + C

Cut - Ctrl + X

Paste - Ctrl + V

Undo - Ctrl + Z

Redo - Ctrl + Y

Select All - Ctrl + A

Find - Ctrl + F

Replace - Ctrl + H

Switch Windows - Alt + Tab

Options Menu - Alt + T + O

Repeat Last Action - F4

Show / Hide Ribbon Menu - Ctrl + F1

Select Column - Ctrl + Spacebar

Select Row - Shift + Spacebar

Insert Cells /Rows / Columns - Ctrl + Shift + +

Delete Cells /Rows / Columns - Ctrl + –

Insert Cut Cells and Shift Over - Right Mouse Button + E

Group Rows /Columns - Alt + A + G + G

Group Rows /Columns - Shift + Alt + Right

Ungroup Rows /Columns - Alt + A + U + U

Ungroup Rows /Columns - Shift + Alt + Left

Format Menu - Alt + H

Format Dialog - Ctrl + 1

Paste Special - Ctrl + Alt + V

Paste Formats - Ctrl + Alt + V + T

Paste Values - Ctrl + Alt + V + V

Paste Formulas - Ctrl + Alt + V + F

Font Color - Alt + H + FC

Fill Color - Alt + H + H

Border Options - Alt + H + B

Align Left / Center/ Right - Alt + H + A + L / C / R

Increase Indent - Alt + H + 6

Decrease Indent - Alt + H + 5

Increase Decimal Places - Alt + H + 0

Decrease Decimal Places - Alt + H + 9

Bold - Ctrl + B

Italics - Ctrl + I

Underline - Ctrl + U

Strikethrough - Ctrl + 5

Add Borders - Ctrl + Shift + &

Delete Borders - Ctrl + Shift + –

General - Shift + Ctrl + ~

Number - Shift + Ctrl + !

Time - Shift + Ctrl + @

Date - Shift + Ctrl + #

Currency - Shift + Ctrl + $

Percentage - Shift + Ctrl + %

Scientific - Shift + Ctrl + ^

Auto-Fit Col. - Alt + H + O + I

Auto-Fit Row - Alt + H + O + A

Column Width - Alt + H + O + W

Row Height - Alt + H + O + H

Conditional Formatting - Alt + H + L + R

Format as Table - Alt + H + T

Move Around - Arrow Keys

Jump to Boundary - Ctrl + Arrows

Select Cells - Shift + Arrows

Select to Boundary - Shift + Ctrl + Arrows

Select Multiple Areas - Shift + F8

Edit Cell - F2

Delete Cell Contents - Del

Skip Word(s) - Ctrl + Arrows

Highlight Word(s) - Ctrl + Shift +Arrows

New Line in Cell - Alt + Enter

Edit and Stay in Place / Go Left / Go Right - Ctrl + Enter / Tab / Shift +Tab

New Workbook - Ctrl + N

Switch Workbook - Ctrl + Tab

New Worksheet - Shift + F11

Del Worksheet - Alt + H + D + S

Move to Left Worksheet - Ctrl + PgUp

Move to Right Worksheet - Ctrl + PgDn

Move / Copy Worksheet - Alt + H + O + M

Select Multiple Worksheets - Shift + Ctrl + Pg Up / Pg Dn

Hide Worksheet - Alt + H + O + U + S

Show Worksheet - Alt + H + O + U + H

Rename Worksheet - Alt + H + O + R

Color Tab - Alt + H + O + T

Refresh All - F9

Anchor Cell - F4

Name Cell - Ctrl + F3

Jump to Cell - F5

Use Suggested Name - Tab

Enter Built-In Function - Shift + F3

Paste Formulas - Ctrl + Alt + V + F

Paste Formats & Formulas - Ctrl + Alt + V + R

Copy Down - Ctrl + D

Copy Right - Ctrl + R

Copy from Above - Ctrl + ’

Go to Formulas - F5, Alt + S + F + X

Go to Constants - F5, Alt + S + O + X

Show Formulas - Ctrl + ~

Freeze Panes - Alt + W + F + F

Zoom - Alt + W + Q

Zoom - Ctrl + Mouse Scroll Wheel

Page Setup - Alt + P + S + P

Set Print Range to Selected Area - Alt + P + R + S

Print Preview - Ctrl + F2

Page Break View - Alt + W + I

Normal View - Alt + W + L

Toggle Gridlines - Alt + W + VG

Immediate Precedents - Ctrl + [

Immediate Dependents - Ctrl + ]

Trace Precedents - Alt + M + P

Trace Dependents - Alt + M + D

Erase Traces - Alt + M + A + A

All Precedents - Shift + Ctrl + {

All Dependents - Shift + Ctrl + }

Jump to Original Cell - F5 + Enter

Add/Edit Comment - Shift + F2

Del Comment - Alt + R + D

Show All Comments - Alt + R + A

Highlight Cells w/ Comments - F5, Alt + S + C

Pivot Table - Alt + N + V

Sort Data - Alt + A + SS

Sort Ascending - Alt + A + SA

Sort Descending - Alt + A + SD

Filter Data - Ctrl + Shift + L

Advanced Data Filter - Alt + A + Q

Filter by Cell’s Properties - Right Mouse Button + E + V

Remove Duplicates - Alt + A + M

Validate Data - Alt + A + V + V

VBA Editor - Alt + F11

Run Macro - F5 (in VBA)

Object Browser - F2 (in VBA)

Immediate Window - Ctrl + G (in VBA)

Form Control - Alt + L + I

Use Relative References - Alt + W + M + U

Record Macro - Alt + W + M + R

View Macros - Alt + W + M + V

Scenario Manager - Alt + A + W + S

Goal Seek - Alt + A + W + G

Data Table - Alt + A + W + T