Microsoft
Excel Keyboard Shortcut Keys
|
Shortcut Keys
|
Option
|
|
File (Alt + F)
|
|
|
Ctrl + N
|
New
|
|
Ctrl + O
|
Open
|
|
Ctrl + S
|
Save
|
|
Ctrl + Shift + S
|
Save As
|
|
Ctrl + P
|
Print
|
|
Alt +F4
|
Exit
|
|
Esc
|
Exit Dialog
|
|
Home (Alt + H)
|
|
|
Ctrl + X
|
Cut
|
|
Ctrl + C
|
Copy
|
|
Ctrl + V
|
Paste
|
|
Ctrl + B
|
Bold
|
|
Ctrl + I
|
Italic
|
|
Ctrl +U
|
Underline
|
|
Ctrl + Shift + >
|
Grow Font
|
|
Ctrl + shift + <
|
Shrink Font
|
|
Ctrl + L
|
Left
|
|
Ctrl + E
|
Centre
|
|
Ctrl + R
|
Right
|
|
Ctrl + J
|
Justify
|
|
Ctrl + D
|
Insert Paint Drawing
|
|
F1
|
Help
|
|
Ctrl + F
|
Find
|
|
Ctrl + H
|
Replace
|
|
Ctrl + A
|
Select All
|
|
Ctrl + =
|
Subscript
|
|
Ctrl + Shift + +
|
Superscript
|
|
Ctrl + Shift + D
|
Double Under Lines
|
|
Ctrl + Shift + W
|
Underscore
|
|
Ctrl + D
|
Font
|
|
Ctrl + Shift + A
|
Change Text Capital Letter
|
|
Ctrl + Shift + K
|
Change Text Small Letter
|
|
Ctrl + Z
|
Undo
|
|
Ctrl + Y
|
Redo
|
|
Ctrl + Shift + D
|
Insert Current Date
|
|
Ctrl + Shift + T
|
Insert Current Time
|
|
Ctrl + W
|
Close File
|
|
Alt + Backspace
|
Undo
|
|
Alt + F5
|
App Restore
|
|
Ctrl + Shift + B
|
Bold
|
|
Shift + F3
|
Change Cases
|
|
Ctrl + Insert
|
Copy
|
|
Ctrl + F10
|
Document Maximize
|
|
Ctrl + F5
|
Document Restore
|
|
Alt + Shift + R
|
Edit
|
|
Ctrl + Shift + F
|
Font
|
|
F5
|
Go to
|
|
Ctrl + M
|
Increase Indent
|
|
Ctrl + Shift + M
|
Decrease Indent
|
|
Ctrl + Shift + N
|
Normal Style
|
|
Ctrl + F12
|
Open
|
|
Alt + T + O
|
Option Menu
|
|
Ctrl + Alt + F2
|
Open
|
|
Alt + Tab
|
Switch Window
|
|
Shift + F8
|
Select Multiple Area
|
|
Ctrl + F1
|
Show / Hide Ribbon Menu
|
|
Shift + F2
|
Insert Comment
|
|
Editing Cells
|
|
|
F2
|
Edit Cell
|
|
Dell
|
Delete Cell
|
|
Ctrl + Shift + ;
|
Insert Current Time
|
|
Ctrl + ;
|
Insert Current Date
|
|
Alt + A + E
|
Text to Column
|
|
Ctrl Function Key
|
|
|
Ctrl + A
|
Select All
|
|
Ctrl + D
|
Fill Down
|
|
Ctrl + R
|
Fill Right
|
|
Ctrl + F
|
Find
|
|
Ctrl + H
|
Replace
|
|
Ctrl + E
|
Flash Fill
|
|
Ctrl + F2
|
Print Preview
|
|
Ctrl + F4
|
Close Window
|
|
Ctrl + [
|
Go to Precedent Cell
|
|
Ctrl + ]
|
Go to Dependent Cell
|
|
Ctrl + Space
|
Select Column
|
|
Ctrl + ‘
|
Color Cycle
|
|
Ctrl + ,
|
Increase Decimal
|
|
Ctrl + .
|
Decrease Decimal
|
|
Ctrl + F3
|
Display “Name” Box
|
|
Alt Function Key
|
|
|
Alt + N +V
|
Insert Pivot Table
|
|
Alt + D + T
|
Insert A Data Table
|
|
Alt + D + S
|
Short A Table
|
|
Alt + A + T
|
Auto Filter Selection
|
|
Alt + H + O + I
|
Fit Column Width
|
|
Alt + I + W
|
Insert Worksheet
|
|
Alt + H + O + R
|
Change Tab Name
|
|
Alt + H + O + M
|
Move / Copy a Tab
|
|
Alt + M + A + A
|
Remove Tracing Arrows
|
|
Alt + R + G
|
Track Change
|
|
Alt + M + V
|
Evaluate Formula
|
|
Alt + W + G
|
Zoom to Selection
|
|
Alt + M + P
|
Trace Immediate Dependents
|
|
Alt + W + S
|
Split Screen
|
|
Alt + F + T
|
Excel Options
|
|
Alt + I + F
|
Display “Insert Function” Box
|
|
Shift Function Keys
|
|
|
Shift + F1
|
Reveal Formatting
|
|
Shift + F2
|
Write Comment
|
|
Shift + F3
|
Insert Function
|
|
Shift + F4
|
Go to Action
|
|
Shift + F5
|
Find and Replace
|
|
Shift + F6
|
Go to Previous Frame
|
|
Shift + F7
|
Choose Thesaurus Command
|
|
Shift + F8
|
Shrink Selection
|
|
Shift + F9
|
Add Selection
|
|
Shift + F10
|
Display Shortcut Menu
|
|
Shift + F11
|
Insert New Sheet
|
|
Shift + F12
|
Choose Save Command
|
|
Ctrl + Shift Function Key
|
|
|
Ctrl + Shift + F3
|
Insert Content of Spike
|
|
Ctrl + Shift + F5
|
Edit Bookmark
|
|
Ctrl + Shift + F6
|
Go to Previous Window
|
|
Ctrl + Shift + F7
|
Update Link
|
|
Ctrl + Shift + F8
|
Extend Selection
|
|
Ctrl + Shift + F9
|
Unlink Field
|
|
Ctrl + Shift + F11
|
Unlock Field
|
|
Ctrl + Shift + F12
|
Print Command
|
|
Function Key
|
|
|
F1
|
Help
|
|
F9
|
Recalculate all workbooks
|
|
F4
|
Anchor “Fix” Cells
|
|
F5
|
Go to Command
|
|
Ctrl + Shift Function Key
|
|
|
Ctrl + Shift + F
|
Increase Font Size
|
|
Ctrl + Shift + G
|
Decrease Font Size
|
|
Ctrl + Shift + C
|
Center Cycle
|
|
Ctrl + Shift + H
|
Horizontal Cycle
|
|
Ctrl + Shift + V
|
Vertical Cycle
|
|
Ctrl + Shift + I
|
Indent Cycle
|
|
Ctrl + Shift + B
|
Border Cycle
|
|
Ctrl + Shift + 7
|
Border Outline
|
|
Ctrl + Shift + -
|
Border None
|
|
Ctrl + Shift + 4
|
Currency cycle
|
|
Ctrl + Shift + 5
|
Percent Cycle
|
|
Ctrl + Shift + 6
|
Multiple Cycle
|
|
Ctrl + Shift + K
|
Fill Color Cycle
|
|
Ctrl + Shift + S
|
General Settings
|
|
Ctrl + Shift + U
|
Underline Cycle
|
|
Ctrl + Shift + W
|
Wrap Text
|
|
Ctrl + Shift + Y
|
Switches Cycle
|
|
Ctrl + Shift + ]
|
Power Trace Precedents
|
|
Ctrl + Shift + [
|
Power Trace Dependents
|
|
Ctrl + Shift + R
|
Power Fill Right
|
|
Ctrl + Alt + Shift + Function Key
|
|
|
Ctrl + Alt + Shift + N
|
Disable F1 Key
|
|
Ctrl + Alt + Shift + P
|
Print Shortcuts
|
|
Ctrl + Alt + Shift + S
|
Shortcut Manager
|
|
Ctrl + Alt + Shift + L
|
List Cycle
|
|
Ctrl + Alt + Shift + ,
|
Go to Minimum
|
|
Alt + Shift Function Key
|
|
|
Alt + Shift + S
|
Quick Save
|
|
Alt + Shift + G
|
Gridlines Toggle
|
|
Alt + Shift + ,
|
Shift Decimal Left
|
|
Alt + Shift + C
|
Case Cycle
|
Instagram page-https://www.instagram.com/technologyhours/
Facebook page-
