Microsoft Office Excel shortcut keys
Microsoft Office Excel shortcut keys
Short Key | Description |
Alt+Enter | Next line |
Shift+F3 | Open the formula window. |
Shift+F5 | Show search box. |
Ctrl+Shift+; | Current time. |
Ctrl+; | Curernt date. |
Alt+Shift+F1 | Insert New Worksheet. |
F2 | Edit the cell as selected. |
F4 | Repeat the last action. |
F5 | Move to a specific cell. |
F7 | Spelling checking |
F11 | Create chart from the selected data. |
Ctrl+1 | Show Format Cells window. |
Ctrl+A | Select all full contents |
Ctrl+B | Bold the text |
Ctrl+I | Italic the text |
Ctrl+K | Insert the link. |
Ctrl+S | To save |
Ctrl+U | Underlining the text. |
Ctrl+D | Fill down. |
Ctrl+R | Fills the cell to the right with the contents of the selected cell. |
Ctrl+1 | Change the format of selected cells. |
Ctrl+5 | Strikethrough the text |
Ctrl+P | To print |
Ctrl+Z | Undo the last action. |
Ctrl+F9 | Minimize the current window. |
Ctrl+F10 | Maximize currently selected window. |
Ctrl+F6 | Switch between windows or open workbooks. |
Ctrl+Shift+1 | Format the number in comma format. |
Ctrl+Shift+4 | Format the number in currency format. |
Ctrl+Shift+3 | Format the number in date format. |
Ctrl+Shift+5 | Format the number in a percentage format. |
Ctrl+Shift+6 | Format the number in scientific format. |
Ctrl+Shift+2 | Format the number in time format. |
Ctrl+Tab | Move between 2 or more open Excel files. |
Alt+= | Create a formula to sum all of the above cells. |
Ctrl+’ | Insert the value of the above cell into the cell currently selected. |
Ctrl+Arrow key | Move to next section of text. |
Shift+Space | Select entire row. |
Ctrl+Home | Move to cell A1. |
Ctrl+~ | Switch between showing Excel formulas or their values in cells. |
Ctrl+- | Delete the selected column or row. |
Ctrl+Shift+= | Insert a new column or row. |
Ctrl+~ | Switch between showing Excel formulas or their values in cells. |
Ctrl+Home | Move to cell A1. |
Ctrl+Space | Select entire column. |
Ctrl+Page up | Move between worksheets in the same document. |
Ctrl+Page down | Move between worksheets in the same document. |
Read More
- Microsoft Word MCQs
- Ctrl+A short key use in MS Word
- Difference between Ionic Bonds and Covalent Bonds
- Difference between Acids and Bases
- Ctrl+N short key use in MS Word
- Ctrl+C short key use in MS Word
- Ctrl+O short key use in MS Word
- Ctrl+S short key use in MS Word
- Ctrl+W short key use in MS Word
- Ctrl+X short key use in MS Word
- Ctrl+B short key use in MS Word
- Ctrl+E short key use in MS Word
- Ctrl+I short key use in MS Word
- Ctrl+L short key use in MS Word
- Ctrl+Left bracket ([) short key use in MS Word
- Alt+Shift+C short key use in MS Word
- Ctrl+Alt+S short key use in MS Word
- Ctrl+R short key use in MS Word
- Ctrl+Right bracket (]) short key use in MS Word
- Ctrl+U short key use in MS Word
- Ctrl+V short key use in MS Word
- Ctrl+Y short key use in MS Word
- Ctrl+Z short key use in MS Word
- Esc short key use in MS Word
- alt a-short-key-use-in-ms-excel
- Alt+H short key use in MS Excel
- Alt+M short key use in MS Excel
- Alt+N short key use in MS Excel
- Alt+P short key use in MS Excel
- Alt+W short key use in MS Excel
- Ctrl+ W short key use in MS Excel
- Ctrl+0 short key use in MS Excel
- ctrl9-short-key-use-in-ms-excel
- Ctrl+B short key use in MS Excel
- Ctrl+C short key use in MS Excel
- Ctrl+O short key use in MS Excel
- Ctrl+S short key use in MS Excel
- Ctrl+V short key use in MS Excel
- Ctrl+X short key use in MS Excel
- Ctrl+Zshort key use in MS Excel
- Delete short key use in MS Excel
- Shift+F10 short key use in MS Excel