Subscribe for New Post Notifications

Use of numeric keys

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.

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

You can Download in PDF

No comments:

Post a Comment