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