Numeric keys allow you to do things with your keyboard instead of your mouse to increase your speed.
We all know the basic moves like how you can around the sheet and select cells using the arrow keys or press Ctrl+A to select the entire worksheet but there are more complicated shortcut keys that you should know.
We will try and learn the action associated with 0 through 9, standalone and in combination with keys like Alt and Ctrl.
You can Download in PDF
We all know the basic moves like how you can around the sheet and select cells using the arrow keys or press Ctrl+A to select the entire worksheet but there are more complicated shortcut keys that you should know.
We will try and learn the action associated with 0 through 9, standalone and in combination with keys like Alt and Ctrl.
| Excel Shortcut | To do this |
|---|---|
| Ctrl + 1 | Open format Cells dialogue box |
| Ctrl + 2 | Bolds all cells in the highlighted section |
| Ctrl + 3 | Puts italics all cells in the highlighted section |
| Ctrl + 4 | Underlines all cells in highlighted section |
| Ctrl + 5 | Strike through highlighted selection |
| Ctrl + 6 | Shows or hides objects |
| Ctrl + 7 | Shows or hides the toolbar |
| Ctrl + 8 | Toggles the outline symbols |
| Ctrl + 9 | Hide Rows |
| Ctrl + 0 | Hide Columns |
| Alt + H + 0 | Increase Decimal |
| Alt + H + 9 | Decrease Decimal |
No comments:
Post a Comment