| Shortcut keys | Description |
|---|
| F2 | Edit the select cell |
| F5 | Go to the specific cell |
| F7 | Spell check selected text and /or document |
| F11 | Create a chart |
| Ctrl +Shift+; | Enter the current time |
| Ctrl+; | Enter the current date |
| Alt+Shift +F1 | Insert a new worksheet |
| Shift+F3 | Open the excel formula window |
| Shift+F5 | Bring up search box |
| Ctrl+A | Select all the contents of the worksheet |
| Ctrl+B | Bold highlighted section |
| Ctrl+I | Italic highlighted section |
| Ctrl +K | Insert Link |
| Ctrl +U | Underline highlighted section |
| Ctrl +5 | Strike through highlighted section |
| Ctrl+P | Bring up the control dialog box to begin printing |
| Ctrl +Z | Undo last section |
| Ctrl + F9 | Minimize current window |
| Ctrl+ F10 | Minimize currently selected window |
| Ctrl +F6 | Switched between work books/ windows |
| Ctrl+Page Down/Ctrl+Page Up | Move to the next / previous worksheet in current workbook.t |
| 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 + ! | Apply the Number format with two decimal places, thousands separator, and minus sign (-) for negative values. |
| Ctrl+Shift+$ | Apply the Currency format with two decimal places. |
| Ctrl+Shift+# | Apply the Date format with the day, month, and year |
| Ctrl+Shift+% | Apply the Percentage format with no decimal places |
| Ctrl+Shift+@ | Apply the Time format with the hour and minute, and indicate A.M. or P.M. |
| Ctrl+y | Redo last action (multiple levels) |
No comments:
Post a Comment
Please suggest your valuable comments here....