What to do | Shortcuts |
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 |