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