What to do | Shortcuts |
Format Style dialog box | Alt + ' |
Copy a formula from the cell above | Ctrl + ' |
Open "Delete" dialog box | Ctrl + – |
Enter the current date | Ctrl + ; |
Switch displaying cell values or formulas | 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 |
Display "Paste Special" dialog box | Ctrl + Alt + V |
Bold text or remove bold formatting | Ctrl + B |
Copy the selected cells | Ctrl + C |
Copy topmost cell into the cells below | Ctrl + D |
Apply or remove italic formatting | Ctrl + I |
Create or edit a hyperlink | Ctrl + K |
Display "Create Table" dialog box | Ctrl + L |
Display "Quick Analysis" options | Ctrl + Q |
Use the Fill Right command | Ctrl + R |
Display "Create Table" dialog box | Ctrl + T |
Apply or remove underline formating | Ctrl + U |
Paste content | Ctrl + V |
Move the selected cells | Ctrl + X |
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 + ) |
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 + _ |
Apply the General format | Ctrl + Shift + ~ |
Display "Insert" dialog box | Ctrl + Shift + + |
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 |
Display "Format Cells" dialog box | Ctrl + Shift + F |
Display "Format Cells" dialog box | Ctrl + Shift + P |
Add or edit a cell comment | Shift + F2 |
Display the shortcut menu | Shift + F10 |
Move cursor to the end of contents | F2 |
Display "Spelling" dialog box | F7 |