Navigation│Data Functions│Formatting│Function│Ribbon│Selection│Worksheet

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

To check shortcuts by major keys, please see here.

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

What to doShortcuts
Move one screen to the rightAlt + PageDown
Move one screen to the leftAlt + PageUp
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 beginning of a worksheetCtrl + Home
Move to the last cell in useCtrl + End
Display "Find and Replace" dialog boxCtrl + F
Display "Find and Replace" dialog boxCtrl + H
Move to the next sheetCtrl + PageDown
Move to the previous sheetCtrl + PageUp
Extend selection to the last used cellCtrl + Shift + End
Return to the previous windowCtrl + Shift + F6
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 bottom-right corner of the windowScroll Lock, End
Move to the upper-left corner of the windowScroll Lock, Home
Activate previous workbook or toolbarShift + Ctrl + Tab
Find next blank cellShift + F4
Display "Find and Replace" dialog boxShift + F5
Move to the cell in frontShift + Tab
Move one cell up↑
Move one cell down↓
Move one cell left←
Move one cell right→
Move to the beginning of a rowHome
Move one screen downPageDown
Move one screen upPageUp
Move one cell to the right.Tab

2. Data Function

What to doShortcuts
AutoSum the numbersAlt + =
Create an embedded chartAlt + F1
Open Macro dialog boxAlt + F8
Open the Microsoft Visual Basic for ApplicationsAlt + F11
Define a name to use in referencesAlt + M, M, D
Display the menu for Error CheckingAlt + Shift + F10
Display "Insert" dialog boxCtrl + +
Select the current data or entire worksheetCtrl + A
Copy topmost cell into the cells belowCtrl + D
Recognize patterns and Flash Fill columnsCtrl + E
Display "Go to" dialog boxCtrl + G
Calculate worksheets in all open workbooksCtrl + Alt + F9
Check formulas and calculate all cellsCtrl + Alt + Shift + F9
Move to the last cell in useCtrl + End
Display "Name Manager" dislog boxCtrl + F3
Inset a new Macro sheetCtrl + F11
Copy the value from the cell aboveCtrl + Shift + "
Select the current data rangeCtrl + Shift + *
Insert argument names and parenthesesCtrl + Shift + A
Extend selection to the last used cellCtrl + Shift + End
Create name using row and column labelsCtrl + Shift + F3
Expand or collapse the formula barCtrl + Shift + U
Display "Insert Function" dialog boxShift + F3
Calculate the active worksheetShift + F9
Remove cell contentsDelete
Turn "End" mode on or offEnd
Complete an entry and select the cell belowEnter
Cancel an entry in the cell or Formula BarEsc
Create a chart in a separate sheetF11
Move cursor to the end of contentsF2
Display "Paste Name" dialog boxF3
Calculate all open workbooks (manual model)F9

3. Formatting Function

What to doShortcuts
Format Style dialog boxAlt + '
Copy a formula from the cell aboveCtrl + '
Open "Delete" dialog boxCtrl + –
Enter the current dateCtrl + ;
Switch displaying cell values or formulasCtrl + `
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
Display "Paste Special" dialog boxCtrl + Alt + V
Bold text or remove bold formattingCtrl + B
Copy the selected cellsCtrl + C
Copy topmost cell into the cells belowCtrl + D
Apply or remove italic formattingCtrl + I
Create or edit a hyperlinkCtrl + K
Display "Create Table" dialog boxCtrl + L
Display "Quick Analysis" optionsCtrl + Q
Use the Fill Right commandCtrl + R
Display "Create Table" dialog boxCtrl + T
Apply or remove underline formatingCtrl + U
Paste contentCtrl + V
Move the selected cellsCtrl + X
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 + )
Enter the current timeCtrl + Shift + :
Apply the Time formatCtrl + Shift + @
Apply the Scientific number formatCtrl + Shift + ^
Remove the outline borderCtrl + Shift + _
Apply the General formatCtrl + Shift + ~
Display "Insert" dialog boxCtrl + Shift + +
Unhide selected columnsCtrl + Shift + 0
Format number in comma format.Ctrl + Shift + 1
Format number in time format.Ctrl + Shift + 2
Format number in date format.Ctrl + Shift + 3
Format number in currency format.Ctrl + Shift + 4
Format number in percentage format.Ctrl + Shift + 5
Format number in scientific format.Ctrl + Shift + 6
Border around selectionCtrl + Shift + 7
Display "Format Cells" dialog boxCtrl + Shift + F
Display "Format Cells" dialog boxCtrl + Shift + P
Add or edit a cell commentShift + F2
Display the shortcut menuShift + F10
Move cursor to the end of contentsF2
Display "Spelling" dialog boxF7

4. Function

What to doShortcuts
Display the Excel Help task paneF1
Move cursor to the end of contentsF2
Display "Paste Name" dialog boxF3
Cycle through absolute and relative references in a formulaF4
Displays "Go To" dialog boxF5
Switches between worksheet, ribbon, task pane and Zoom controlsF6
Display "Spelling" dialog boxF7
Turn extend mode on/off for a adjacent selectionF8
Calculate all worksheets (manual model)F9
Select active Ribbon tabF10
Create a chart in a separate sheetF11
Displays "Save As" dialog boxF12

5. Ribbon Function

What to doShortcuts
Open the dropdown menuAlt + ↓
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
Save AsAlt + F2
Center align cell contentsAlt + H, A, C
Add bordersAlt + H, B
Delete columnAlt + H, D, C
Choose a fill colorAlt + H, H
Save the workbookAlt + Shift F2
Display or hide the ribbonCtrl + F1
Display "Print" windowCtrl + F2
Display "File Open" dialog boxCtrl + F12
Display "Print" windowCtrl + P
Display "Print" windowCtrl + Shift + F12
Clear the content of the active cellBackspace
Select active Ribbon tabAlt
Select active Ribbon tabF10

6. Selection Function

What to doShortcuts
Switches to Page Break Preview viewAlt, W, I
Switches to Normal viewAlt, W, L
Switches to Page Layout viewAlt, W, P
Select the visible cellsAlt + ;
Start a new line in the same cellAlt + Enter
Select the current range around the active cellCtrl + *
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 + \
Select the current data or entire worksheetCtrl + A
Repeat the last command or action, if possibleCtrl + Y
Undo the last actionCtrl + Z
Fill selected range with the current entryCtrl + Enter
Select the current data rangeCtrl + 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 + |
Extend selection up to the first nonblank cellCtrl + Shift + ↑
Extend selection down to the last nonblank cellCtrl + Shift + ↓
Extend selection left to the first nonblank cellCtrl + Shift + ←
Extend selection right to the last nonblank cellCtrl + Shift + →
Extend selection to the current rangeCtrl + Shift + 8
Unhide selected rowsCtrl + Shift + 9
Select cells with commentsCtrl + Shift + O
Extend selection to the beginningCtrl + Shift + Home
Select the same cell in the next sheetCtrl + Shift + PageDown
Select the same cell in the previous sheetCtrl + Shift + PageUp
Select the current data range or the entire worksheetCtrl + Shift + Spacebar
Select an entire column in a worksheetCtrl + Spacebar
Select an entire row in a worksheetShift + Spacebar
Extend selection by one cell upShift + ↑
Extend selection by one cell downShift + ↓
Extend selection by one cell leftShift + ←
Extend selection by one cell rightShift + →
Extend selection to non-adjacent cells or rangesShift + F8
Select the active cell when multiple cells selectedShift + Backspace
Complete an entry and select the cell aboveShift + Enter
Move to the beginning of a rowHome
Select additional functions or informationShift
Activate a selected button.Spacebar

7. Worksheet Function

What to doShortcuts
Closes ExcelAlt + F4
Inserts a new worksheetAlt + Shift + F1
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
Create a new workbookCtrl + N
Open a spreadsheetCtrl + O
Save a spreadsheetCtrl + S
Close a spreadsheetCtrl + W
Switches to the next workbook or the next tab in dialog boxCtrl + Tab
Switch between Worksheet, Zoom controls, Task pane and RibbonShift + F6
Insert a new worksheetShift + F11
Save the workbookShift + F12