Excel Shortcut Keys | Description |
F7 | Spell check |
F11 | Create chart |
Ctrl + Shift + ; | Enter the current time |
Ctrl + ; | Enter the current date |
Alt + Shift + F1 | Insert New Worksheet |
Shift + F3 | Open the Excel formula window |
Shift + F5 | Bring up search box |
Ctrl + A | Select all contents of the worksheet |
Ctrl + B | Bold |
Ctrl + I | Italic |
Ctrl + K | Insert hyperlink |
Ctrl + U | Underline |
Ctrl + 5 | Strikethrough |
Ctrl + P | Bring up the print dialog box to begin printing |
Ctrl + Z | Undo |
Ctrl + F9 | Minimize window |
Ctrl + F10 | Maximize window |
Ctrl + F6 | Switch between open workbooks |
Ctrl + Tab | Move to next worksheet |
Ctrl + Shift + ! | Format number in comma format |
Ctrl + Shift + $ | Format number in currency format |
Ctrl + Shift + # | Format number in date format |
Ctrl + Shift + % | Format number in percentage format |
Ctrl + Shift + ^ | Format number in scientific format |
Ctrl + Shift + @ | Format number in time format |
Ctrl + Arrow key | Move to next section of text |
Ctrl + Space | Select entire column |
Shift + Space | Select entire row |
Word Shortcut Keys | Function |
Ctrl + Shift + A | All CAPS |
Ctrl + B | Make Bold |
Esc | Cancel |
Shift + F3 | Change case |
Ctrl + W | Close document |
Ctrl + C | Copy |
Ctrl + X | Cut |
Ctrl + Backspace | Delete pervious word |
Ctrl + F | Find and Replace |
Shift + F4 | Find |
Ctrl + Shift + [ | Font, decreased Font by 1 point |
Ctrl + ] | Font, Increased Font by 1 point |
Ctrl + Shift + < | Font, decrease Font down by 1 size |
Ctrl + Shift + > | Font, Increase Font up by 1 size |
Ctrl + Home | Go to the beginning of the document |
Ctrl + End | Go to the end of the document |
Alt + Shift + D | Insert Date field with current Date |
Alt + Shift + P | Insert Page field with current Page |
Alt + Shift + T | Insert Time field with current Time |
Ctrl + K | Insert a hyperlink |
Ctrl + I | Italicize |
Shift + Enter | Line break / new line same paragraph |
Ctrl + O | Open |
Shift + F7 | Thesaurus |
Ctrl + V | Paste |
Ctrl + Enter | Page break |
Ctrl + P | Print |
F7 | Proofing / Spell Check |
F4 or Ctrl + Y | Repeat / Redo your last action |
Ctrl + Spacebar | Reset Character |
Ctrl + S | Save |
Ctrl + A | Select all |
Ctrl + Shift + Home | Select to the beginning of the document |
Ctrl + Shift + End | Select to the end of the document |
Ctrl + U | Underline |
Ctrl + Z | Undo |
0 comments:
Post a Comment