Microsoft Excel is most used version of Microsoft Office. Many people uses this to make spreadsheets and also to complete their office works and projects but many people don't know the shortcut keys of Microsoft Excel they use everything and feature manually in Microsoft Excel. So for those people i make this article to make their works easy so they want to save their time and energy.
Following are shortcut keys of Microsoft Excel. Some Shortcut keys might be version specific.
Mouse Shortcut Keys
| Shortcut | Description |
| Double-click (on a cell) | Edit the cell contents. |
| Double-click (on a row/column divider) | Adjust height/width to auto-fit |
| High-light headers of multiple rows/columns then Double-click on a row/column divider | Adjust height/width to auto-fit of all high-lighted rows/columns |
| Triple-click | Select the entire contents in the cell |
| Click on row/column divider then drag | Adjust height/width of the row/column |
| High-light headers of multiple rows/columns then Click on row/column divider then drag | Adjust height/width of the rows/columns |
| Ctrl + Mouse wheel | Zooms in and out of document. |
| Hold Shift + Click the cells | Select multiple cells |
Keyboard Shortcut Keys
| Shortcut | Description |
| F2 | Edit the selected cell. |
| F5 | Go to a specific cell. For example, C6. |
| F7 | Spell check selected text and/or document. |
| F11 | Create chart. |
| Ctrl + A | Select all. |
| Ctrl + B | Bold. |
| Ctrl + C | Copy. |
| Ctrl + F | Find (same as Shift + F5). |
| Ctrl + G | Go To. |
| Ctrl + H | Replace. |
| Ctrl + I | Italic. |
| Ctrl + K | Insert link. |
| Ctrl + N | New Workbook. |
| Ctrl + O | Open Workbook. |
| Ctrl + P | Print dialog. |
| Ctrl + S | Save. |
| Ctrl + U | Underline. |
| Ctrl + V | Paste. |
| Ctrl + Z | Undo. |
| Ctrl + Y | Redo. |
| Ctrl + X | Cut. |
| Ctrl + 5 | Strike through text. |
| Ctrl + F3 | Define Name. |
| Ctrl + F4 | Exit Excel |
| Ctrl + F6 | Switch between open workbooks. |
| Ctrl + F9 | Minimize current window. |
| Ctrl + F10 | Maximize current window. |
| Shift + F1 | Activate Help on Item. |
| Shift + F2 | Insert Comments |
| Shift + F3 | Insert Function. |
| Ctrl + Shift + ; | Enter the current time. |
| Ctrl + ; | Enter the current date. |
| Ctrl + Page down | Move to next worksheet. |
| Ctrl + Page up | Move to previous worksheet. |
| Ctrl + Shift + # | Number Format: Date |
| Ctrl + Shift + @ | Number Format: Time. |
| Ctrl + Shift + ! | Number Format: Commas. |
| Ctrl + Shift + $ | Number Format: Currency |
| Ctrl + Shift + % | Number Format: Percentage |
| Ctrl + Shift + ^ | Number Format: Scientific. |
| Ctrl + Space | Select entire column |
| Shift + Space | Select entire row. |
| Ctrl + (Arrow key) | Move to next section. |
Comment if any key not work we will help you for that.
Post a Comment