ms Excel shortcut keys | All advanced Excel shortcuts
We've assembled a rundown of some keyboard shortcuts for Microsoft Excel. In spite of the fact that you can do these moves physically, realizing these stunts will help spare you time so you can concentrate on the stuff that truly matters.
The table contains a list of some commonly used ms Excel shortcut keys that work with your computers and software. It is highly recommended that all users should use these keys and try to remember them.
| Shortcut Keys | Description |
|---|---|
| Ctrl + * | Move to next section of text |
| Ctrl + ; | Enter the current date |
| Ctrl + ‘ | Insert value of above cell into current cell |
| Ctrl + 5 | Strikethrough highlighted selection |
| Ctrl + A | Select all contents of worksheet |
| Ctrl + B | Bold highlighted selection |
| Ctrl + C | Copy selected text |
| Ctrl + D | Fill |
| Ctrl + F | Open find and replace options |
| Ctrl + F10 | Maximize currently selected window |
| Ctrl + F6 | Switch between open workbooks/windows |
| Ctrl + F9 | Minimize current window |
| Ctrl + G | Open go-to options |
| Ctrl + H | Open find and replace options |
| Ctrl + I | Italicize highlighted selection |
| Ctrl + K | Insert link |
| Ctrl + N | Open new document |
| Ctrl + O | Open options |
| Ctrl + P | Open print dialog box |
| Ctrl + Page up & Page Down | Move between Excel® worksheets in the same document |
| Ctrl + S | Save |
| Ctrl + Shift + ! | Format number in comma format |
| Ctrl + Shift + # | Format number in date format |
| Ctrl + Shift + $ | Format number in currency format |
| Ctrl + Shift + % | Format number in percentage format |
| Ctrl + Shift + ; | Enter the current time |
| Ctrl + Shift + @ | Format number in time format |
| Ctrl + Shift + ^ | Format number in scientific format |
| Ctrl + Space | Select entire column |
| Ctrl + Tab | Move between two or more open Excel® files |
| Ctrl + U | Underline highlighted selection |
| Ctrl + V | Paste |
| Ctrl + W | Close document |
| Ctrl + Y | Underline selected text |
| Ctrl + Z | Undo last action |
| Alt + = | Create formula to sum all of above cells |
| Alt + Shift + F1 | Insert new worksheet |
| Shift + F3 | Open the Excel® formula window |
| Shift + F5 | Bring up search box |
| Shift + Space | Select entire row |
| F11 | Create chart |
| F2 | Edit the selected cell |
| F5 | Go to a specific cell |
| F7 | Spell check selected text and/or document |
No comments:
Post a Comment
If you have any doubts.please let me know