Keyboard Shortcut For Excel And Financial Modelling

Keyboard shortcuts for excel in financial modelling boost your modeling skills and save your valuable time.

Keep below shortcuts handy.

Command Actions and Key Strokes

• 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

Note:- If you're using laptop make sure your FN key disable to media for excel use in windows.

Source:- Microsoft Excel