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
Print WorkbookCtrl + P
Open Print Preview WindowCtrl + F2
Close Current WorkbookCtrl + F4
Repeat Last ActionF4

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 Undeline formattingCtrl + U +  + 
Apply or Remove Strikethrough formattingCtrl + 5
Align CenterAlt + H + A + C
Align RightAlt + H + A + R
Align LeftAlt + H + A + L
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 + _

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

Videos Explaining Keyboard Shortcuts in Excel

21 Keyboard Shortcuts for Beginners

25 Advanced Excel Shortcuts