Hi friends .. here is the list of Excel short cut keys .. make use of it and save your valuable time :)
| Shortcut Keys | Description |
| F2 | Edit the selected cell. |
| F5 | Goto a specific cell. For example, C6. |
| F7 | Spell check selected text and/or document. |
| F11 | Create chart. |
| Ctrl + Shift + ; | Enter the current time. |
| Ctrl + ; | Enter the current date. |
| Alt + Shift + F1 | Insert New Worksheet. |
| Shift + F3 | Open the Excel formula window. |
| Shift + F5 | Bring up search box. |
| Ctrl + A | Select all contents of the worksheet. |
| Ctrl + B | Bold highlighted selection. |
| Ctrl + I | Italic highlighted selection. |
| Ctrl + K | Insert link. |
| Ctrl + U | Underline highlighted selection. |
| Ctrl + 5 | Strikethrough highlighted selection. |
| Ctrl + P | Bring up the print dialog box to begin printing. |
| Ctrl + Z | Undo last action. |
| Ctrl + F9 | Minimize current window. |
| Ctrl + F10 | Maximize currently selected window. |
| Ctrl + F6 | Switch between open workbooks / windows. |
| Ctrl + Page up | Move between Excel work sheets in the same Excel document. |
| Ctrl + Page down | Move between Excel work sheets in the same Excel document. |
| Ctrl + Tab | Move between Two 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 cell currently selected. |
| Ctrl + Shift + ! | Format number in comma format. |
| Ctrl + Shift + $ | Format number in currency format. |
| Ctrl + Shift + # | Format number in date format. |
| Ctrl + Shift + % | Format number in percentage format. |
| Ctrl + Shift + ^ | Format number in scientific format. |
| Ctrl + Shift + @ | Format number in time format. |
| Ctrl + Arrow key | Move to next section of text. |
| Ctrl + Space | Select entire column. |
| Shift + Space | Select entire row. |
| Shortcut Keys | Description |
| F2 | Edit the selected cell. |
| F5 | Goto a specific cell. For example, C6. |
| F7 | Spell check selected text and/or document. |
| F11 | Create chart. |
| Ctrl + Shift + ; | Enter the current time. |
| Ctrl + ; | Enter the current date. |
| Alt + Shift + F1 | Insert New Worksheet. |
| Shift + F3 | Open the Excel formula window. |
| Shift + F5 | Bring up search box. |
| Ctrl + A | Select all contents of the worksheet. |
| Ctrl + B | Bold highlighted selection. |
| Ctrl + I | Italic highlighted selection. |
| Ctrl + K | Insert link. |
| Ctrl + U | Underline highlighted selection. |
| Ctrl + 5 | Strikethrough highlighted selection. |
| Ctrl + P | Bring up the print dialog box to begin printing. |
| Ctrl + Z | Undo last action. |
| Ctrl + F9 | Minimize current window. |
| Ctrl + F10 | Maximize currently selected window. |
| Ctrl + F6 | Switch between open workbooks / windows. |
| Ctrl + Page up | Move between Excel work sheets in the same Excel document. |
| Ctrl + Page down | Move between Excel work sheets in the same Excel document. |
| Ctrl + Tab | Move between Two 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 cell currently selected. |
| Ctrl + Shift + ! | Format number in comma format. |
| Ctrl + Shift + $ | Format number in currency format. |
| Ctrl + Shift + # | Format number in date format. |
| Ctrl + Shift + % | Format number in percentage format. |
| Ctrl + Shift + ^ | Format number in scientific format. |
| Ctrl + Shift + @ | Format number in time format. |
| Ctrl + Arrow key | Move to next section of text. |
| Ctrl + Space | Select entire column. |
| Shift + Space | Select entire row. |
0 comments:
Post a Comment