NumberPunctuationLetterArrowFunctionAltCtrlShiftHomeEndSpacebarTab

Below is a listing of 212 shortcuts commonly used in Microsoft Excel, listed by major keys.

To check shortcuts listed by function, please see here.

To check 30 most useful shortcuts in Excel, please see here.

1. Number Shortcuts

What to doShortcuts
Hide the selected columnsCtrl + 0
Display "Format Cells" dialog boxCtrl + 1
Bold text or remove bold formattingCtrl + 2
Italicize text or remove italic formattingCtrl + 3
Underline text or remove underlineCtrl + 4
Apply or remove strikethrough formattingCtrl + 5
Hiding and displaying objectsCtrl + 6
Display or hide the outline symbolsCtrl + 8
Hide the selected rowsCtrl + 9
Unhide selected columnsCtrl + Shift + 0
Format number in comma formatCtrl + Shift + 1
Format number in time formatCtrl + Shift + 2
Format number in date formatCtrl + Shift + 3
Format number in currency formatCtrl + Shift + 4
Format number in percentage formatCtrl + Shift + 5
Format number in scientific formatCtrl + Shift + 6
Border around selectionCtrl + Shift + 7
Extend selection to the current rangeCtrl + Shift + 8
Unhide selected rowsCtrl + Shift + 9

2. Punctuation Shortcuts

What to doShortcuts
Format Style dialog boxAlt + '
Select the visible cellsAlt + ;
AutoSum the numbersAlt
Copy a formula from the cell aboveCtrl + '
Open "Delete" dialog boxCtrl + –
Select the current range around the active cellCtrl + *
Enter the current dateCtrl + ;
Select cells directly referenced by formulasCtrl + [
Select cells with formulas that refer to active cellCtrl + ]
Select cells that don't match the formula or static valueCtrl + \
Switch displaying cell values or formulasCtrl + `
Display "Insert" dialog boxCtrl + +
Apply the Number formatCtrl + Shift + !
Copy the value from the cell aboveCtrl + Shift + "
Copy the value from the cell aboveCtrl + Shift + "
Apply the Date formatCtrl + Shift + #
Apply the Currency formatCtrl + Shift + $
Apply the Percentage formatCtrl + Shift + %
Apply an outline borderCtrl + Shift + &
Unhide the selected rowsCtrl + Shift + (
Unhide the selected columnsCtrl + Shift + )
Select the current data rangeCtrl + Shift + *
Enter the current timeCtrl + Shift + :
Apply the Time formatCtrl + Shift + @
Apply the Scientific number formatCtrl + Shift + ^
Remove the outline borderCtrl + Shift + _
Select all cells referenced by formulasCtrl + Shift + {
Select cells with formulas that refer the active cellCtrl + Shift + }
Select cells that don't match the formula or static valueCtrl + Shift + |
Apply the General formatCtrl + Shift + ~
Display "Insert" dialog boxCtrl + Shift + +

3. Letter Shortcuts

What to doShortcuts
Go to Data tabAlt + A
Open the File pageAlt + F
Go to the Home tabAlt + H
Go to Formula tabAlt + M
Go to Insert tabAlt + N
Go to Page Layout tabAlt + P
Open the "Tell me" boxAlt + Q
Open the Review tabAlt + R
Open the View tabAlt + W
Select the current data or entire worksheetCtrl + A
Bold text or remove bold formattingCtrl + B
Copy the selected cellsCtrl + C
Copy topmost cell into the cells belowCtrl + D
Recognize patterns and Flash Fill columnsCtrl + E
Display "Find and Replace" dialog boxCtrl + F
Display "Go to" dialog boxCtrl + G
Display "Find and Replace" dialog boxCtrl + H
Apply or remove italic formattingCtrl + I
Create or edit a hyperlinkCtrl + K
Display "Create Table" dialog boxCtrl + L
Create a new workbookCtrl + N
Open a spreadsheetCtrl + O
Display "Print" windowCtrl + P
Display "Quick Analysis" optionsCtrl + Q
Use the Fill Right commandCtrl + R
Save a spreadsheetCtrl + S
Display "Create Table" dialog boxCtrl + T
Apply or remove underline formatingCtrl + U
Paste contentCtrl + V
Close a spreadsheetCtrl + W
Move the selected cellsCtrl + X
Repeat the last command or action, if possibleCtrl + Y
Undo the last actionCtrl + Z
Display "Paste Special" dialog boxCtrl + Alt + V
Insert argument names and parenthesesCtrl + Shift + A
Display "Format Cells" dialog boxCtrl + Shift + F
Select cells with commentsCtrl + Shift + O
Display "Format Cells" dialog boxCtrl + Shift + P
Expand or collapse the formula barCtrl + Shift + U

4. Arrow Shortcuts

What to doShortcuts
Open the dropdown menuAlt + ↓
Move to the top edge of the data rangeCtrl + ↑
Extend selection up to the first nonblank cellCtrl + Shift + ↑
Move to the bottom of current dataCtrl + ↓
Move to left edge of current dataCtrl + ←
Move to the right edgeCtrl + →
Extend selection down to the last nonblank cellCtrl + Shift + ↓
Extend the selection left to the first nonblank cellCtrl + Shift + ←
Extend selection right to the last nonblank cellCtrl + Shift + →
Move to the top nonblank cellEnd, ↑
Move to the bottom nonblank cellEnd, ↓
Move to the last left nonblank cellEnd, ←
Move to the last right nonblank cellEnd, →
Extend selection by one cell upShift + ↑
Extend selection by one cell downShift + ↓
Extend selection by one cell leftShift + ←
Extend selection by one cell rightShift + →
Move one cell up
Move one cell down in a worksheet
Move one cell left
Move one cell right

5. Function Shortcuts

What to doShortcuts
Display the Excel Help task paneF1
Create an embedded chartAlt + F1
Display or hide the ribbonCtrl + F1
Inserts a new worksheetAlt + Shift + F1
Move cursor to the end of contentsF2
Save AsAlt + F2
Display "Print" windowCtrl + F2
Add or edit a cell commentShift + F2
Save the workbookAlt + Shift + F2
Display "Paste Name" dialog boxF3
Display "Name Manager" dislog boxCtrl + F3
Display "Insert Function" dialog boxShift + F3
Create name using row and column labelsCtrl + Shift + F3
Cycle through absolute and relative referencesF4
Closes ExcelAlt + F4
Close selected workbook windowCtrl + F4
Find next blank cellShift + F4
Displays "Go To" dialog boxF5
Restore the size of the selected windowCtrl + F5
Display "Find and Replace" dialog boxShift + F5
Switches between worksheet, ribbon, task pane and Zoom controlsF6
Switch to next workbook windowCtrl + F6
Switch between Worksheet, Zoom controls, Task pane and RibbonShift + F6
Return to the previous windowCtrl + Shift + F6
Display "Spelling" dialog boxF7
Perform Move command when not maximized. Arrow keys to move and Enter or Esc key to cancelCtrl + F7
Turn extend mode on/off for a adjacent selectionF8
Open Macro dialog boxAlt + F8
Perform Size command when not maximizedCtrl + F8
Extend selection to non-adjacent cells or rangesShift + F8
Calculate worksheets in all open workbooks (manual calculation model)F9
Minimize a workbook to an iconCtrl + F9
Calculate the active worksheetShift + F9
Calculate worksheets in all open workbooksCtrl + Alt + F9
Check formulas and calculate all cellsCtrl + Alt + Shift + F9
Select active Ribbon tab (Alt key does the same work)F10
Maximize or restore workbook windowCtrl + F10
Display the shortcut menuShift + F10
Display the menu for Error CheckingAlt + Shift + F10
Create a chart in a separate sheetF11
Open the Microsoft Visual Basic for ApplicationsAlt + F11
Inset a new Macro sheetCtrl + F11
Insert a new worksheetShift + F11
Displays "Save As" dialog boxF12
Display "File Open" dialog boxCtrl + F12
Save the workbookShift + F12
Display "Print" windowCtrl + Shift + F12

6. Alt Shortcuts

What to doShortcuts
Format Style dialog boxAlt + '
Select the visible cellsAlt + ;
AutoSum the numbersAlt + =
Go to Data tabAlt + A
Open the File pageAlt + F
Go to the Home tabAlt + H
Go to Formula tabAlt + M
Go to Insert tabAlt + N
Go to Page Layout tabAlt + P
Open the "Tell me" boxAlt + Q
Open the Review tabAlt + R
Open the View tabAlt + W
Open the dropdown menuAlt + ↓
Start a new line in the same cellAlt + Enter
Create an embedded chartAlt + F1
Save AsAlt + F2
Closes ExcelAlt + F4
Open Macro dialog boxAlt + F8
Open the Microsoft Visual Basic for ApplicationsAlt + F11
Move one screen to the rightAlt + PageDown
Move one screen to the leftAlt + PageUp
Inserts a new worksheetAlt + Shift + F1
Save the workbookAlt + Shift + F2
Display the menu for Error CheckingAlt + Shift + F10
Calculate worksheets in all open workbooksCtrl + Alt + F9
Check formulas and calculate all cellsCtrl + Alt + Shift + F9
Display "Paste Special" dialog boxCtrl + Alt + V
Center align cell contentsAlt + H, A, C
Add bordersAlt + H, B
Delete columnAlt + H, D, C
Choose a fill colorAlt + H, H
Define a name to use in referencesAlt + M, M, D
Switches to Page Break Preview viewAlt + W, I
Switches to Normal viewAlt + W, L
Switches to Page Layout viewAlt, W, P

7. Ctrl Shortcuts

What to doShortcuts
Copy a formula from the cell aboveCtrl + '
Open "Delete" dialog boxCtrl + –
Select the current range around the active cellCtrl + *
Enter the current dateCtrl + ;
Select cells directly referenced by formulasCtrl + [
Select cells with formulas that refer to active cellCtrl + ]
In a selected row, select cells that don't match the formula or static valueCtrl + \
Switch displaying cell values or formulasCtrl + `
Display "Insert" dialog boxCtrl + +
Hide the selected columnsCtrl + 0
Display "Format Cells" dialog boxCtrl + 1
Bold text or remove bold formattingCtrl + 2
Italicize text or remove italic formattingCtrl + 3
Underline text or remove underlineCtrl + 4
Apply or remove strikethrough formattingCtrl + 5
Hiding and displaying objectsCtrl + 6
Display or hide the outline symbolsCtrl + 8
Hide the selected rowsCtrl + 9
Move to the top edge of the data rangeCtrl + ↑
Move to the bottom of current dataCtrl + ↓
Move to left edge of current dataCtrl + ←
Move to the right edgeCtrl + →
Move to the next sheetCtrl + PageDown
Move to the previous sheetCtrl + PageUp
Select the current data or entire worksheetCtrl + A
Bold text or remove bold formattingCtrl + B
Copy the selected cellsCtrl + C
Copy topmost cell into the cells belowCtrl + D
Recognize patterns and Flash Fill columnsCtrl + E
Display "Find and Replace" dialog boxCtrl + F
Display "Go to" dialog boxCtrl + G
Display "Find and Replace" dialog boxCtrl + H
Apply or remove italic formattingCtrl + I
Create or edit a hyperlinkCtrl + K
Display "Create Table" dialog boxCtrl + L
Create a new workbookCtrl + N
Open a spreadsheetCtrl + O
Display "Print" windowCtrl + P
Display "Quick Analysis" optionsCtrl + Q
Use the Fill Right commandCtrl + R
Save a spreadsheetCtrl + S
Display "Create Table" dialog boxCtrl + T
Apply or remove underline formatingCtrl + U
Paste contentCtrl + V
Close a spreadsheetCtrl + W
Move the selected cellsCtrl + X
Repeat the last command or action, if possibleCtrl + Y
Undo the last actionCtrl + Z
Display or hide the ribbonCtrl + F1
Display "Print" windowCtrl + F2
Display "Name Manager" dislog boxCtrl + F3
Close selected workbook windowCtrl + F4
Restore the size of the selected windowCtrl + F5
Switch to next workbook windowCtrl + F6
Perform Move command when not maximized. Arrow keys to move and Enter or Esc key to cancelCtrl + F7
Perform Size command when not maximizedCtrl F8
Minimize a workbook to an iconCtrl + F9
Maximize or restore workbook windowCtrl + F10
Inset a new Macro sheetCtrl + F11
Display "File Open" dialog boxCtrl + F12
Move to the beginning of a worksheetCtrl + Home
Move to the last cell in useCtrl + End
Fill selected range with the current entryCtrl + Enter
Select an entire column in a worksheetCtrl + Spacebar
Switches to the next workbook or the next tab in dialog boxCtrl + Tab
Calculate worksheets in all open workbooksCtrl + Alt + F9
Check formulas and calculate all cellsCtrl + Alt + Shift + F9
Display "Paste Special" dialog boxCtrl + Alt + V
Unhide selected columnsCtrl + Shift + 0
Format number in comma formatCtrl + Shift + 1
Format number in time formatCtrl + Shift + 2
Format number in date formatCtrl + Shift + 3
Format number in currency formatCtrl + Shift + 4
Format number in percentage formatCtrl + Shift + 5
Format number in scientific formatCtrl + Shift + 6
Border around selectionCtrl + Shift + 7
Extend selection to the current rangeCtrl + Shift + 8
Unhide selected rowsCtrl + Shift + 9
Apply the Number formatCtrl + Shift + !
Copy the value from the cell aboveCtrl + Shift + "
Copy the value from the cell aboveCtrl + Shift + "
Apply the Date formatCtrl + Shift + #
Apply the Currency formatCtrl + Shift + $
Apply the Percentage formatCtrl + Shift + %
Apply an outline borderCtrl + Shift + &
Unhide the selected rowsCtrl + Shift + (
Unhide the selected columnsCtrl + Shift + )
Select the current data rangeCtrl + Shift + *
Select the current data rangeCtrl + Shift + *
Enter the current timeCtrl + Shift + :
Apply the Time formatCtrl + Shift + @
Apply the Scientific number formatCtrl + Shift + ^
Remove the outline borderCtrl + Shift + _
Select all cells referenced by formulasCtrl + Shift + {
Select cells with formulas that refer the active cellCtrl + Shift + }
Apply the General formatCtrl + Shift + ~
Select cells that not match the formula or static valueCtrl + Shift + |
Display "Insert" dialog boxCtrl + Shift + +
Insert argument names and parenthesesCtrl + Shift + A
Display "Format Cells" dialog boxCtrl + Shift + F
Select cells with commentsCtrl + Shift + O
Display "Format Cells" dialog boxCtrl + Shift + P
Expand or collapse the formula barCtrl + Shift + U
Extend selection down to the last nonblank cellCtrl + Shift + ↓
Extend the selection left to the first nonblank cellCtrl + Shift + ←
Extend selection right to the last nonblank cellCtrl + Shift + →
Extend selection up to the first nonblank cellCtrl + Shift + ↑
Extend selection to the last used cellCtrl + Shift + End
Create name using row and column labelsCtrl + Shift + F3
Return to the previous windowCtrl + Shift + F6
Display "Print" windowCtrl + Shift + F12
Select the same cell in the next sheetCtrl + Shift + PageDown
Select the same cell in the previous sheetCtrl + Shift + PageUp
Extend selection to the beginningCtrl + Shift + Home
Select the current data range or the entire worksheetCtrl + Shift + Spacebar
Activate previous workbook or toolbarCtrl + Shift + Tab

8. Shift Shortcuts

What to doShortcuts
Extend selection by one cell upShift + ↑
Extend selection by one cell downShift + ↓
Extend selection by one cell leftShift + ←
Extend selection by one cell rightShift + →
Add or edit a cell commentShift + F2
Display "Insert Function" dialog boxShift + F3
Find next blank cellShift + F4
Display "Find and Replace" dialog boxShift + F5
Switch between Worksheet, Zoom controls, Task pane and RibbonShift + F6
Extend selection to non-adjacent cells or rangesShift + F8
Calculate the active worksheetShift + F9
Display the shortcut menuShift + F10
Insert a new worksheetShift + F11
Save the workbookShift + F12
Select an entire row in a worksheetShift + Spacebar
Select the active cell when multiple cells selectedShift + Backspace
Complete an entry and select the cell aboveShift + Enter
Move to the cell in frontShift + Tab
Inserts a new worksheetAlt + Shift + F1
Save the workbookAlt + Shift + F2
Display the menu for Error CheckingAlt + Shift + F10
Unhide selected columnsCtrl + Shift + 0
Format number in comma formatCtrl + Shift + 1
Format number in time formatCtrl + Shift + 2
Format number in date formatCtrl + Shift + 3
Format number in currency formatCtrl + Shift + 4
Format number in percentage formatCtrl + Shift + 5
Format number in scientific formatCtrl + Shift + 6
Border around selectionCtrl + Shift + 7
Extend selection to the current rangeCtrl + Shift + 8
Unhide selected rowsCtrl + Shift + 9
Apply the Number formatCtrl + Shift + !
Copy the value from the cell aboveCtrl + Shift + "
Apply the Date formatCtrl + Shift + #
Apply the Currency formatCtrl + Shift + $
Apply the Percentage formatCtrl + Shift + %
Apply an outline borderCtrl + Shift + &
Unhide the selected rowsCtrl + Shift + (
Unhide the selected columnsCtrl + Shift + )
Select the current data rangeCtrl + Shift + *
Select the current data rangeCtrl + Shift + *
Enter the current timeCtrl + Shift + :
Apply the Time formatCtrl + Shift + @
Apply the Scientific number formatCtrl + Shift + ^
Remove the outline borderCtrl + Shift + _
Select cells that not match the formula or static valueCtrl + Shift + |
Select all cells referenced by formulasCtrl + Shift + {
Select cells with formulas that refer the active cellCtrl + Shift + }
Apply the General formatCtrl + Shift + ~
Display "Insert" dialog boxCtrl + Shift + +
Extend selection down to the last nonblank cellCtrl Shift ↓
Extend the selection left to the first nonblank cellCtrl + Shift + ←
Extend selection right to the last nonblank cellCtrl + Shift + →
Extend selection up to the first nonblank cellCtrl + Shift + ↑
Insert argument names and parenthesesCtrl + Shift + A
Display "Format Cells" dialog boxCtrl + Shift + F
Select cells with commentsCtrl + Shift + O
Display "Format Cells" dialog boxCtrl + Shift + P
Expand or collapse the formula barCtrl + Shift + U
Extend selection to the beginningCtrl + Shift + Home
Extend selection to the last used cellCtrl + Shift + End
Create name using row and column labelsCtrl + Shift + F3
Return to the previous windowCtrl + Shift + F6
Display "Print" windowCtrl + Shift + F12
Select the same cell in the next sheetCtrl + Shift + PageDown
Select the same cell in the previous sheetCtrl + Shift + PageUp
Activate previous workbook or toolbarCtrl + Shift + Tab
Check formulas and calculate all cellsCtrl + Alt + Shift + F9

9. Home Shortcuts

What to doShortcuts
Move to the beginning of a worksheetCtrl + Home
Extend selection to the beginningCtrl + Shift + Home
Move to the upper-left corner of the windowScroll Lock + Home

10. End Shortcuts

What to doShortcuts
Move to the top nonblank cellEnd, ↑
Move to the bottom nonblank cellEnd, ↓
Move to the last left nonblank cellEnd, ←
Move to the last right nonblank cellEnd, →
Move to the last cell in useCtrl + End
Move to the bottom-right corner of the windowScroll Lock + End
Extend selection to the last used cellCtrl + Shift + End

11. Spacebar Shortcuts

What to doShortcuts
Select an entire column in a worksheetCtrl + Spacebar
Select an entire row in a worksheetShift + Spacebar
Select the current data range or the entire worksheetCtrl + Shift + Spacebar

12. Tab Shortcuts

What to doShortcuts
Switches to the next workbook or the next tab in dialog boxCtrl + Tab
Move to the cell in frontShift + Tab
Activate previous workbook or toolbarCtrl + Shift + Tab