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 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
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 + *
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