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 + " |
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 + } |
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 |