| S.no | Shortcut | Description |
| 1 | F2 | Edit the selected cell. |
| 2 | F3 | After a name has been created, F3 will paste names. |
| 3 | F4 | Repeat last action. For example, if you changed the color of text in another cell, pressing F4 will change the text in cell to the same color. |
| 4 | F5 | Go to a specific cell. For example, C6. |
| 5 | F7 | Spell check selected text or document. |
| 6 | F11 | Create chart from selected data. |
| 7 | Ctrl+Shift+; | Enter the current time. |
| 8 | Ctrl+; | Enter the current date. |
| 9 | Alt+Shift+F1 | Insert New Worksheet. |
| 10 | Alt+Enter | While typing text in a cell, pressing Alt+Enter will move to the next line, allowing for multiple lines of text in one cell. |
| 11 | Shift+F3 | Open the Excel formula window. |
| 12 | Shift+F5 | Bring up search box. |
| 13 | Ctrl+1 | Open the Format Cells window. |
| 14 | Ctrl+A | Select all contents of the worksheet. |
| 15 | Ctrl+B | Bold highlighted selection. |
| 16 | Ctrl+I | Italic highlighted selection. |
| 17 | Ctrl+K | Insert link. |
| 18 | Ctrl+S | Save the open worksheet. |
| 19 | Ctrl+U | Underline highlighted selection. |
| 20 | Ctrl+D | Copy and paste the formula ` |
| 21 | Ctrl +C | Copy all the content in excel |
| 22 | Ctrl+1 | Change the format of selected cells. |
| 23 | Ctrl+5 | Strikethrough highlighted selection. |
| 24 | Ctrl+P | Bring up the print dialog box to begin the printing process. |
| 25 | Ctrl+Z | Undo last action. |
| 26 | Ctrl+F3 | Open Excel Name Manager. |
| 27 | Ctrl+F9 | Minimize current window. |
| 28 | Ctrl+F10 | Maximize currently selected window. |
| 29 | Ctrl+F6 | Switch between open workbooks or windows. |
| 30 | Ctrl+Page up | Move between work sheets in the same document. |
| 31 | Ctrl+Page down | Move between work sheets in the same document. |
| 32 | Ctrl+Tab | Move between Two or more open Excel files. |
| 33 | Alt+= | Create a formula to sum all of the above cells. |
| 34 | Ctrl+' | Insert the value of the above cell into the cell currently selected. |
| 35 | Ctrl+Shift+1 | Format number in comma format. |
| 36 | Ctrl+Shift+4 | Format number in currency format. |
| 37 | Ctrl+Shift+3 | Format number in date format. |
| 38 | Ctrl+Shift+5 | Format number in percentage format. |
| 39 | Ctrl+Shift+6 | Format number in scientific format. |
| 40 | Ctrl+Shift+2 | Format number in time format. |
| 41 | Ctrl+Arrow key | Move to next section of text. |
| 42 | Ctrl+Space | Select entire column. |
| 43 | Shift+Space | Select entire row. |
| 44 | Ctrl+- | Delete the selected column or row. |
| 45 | Ctrl+Shift+= | Insert a new column or row. |
| 46 | Ctrl+Home | Move to cell A1. |
| 47 | Ctrl+~ | Switch between showing Excel formulas or their values in cells. |
Comments
Post a Comment