Keyboard Shortcuts in Excel

Excel Shortcuts

There are 200+ Keyboard Shortcuts in Excel and they are listed below. Learning all these shortcuts will not be easy, but I encourage you to practice as much as you can. Good Luck!

File

Create a New WorkbookCtrl + N
Open an existing WorkbookCtrl + O
Save WorkbookCtrl + S
Save Workbook asF12
Print WorkbookCtrl + P
Open Print Preview WindowCtrl + F2
Close Current WorkbookCtrl + F4
Close all WorkbooksShift + click on Close button

General

Select AllCtrl + A
Undo last actionCtrl + Z
Redo last actionCtrl + Y
Copy selected cellsCtrl + C
Cut Selected cellsCtrl + X
Paste content from clipboardCtrl + V
Display Paste Special dialogCtrl + Alt + V
Find and ReplaceCtrl + F
ReplaceCtrl + H
Toggle Auto FilterCtrl + Shift + L
Select entire column/columnsCtrl + Space
Find Previous MatchCtrl + Shift + F4
Open optionsAlt + F + T
Display Auto-Complete listAlt + ↓
Display modify Cell Style DialogAlt + ‘
Display Control MenuALT + SPACE
Display convert text to column dialogALT + A + E
Move to Next PaneF6
Make a CopyCtrl + Drag and Drop
Insert a copyCtrl + Shift + Drag and Drop

Selection

Add cell/cells/data ranges to selectionCtrl + Click (left mouse button)
Select a Entire worksheetCtrl + A + A
Select entire column/columnsCtrl + Space
Toggle through non adjacent Selection (towards Left)Ctrl + Alt + ←
Toggle through non adjacent Selection (towards Right)Ctrl + Alt + →
Show activecell on the worksheetCtrl + Back Space
Toggle through edges of selection (Clockwise direction)Ctrl + .
Extend selection to the top cellCtrl + Shift + ↑
Extend selection to the bottom cellCtrl + Shift + ↓
Extend selection to the last cell on leftCtrl + Shift + ←
Extend selection to the last cell on rightCtrl + Shift + →
Extend selection to first cell in the worksheetCtrl + Shift + Home
Extend selection to last used cell in the worksheetCtrl + Shift + End
Select entire Row/RowsShift + Space
Swap or Insert Cells/Rows/ColumnsShift + Drag and Drop
Toggle add to Selection ModeShift + F8
Select Active Cell onlyShift + Back Space
Move active cell up in selectionShift + Enter
Move active cell left in selectionShift + Tab
Extend Selection by one cell/row upShift + ↑
Extend Selection by one cell/row downShift + ↓
Extend Selection by one cell/row rightShift + →
Extend Selection by one cell/row leftShift+ ←
Extend selection up to the first cell of the rowShift + Home
Extend selection to next page on right sideAlt + Shift + Page Down
Extend selection to next page on left sideAlt + Shift+ Page Up
Move one cell down (in selection)Enter
Move one cell right (in selection)TAB
Toggle through Extend Selection ModeF8

Select Special

Select all visible cellsAlt + ;
Display Go To dialogCtrl + G
Select cells with commentsCtrl + Shift + O
Select current region around Active CellCtrl + Shift + *
Select current ArrayCtrl + \
Select Row differencesCtrl + /
Select Column differencesCtrl + Shift + |

Workbook

Go to Next workbookCtrl + Tab
Go to previous workbookCtrl + Shift + Tab
Minimize Current workbook windowCtrl + F9
Maximize Current workbook windowCtrl + F10
Previous windowCtrl + Shift + F6

Worksheet

Delete Active WorksheetAlt + H + D + S
Display Move or Copy dialogAlt + E + M
Insert New WorksheetShift + F11
Select adjacent WorksheetsShift + Click (left mouse button)
Create a copy of a worksheetCtrl + Drag and Drop

Sort & Filter

Advanced FilterAlt + A + Q
Sort Smallest to LargestAlt + H + S + S
Sort Largest to SmallestAlt + H + S + O
Displays Sort Dialog BoxAlt + H + S + U

Rows & Columns

Display Insert dialogCtrl + Shift + +
Display Delete dialogCtrl + –
Hide ColumnsCtrl + 0
Hide RowsCtrl + 9
Unhide ColumnsCtrl + Shift + 0
Unhide RowsCtrl + Shift + +
Show or hide outline symbolsCtrl + 8

Pivot Table

Open Pivot table wizardAlt + D + P
Hide Pivot Table valueCtrl + –

Excel Ribbon

Expand/Collapse RibbonCtrl + F1
Activate Access KeysALT

Macro (VBA)

Open Macros dialogAlt + F8
Open VBA EditorAlt + F11
Record MacroAlt + W + M + R

Grouping

Group Columns or RowsALT + Shift + →
Ungroup Columns or RowsALT + Shift + ←
Open Group Dialog BoxALT + Shift + →
Open Ungroup Dialog BoxALT + Shift + ←

Comments

Insert/Edit CommentShift + F2
Select cells with commentsCtrl + Shift + O

Navigation

Move to Top edge of Data regionCtrl + ↑
Move to Bottom edge of Data regionCtrl+ ↓
Move to right edge of Data regionCtrl + →
Move to left edge of Data regionCtrl + ←
Move to First cell of a worksheetCtrl + HOME
Move to last cell used in a worksheetCtrl + END
Move one page to RightAlt + PAGE DOWN
Move one page to LeftAlt + PAGE UP
Go back to HyperlinkCtrl + G + ENTER
Go to Excel Name BoxAlt + F3
Go To DialogF5

Worksheet Navigation

Go to Next worksheetCtrl + PAGE DOWN
Go to Previous worksheetCtrl + PAGE UP

Table

Insert TableCtrl + T
Insert TableCtrl + L
Apply/Toggle FilterCtrl + Shift + L
Apply/Toggle Total RowCtrl + Shift + T
Activate FilterAlt + ↓
Select TableCtrl + A
Select Entire ColumnCtrl + Space
Select Entire RowShift + Space

Formula

Select direct precedentsCtrl + [
Select all precedentsCtrl + Shift + {
Select direct dependentsCtrl + ]
Select all dependentsCtrl + Shift + }
Open insert function dialogShift + F3
Calculate active worksheetShift + F9
Accept function with AutoCompleteTab
Auto sum selected cellsAlt + =
Show formulasCtrl + `
Insert function argumentsCtrl + Shift + A
Enter Array FormulaCtrl + Shift + Enter
Force calculate all worksheetsCtrl + Alt + F9
Expand/Collapse Formula barCtrl + Shift + U
Display function arguments dialog boxCtrl + A
Define nameCtrl + F3
Define name using Row and Column LabelsCtrl + Shift + F3
Toggle Absolute, Mixed and Relative ReferencesF4
Calculate worksheets/Evaluate a formulaF9
Paste a Name into a formulaF3

Cell Editing

Edit Active cellF2
Line Break/Start a new line in the cellAlt + Enter
Move one word leftCtrl + ←
Move one word rightCtrl + →
Select one word leftCtrl + Shift + ←
Select one word rightCtrl + Shift + →
Confirm Entry and Stay in the cellCtrl + ENTER
Enter the same data into Multiple cellsCtrl + ENTER
Add commentShift + F2
Select one character rightShift + →
Select one character leftShift + ←
Select up to Beginning of a cellShift + HOME
Select up to End of a cellShift + END
Move up one cell in selectionShift + ENTER
Move left one cell in selectionShift + TAB +  + 
Create a chart in a new worksheetF11 +  +  + 
Enable or Disable End modeEND +  +  + 

Data Entry

Enter current date into a cellCtrl + ;
Enter current time into a cellCtrl + Shift + :
Fill down from the top cell in the selectionCtrl + D
Fill right from the cell on leftmost cell in the selectionCtrl + R
Copy formula/content from the above cellCtrl + ‘
Copy value from the above cellCtrl + Shift + “
Add HyperlinkCtrl + K
Flash FillCtrl + E
Cancel EntryESCAPE
Confirm Entry and move to righTAB
Paste as valuesAlt + H + V + V

Chart

Create Embedded ChartAlt + F1
Insert Chart as a Separate SheetF11

Dialog Box

Move to next TabCtrl + Tab
Move to previous TabCtrl + Shift + Tab
Find Next Match (after closing Find Dialog)Shift + F4
Move to next control (any Dialog box)Shift + TAB
Open Thesaurus Dialog box)Shift + F7
Display Right click menuShift + F10
Save as DialogF12
HelpF1
Open Spelling DialogF7

Apply Number Formatting

General FormatCtrl + Shift + ~
Currency FormatCtrl + Shift + $
Percentage FormatCtrl + Shift + %
Scientific FormatCtrl + Shift + ^
Date FormatCtrl + Shift + #
Time FormatCtrl + Shift + @
Number FormatCtrl + Shift+ !

Formatting

Display Format Cells dialogCtrl + 1
Display Format Cells dialog with Font tab selectedCtrl + SHIFT + 1
Apply or Remove Bold formattingCtrl + B +  + 
Apply or Remove Italic formattingCtrl + I +  + 
Apply or Remove Underline formattingCtrl + U +  + 
Apply or Remove Strikethrough formattingCtrl + 5
Align contents to CenterAlt + H + A + C
Align contents to RightAlt + H + A + R
Align contents to LeftAlt + H + A + L
Increase IndentAlt + H + 6 + 
Remove IndentAlt + H + 5 + 
Increase Font size one stepAlt + H + F + G
Decrease Font size one stepAlt + H + F + K
Add Border OutlineCtrl + Shift + &
Remove Border OutlineCtrl + Shift + _
Apply all bordersAlt + H + B + A

Display

Zoom DialogAlt + W + Q
Zoom inCtrl + Alt+ +
Zoom outCtrl + Alt+ –
Full screenCtrl + Shift + F1
Move to previous pane (Split pane)Shift + F6

Objects

Span to Grid (with Objects)Alt
Duplicate Object (with objects)Ctrl + D
Hide and Show ObjectsCtrl + 6
Object PaneAlt+ F10

Read more about Excel Shortcuts…

Functions keys and Excel Shortcuts

Crtl Key Shortcuts in Excel

Shift key Shortcuts in Excel

Lesser-known Excel shortcuts

Videos Explaining Keyboard Shortcuts in Excel

21 Keyboard Shortcuts for Beginners

25 Advanced Excel Shortcuts