Excel Shortcuts by Key

Number│Punctuation│Letter│Arrow│Function│Alt│Ctrl│Shift│Home│End│Spacebar│Tab

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 do	Shortcuts
Hide the selected columns	Ctrl + 0
Display "Format Cells" dialog box	Ctrl + 1
Bold text or remove bold formatting	Ctrl + 2
Italicize text or remove italic formatting	Ctrl + 3
Underline text or remove underline	Ctrl + 4
Apply or remove strikethrough formatting	Ctrl + 5
Hiding and displaying objects	Ctrl + 6
Display or hide the outline symbols	Ctrl + 8
Hide the selected rows	Ctrl + 9
Unhide selected columns	Ctrl + 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 selection	Ctrl + Shift + 7
Extend selection to the current range	Ctrl + Shift + 8
Unhide selected rows	Ctrl + Shift + 9

2. Punctuation Shortcuts

What to do	Shortcuts
Format Style dialog box	Alt + '
Select the visible cells	Alt + ;
AutoSum the numbers	Alt
Copy a formula from the cell above	Ctrl + '
Open "Delete" dialog box	Ctrl + –
Select the current range around the active cell	Ctrl + *
Enter the current date	Ctrl + ;
Select cells directly referenced by formulas	Ctrl + [
Select cells with formulas that refer to active cell	Ctrl + ]
Select cells that don't match the formula or static value	Ctrl + \
Switch displaying cell values or formulas	Ctrl + `
Display "Insert" dialog box	Ctrl + +
Apply the Number format	Ctrl + Shift + !
Copy the value from the cell above	Ctrl + Shift + "
Copy the value from the cell above	Ctrl + Shift + "
Apply the Date format	Ctrl + Shift + #
Apply the Currency format	Ctrl + Shift + $
Apply the Percentage format	Ctrl + Shift + %
Apply an outline border	Ctrl + Shift + &
Unhide the selected rows	Ctrl + Shift + (
Unhide the selected columns	Ctrl + Shift + )
Select the current data range	Ctrl + Shift + *
Enter the current time	Ctrl + Shift + :
Apply the Time format	Ctrl + Shift + @
Apply the Scientific number format	Ctrl + Shift + ^
Remove the outline border	Ctrl + Shift + _
Select all cells referenced by formulas	Ctrl + Shift + {
Select cells with formulas that refer the active cell	Ctrl + Shift + }
Select cells that don't match the formula or static value	Ctrl + Shift + |
Apply the General format	Ctrl + Shift + ~
Display "Insert" dialog box	Ctrl + Shift + +

3. Letter Shortcuts

What to do	Shortcuts
Go to Data tab	Alt + A
Open the File page	Alt + F
Go to the Home tab	Alt + H
Go to Formula tab	Alt + M
Go to Insert tab	Alt + N
Go to Page Layout tab	Alt + P
Open the "Tell me" box	Alt + Q
Open the Review tab	Alt + R
Open the View tab	Alt + W
Select the current data or entire worksheet	Ctrl + A
Bold text or remove bold formatting	Ctrl + B
Copy the selected cells	Ctrl + C
Copy topmost cell into the cells below	Ctrl + D
Recognize patterns and Flash Fill columns	Ctrl + E
Display "Find and Replace" dialog box	Ctrl + F
Display "Go to" dialog box	Ctrl + G
Display "Find and Replace" dialog box	Ctrl + H
Apply or remove italic formatting	Ctrl + I
Create or edit a hyperlink	Ctrl + K
Display "Create Table" dialog box	Ctrl + L
Create a new workbook	Ctrl + N
Open a spreadsheet	Ctrl + O
Display "Print" window	Ctrl + P
Display "Quick Analysis" options	Ctrl + Q
Use the Fill Right command	Ctrl + R
Save a spreadsheet	Ctrl + S
Display "Create Table" dialog box	Ctrl + T
Apply or remove underline formating	Ctrl + U
Paste content	Ctrl + V
Close a spreadsheet	Ctrl + W
Move the selected cells	Ctrl + X
Repeat the last command or action, if possible	Ctrl + Y
Undo the last action	Ctrl + Z
Display "Paste Special" dialog box	Ctrl + Alt + V
Insert argument names and parentheses	Ctrl + Shift + A
Display "Format Cells" dialog box	Ctrl + Shift + F
Select cells with comments	Ctrl + Shift + O
Display "Format Cells" dialog box	Ctrl + Shift + P
Expand or collapse the formula bar	Ctrl + Shift + U

4. Arrow Shortcuts

What to do	Shortcuts
Open the dropdown menu	Alt + ↓
Move to the top edge of the data range	Ctrl + ↑
Extend selection up to the first nonblank cell	Ctrl + Shift + ↑
Move to the bottom of current data	Ctrl + ↓
Move to left edge of current data	Ctrl + ←
Move to the right edge	Ctrl + →
Extend selection down to the last nonblank cell	Ctrl + Shift + ↓
Extend the selection left to the first nonblank cell	Ctrl + Shift + ←
Extend selection right to the last nonblank cell	Ctrl + Shift + →
Move to the top nonblank cell	End, ↑
Move to the bottom nonblank cell	End, ↓
Move to the last left nonblank cell	End, ←
Move to the last right nonblank cell	End, →
Extend selection by one cell up	Shift + ↑
Extend selection by one cell down	Shift + ↓
Extend selection by one cell left	Shift + ←
Extend selection by one cell right	Shift + →
Move one cell up	↑
Move one cell down in a worksheet	↓
Move one cell left	←
Move one cell right	→

5. Function Shortcuts

What to do	Shortcuts
Display the Excel Help task pane	F1
Create an embedded chart	Alt + F1
Display or hide the ribbon	Ctrl + F1
Inserts a new worksheet	Alt + Shift + F1
Move cursor to the end of contents	F2
Save As	Alt + F2
Display "Print" window	Ctrl + F2
Add or edit a cell comment	Shift + F2
Save the workbook	Alt + Shift + F2
Display "Paste Name" dialog box	F3
Display "Name Manager" dislog box	Ctrl + F3
Display "Insert Function" dialog box	Shift + F3
Create name using row and column labels	Ctrl + Shift + F3
Cycle through absolute and relative references	F4
Closes Excel	Alt + F4
Close selected workbook window	Ctrl + F4
Find next blank cell	Shift + F4
Displays "Go To" dialog box	F5
Restore the size of the selected window	Ctrl + F5
Display "Find and Replace" dialog box	Shift + F5
Switches between worksheet, ribbon, task pane and Zoom controls	F6
Switch to next workbook window	Ctrl + F6
Switch between Worksheet, Zoom controls, Task pane and Ribbon	Shift + F6
Return to the previous window	Ctrl + Shift + F6
Display "Spelling" dialog box	F7
Perform Move command when not maximized. Arrow keys to move and Enter or Esc key to cancel	Ctrl + F7
Turn extend mode on/off for a adjacent selection	F8
Open Macro dialog box	Alt + F8
Perform Size command when not maximized	Ctrl + F8
Extend selection to non-adjacent cells or ranges	Shift + F8
Calculate worksheets in all open workbooks (manual calculation model)	F9
Minimize a workbook to an icon	Ctrl + F9
Calculate the active worksheet	Shift + F9
Calculate worksheets in all open workbooks	Ctrl + Alt + F9
Check formulas and calculate all cells	Ctrl + Alt + Shift + F9
Select active Ribbon tab (Alt key does the same work)	F10
Maximize or restore workbook window	Ctrl + F10
Display the shortcut menu	Shift + F10
Display the menu for Error Checking	Alt + Shift + F10
Create a chart in a separate sheet	F11
Open the Microsoft Visual Basic for Applications	Alt + F11
Inset a new Macro sheet	Ctrl + F11
Insert a new worksheet	Shift + F11
Displays "Save As" dialog box	F12
Display "File Open" dialog box	Ctrl + F12
Save the workbook	Shift + F12
Display "Print" window	Ctrl + Shift + F12

6. Alt Shortcuts

What to do	Shortcuts
Format Style dialog box	Alt + '
Select the visible cells	Alt + ;
AutoSum the numbers	Alt + =
Go to Data tab	Alt + A
Open the File page	Alt + F
Go to the Home tab	Alt + H
Go to Formula tab	Alt + M
Go to Insert tab	Alt + N
Go to Page Layout tab	Alt + P
Open the "Tell me" box	Alt + Q
Open the Review tab	Alt + R
Open the View tab	Alt + W
Open the dropdown menu	Alt + ↓
Start a new line in the same cell	Alt + Enter
Create an embedded chart	Alt + F1
Save As	Alt + F2
Closes Excel	Alt + F4
Open Macro dialog box	Alt + F8
Open the Microsoft Visual Basic for Applications	Alt + F11
Move one screen to the right	Alt + PageDown
Move one screen to the left	Alt + PageUp
Inserts a new worksheet	Alt + Shift + F1
Save the workbook	Alt + Shift + F2
Display the menu for Error Checking	Alt + Shift + F10
Calculate worksheets in all open workbooks	Ctrl + Alt + F9
Check formulas and calculate all cells	Ctrl + Alt + Shift + F9
Display "Paste Special" dialog box	Ctrl + Alt + V
Center align cell contents	Alt + H, A, C
Add borders	Alt + H, B
Delete column	Alt + H, D, C
Choose a fill color	Alt + H, H
Define a name to use in references	Alt + M, M, D
Switches to Page Break Preview view	Alt + W, I
Switches to Normal view	Alt + W, L
Switches to Page Layout view	Alt, W, P

7. Ctrl Shortcuts

What to do	Shortcuts
Copy a formula from the cell above	Ctrl + '
Open "Delete" dialog box	Ctrl + –
Select the current range around the active cell	Ctrl + *
Enter the current date	Ctrl + ;
Select cells directly referenced by formulas	Ctrl + [
Select cells with formulas that refer to active cell	Ctrl + ]
In a selected row, select cells that don't match the formula or static value	Ctrl + \
Switch displaying cell values or formulas	Ctrl + `
Display "Insert" dialog box	Ctrl + +
Hide the selected columns	Ctrl + 0
Display "Format Cells" dialog box	Ctrl + 1
Bold text or remove bold formatting	Ctrl + 2
Italicize text or remove italic formatting	Ctrl + 3
Underline text or remove underline	Ctrl + 4
Apply or remove strikethrough formatting	Ctrl + 5
Hiding and displaying objects	Ctrl + 6
Display or hide the outline symbols	Ctrl + 8
Hide the selected rows	Ctrl + 9
Move to the top edge of the data range	Ctrl + ↑
Move to the bottom of current data	Ctrl + ↓
Move to left edge of current data	Ctrl + ←
Move to the right edge	Ctrl + →
Move to the next sheet	Ctrl + PageDown
Move to the previous sheet	Ctrl + PageUp
Select the current data or entire worksheet	Ctrl + A
Bold text or remove bold formatting	Ctrl + B
Copy the selected cells	Ctrl + C
Copy topmost cell into the cells below	Ctrl + D
Recognize patterns and Flash Fill columns	Ctrl + E
Display "Find and Replace" dialog box	Ctrl + F
Display "Go to" dialog box	Ctrl + G
Display "Find and Replace" dialog box	Ctrl + H
Apply or remove italic formatting	Ctrl + I
Create or edit a hyperlink	Ctrl + K
Display "Create Table" dialog box	Ctrl + L
Create a new workbook	Ctrl + N
Open a spreadsheet	Ctrl + O
Display "Print" window	Ctrl + P
Display "Quick Analysis" options	Ctrl + Q
Use the Fill Right command	Ctrl + R
Save a spreadsheet	Ctrl + S
Display "Create Table" dialog box	Ctrl + T
Apply or remove underline formating	Ctrl + U
Paste content	Ctrl + V
Close a spreadsheet	Ctrl + W
Move the selected cells	Ctrl + X
Repeat the last command or action, if possible	Ctrl + Y
Undo the last action	Ctrl + Z
Display or hide the ribbon	Ctrl + F1
Display "Print" window	Ctrl + F2
Display "Name Manager" dislog box	Ctrl + F3
Close selected workbook window	Ctrl + F4
Restore the size of the selected window	Ctrl + F5
Switch to next workbook window	Ctrl + F6
Perform Move command when not maximized. Arrow keys to move and Enter or Esc key to cancel	Ctrl + F7
Perform Size command when not maximized	Ctrl F8
Minimize a workbook to an icon	Ctrl + F9
Maximize or restore workbook window	Ctrl + F10
Inset a new Macro sheet	Ctrl + F11
Display "File Open" dialog box	Ctrl + F12
Move to the beginning of a worksheet	Ctrl + Home
Move to the last cell in use	Ctrl + End
Fill selected range with the current entry	Ctrl + Enter
Select an entire column in a worksheet	Ctrl + Spacebar
Switches to the next workbook or the next tab in dialog box	Ctrl + Tab
Calculate worksheets in all open workbooks	Ctrl + Alt + F9
Check formulas and calculate all cells	Ctrl + Alt + Shift + F9
Display "Paste Special" dialog box	Ctrl + Alt + V
Unhide selected columns	Ctrl + 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 selection	Ctrl + Shift + 7
Extend selection to the current range	Ctrl + Shift + 8
Unhide selected rows	Ctrl + Shift + 9
Apply the Number format	Ctrl + Shift + !
Copy the value from the cell above	Ctrl + Shift + "
Copy the value from the cell above	Ctrl + Shift + "
Apply the Date format	Ctrl + Shift + #
Apply the Currency format	Ctrl + Shift + $
Apply the Percentage format	Ctrl + Shift + %
Apply an outline border	Ctrl + Shift + &
Unhide the selected rows	Ctrl + Shift + (
Unhide the selected columns	Ctrl + Shift + )
Select the current data range	Ctrl + Shift + *
Select the current data range	Ctrl + Shift + *
Enter the current time	Ctrl + Shift + :
Apply the Time format	Ctrl + Shift + @
Apply the Scientific number format	Ctrl + Shift + ^
Remove the outline border	Ctrl + Shift + _
Select all cells referenced by formulas	Ctrl + Shift + {
Select cells with formulas that refer the active cell	Ctrl + Shift + }
Apply the General format	Ctrl + Shift + ~
Select cells that not match the formula or static value	Ctrl + Shift + |
Display "Insert" dialog box	Ctrl + Shift + +
Insert argument names and parentheses	Ctrl + Shift + A
Display "Format Cells" dialog box	Ctrl + Shift + F
Select cells with comments	Ctrl + Shift + O
Display "Format Cells" dialog box	Ctrl + Shift + P
Expand or collapse the formula bar	Ctrl + Shift + U
Extend selection down to the last nonblank cell	Ctrl + Shift + ↓
Extend the selection left to the first nonblank cell	Ctrl + Shift + ←
Extend selection right to the last nonblank cell	Ctrl + Shift + →
Extend selection up to the first nonblank cell	Ctrl + Shift + ↑
Extend selection to the last used cell	Ctrl + Shift + End
Create name using row and column labels	Ctrl + Shift + F3
Return to the previous window	Ctrl + Shift + F6
Display "Print" window	Ctrl + Shift + F12
Select the same cell in the next sheet	Ctrl + Shift + PageDown
Select the same cell in the previous sheet	Ctrl + Shift + PageUp
Extend selection to the beginning	Ctrl + Shift + Home
Select the current data range or the entire worksheet	Ctrl + Shift + Spacebar
Activate previous workbook or toolbar	Ctrl + Shift + Tab

8. Shift Shortcuts

What to do	Shortcuts
Extend selection by one cell up	Shift + ↑
Extend selection by one cell down	Shift + ↓
Extend selection by one cell left	Shift + ←
Extend selection by one cell right	Shift + →
Add or edit a cell comment	Shift + F2
Display "Insert Function" dialog box	Shift + F3
Find next blank cell	Shift + F4
Display "Find and Replace" dialog box	Shift + F5
Switch between Worksheet, Zoom controls, Task pane and Ribbon	Shift + F6
Extend selection to non-adjacent cells or ranges	Shift + F8
Calculate the active worksheet	Shift + F9
Display the shortcut menu	Shift + F10
Insert a new worksheet	Shift + F11
Save the workbook	Shift + F12
Select an entire row in a worksheet	Shift + Spacebar
Select the active cell when multiple cells selected	Shift + Backspace
Complete an entry and select the cell above	Shift + Enter
Move to the cell in front	Shift + Tab
Inserts a new worksheet	Alt + Shift + F1
Save the workbook	Alt + Shift + F2
Display the menu for Error Checking	Alt + Shift + F10
Unhide selected columns	Ctrl + 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 selection	Ctrl + Shift + 7
Extend selection to the current range	Ctrl + Shift + 8
Unhide selected rows	Ctrl + Shift + 9
Apply the Number format	Ctrl + Shift + !
Copy the value from the cell above	Ctrl + Shift + "
Apply the Date format	Ctrl + Shift + #
Apply the Currency format	Ctrl + Shift + $
Apply the Percentage format	Ctrl + Shift + %
Apply an outline border	Ctrl + Shift + &
Unhide the selected rows	Ctrl + Shift + (
Unhide the selected columns	Ctrl + Shift + )
Select the current data range	Ctrl + Shift + *
Select the current data range	Ctrl + Shift + *
Enter the current time	Ctrl + Shift + :
Apply the Time format	Ctrl + Shift + @
Apply the Scientific number format	Ctrl + Shift + ^
Remove the outline border	Ctrl + Shift + _
Select cells that not match the formula or static value	Ctrl + Shift + |
Select all cells referenced by formulas	Ctrl + Shift + {
Select cells with formulas that refer the active cell	Ctrl + Shift + }
Apply the General format	Ctrl + Shift + ~
Display "Insert" dialog box	Ctrl + Shift + +
Extend selection down to the last nonblank cell	Ctrl Shift ↓
Extend the selection left to the first nonblank cell	Ctrl + Shift + ←
Extend selection right to the last nonblank cell	Ctrl + Shift + →
Extend selection up to the first nonblank cell	Ctrl + Shift + ↑
Insert argument names and parentheses	Ctrl + Shift + A
Display "Format Cells" dialog box	Ctrl + Shift + F
Select cells with comments	Ctrl + Shift + O
Display "Format Cells" dialog box	Ctrl + Shift + P
Expand or collapse the formula bar	Ctrl + Shift + U
Extend selection to the beginning	Ctrl + Shift + Home
Extend selection to the last used cell	Ctrl + Shift + End
Create name using row and column labels	Ctrl + Shift + F3
Return to the previous window	Ctrl + Shift + F6
Display "Print" window	Ctrl + Shift + F12
Select the same cell in the next sheet	Ctrl + Shift + PageDown
Select the same cell in the previous sheet	Ctrl + Shift + PageUp
Activate previous workbook or toolbar	Ctrl + Shift + Tab
Check formulas and calculate all cells	Ctrl + Alt + Shift + F9

9. Home Shortcuts

What to do	Shortcuts
Move to the beginning of a worksheet	Ctrl + Home
Extend selection to the beginning	Ctrl + Shift + Home
Move to the upper-left corner of the window	Scroll Lock + Home

10. End Shortcuts

What to do	Shortcuts
Move to the top nonblank cell	End, ↑
Move to the bottom nonblank cell	End, ↓
Move to the last left nonblank cell	End, ←
Move to the last right nonblank cell	End, →
Move to the last cell in use	Ctrl + End
Move to the bottom-right corner of the window	Scroll Lock + End
Extend selection to the last used cell	Ctrl + Shift + End

11. Spacebar Shortcuts

What to do	Shortcuts
Select an entire column in a worksheet	Ctrl + Spacebar
Select an entire row in a worksheet	Shift + Spacebar
Select the current data range or the entire worksheet	Ctrl + Shift + Spacebar

12. Tab Shortcuts

What to do	Shortcuts
Switches to the next workbook or the next tab in dialog box	Ctrl + Tab
Move to the cell in front	Shift + Tab
Activate previous workbook or toolbar	Ctrl + Shift + Tab