Hi every one,
Microsoft excel is very helpful tool for any work. In today’s competitive e world you must be faster and you must know the shortcut keys to operate excel faster and successfully.
Following are Few Excel shortcut that will be helpful in your day to day life
| Shortcut | Details |
| F2 | To edit and select the cell |
| F3 | After a Name has been created, F3 will Paste the names. |
| F4 | To repeat last action. |
| F5 | Go to a specific cell. For example, D7. |
| F7 | To spell check selected text or document. |
| F11 | To create the chart for selected Data |
| Ctrl + Shift + ; | To enter the current time. |
| Ctrl + ; | To enter the current date. |
| Alt + Shift + F1 | To insert the new worksheet |
| Alt + Enter | To move the next line while typing the data in the cell, allowing for multiple lines of text in one cell. |
| Ctrl + 1 | To open the Format Cells window. |
| Ctrl + A | To select all contents of the worksheet. |
| Ctrl + B | Bold highlighted selection content |
| Ctrl + I | To Italic highlighted selection Content. |
| Ctrl + K | To insert the link |
| Ctrl + S | To Save the open worksheet. |
| Ctrl + U | To underline highlighted selection. |
| Ctrl + P | To bring up the print dialog box to begin the printing process. |
| Ctrl + Z | Undo last action. |
| Ctrl + F6 | To switch between open workbooks or windows. |
| Ctrl + Page up | Move between work sheets in the same document. |
| Ctrl + Page down | Move between work sheets in the same document. |
| Ctrl + Tab | Move between Two or more open Excel files. |
| Alt + = | To create a formula to sum all of the above cells. |
| Ctrl + ‘ | To insert the value of the above cell into the cell currently selected. |
| Ctrl + Shift + 1 | To format number in comma format. |
| Ctrl + Shift + 4 | To format number in currency format. |
| Ctrl + Shift + 3 | To format number in date format. |
| Ctrl + Shift + 5 | Format number in percentage format. |
| Ctrl + Shift + 6 | Format number in scientific format. |
| Ctrl + Shift + 2 | Format number in time format. |
| Ctrl + Arrow key | Move to next section of text. |
| Ctrl + Space | To selece the entire column |
| Shift + Space | To selece the entire Raw |
| Ctrl + – | To delete the selected column or row. |
| Ctrl + Shift + = | To insert a new column or row. |
| Ctrl + Home | To move to cell A1. |
Views : 1618
