What to doShortcuts
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 + "
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