Microsoft Excel Shortcut Keys

Microsoft Excel Shortcut Keys

Excel Shortcut Keys

Microsoft Excel Shortcut Keys

Shortcut Action
Shift + SpaceSelect Entire Row
Ctrl + SpaceSelect Entire Column
Ctrl + Shift + +Insert New Row
Ctrl + -Delete Selected Row/Column
Ctrl + ZUndo Last Action
Ctrl + YRedo Last Action
Ctrl + SSave Workbook
Ctrl + OOpen Workbook
Ctrl + NCreate New Workbook
Ctrl + WClose Workbook
Ctrl + CCopy
Ctrl + VPaste
Ctrl + XCut
Ctrl + BBold Text
Ctrl + IItalicize Text
Ctrl + UUnderline Text
Ctrl + ;Insert Current Date
Ctrl + Shift + :Insert Current Time
Alt + H + O + IAutoFit Column Width
Ctrl + 0Hide Column
Ctrl + 9Hide Row
Ctrl + `Display All Formulas
Ctrl + TCreate Table
Ctrl + Page DownMove to Next Worksheet
Ctrl + Page UpMove to Previous Worksheet
Ctrl + FFind
Ctrl + HReplace
Ctrl + ASelect Entire Worksheet
Alt + =Sum Selected Range
Ctrl + Shift + &Add Border
Ctrl + 1Open Format Cells Dialog
Alt + W + F + FFreeze Panes
Ctrl + GOpen Go To Dialog
Ctrl + F3Open Name Manager
Ctrl + Shift + LAdd Filter
Shift + F2Insert Comment
Shift + F10 + MInsert/Delete Comment
Ctrl + POpen Print Dialog
Alt + F1Create Chart
Shift + F3Insert Function
Alt + EnterAdd New Line in Cell
F7Spell Check
Alt + F5Refresh Data in Pivot Table
Alt + H + B + AApply Border
Alt + H + M + CMerge & Center
Alt + F4Close Excel
Ctrl + KInsert a Hyperlink
F2Edit a Cell
Ctrl + Shift + Left ArrowSelect All Cells to the Left
Ctrl + Shift + Right ArrowSelect All Cells to the Right

Post a Comment

Previous Post Next Post