Excel six popular shortcut keys

Excel Six popular shortcut keys

1, ctrl+1 (number 1)

Reasons to list: When editing a number format, the most common is the cell format window, press Ctrl+1-more than the right key-set cell format is much faster.

2 PgUp or PgDn.

List reason: In Excel to look up and down the table, 90% students are sure to use the mouse to drag the way to see, try PgUp and PgDn key, really very convenient, if it is right and left, press ALT key, then press PgUp and PgDn.

3 Ctrl+pgup or PgDn

Reasons to list: Whether you often browse the contents of multiple worksheets, when you click the hands of acid, the left hand press CTRL, the right hand easily press PgUp or PGDN can be achieved quickly switch worksheets.

4 ctrl+w

Reasons to List: Closing a workbook is something you do more than once a day. With the cursor accurate click on the small Close button, no ctrl+w come fast.

5, CTRL + (OR)

Reason to list: If you need to hide multiple nonadjacent rows or columns. When you point to the right hand acid, try Ctrl + (or) and find that you can quickly hide rows or columns.

6 CTRL +-

Reason to list: Every time you delete it, you have to right-click-delete it. It will be very tiring to delete more. By pressing CTRL and-keys, you will be able to remove the speed of an instant elevation.

Note: Some of the other software shortcuts and Excel shortcut keys conflict, resulting in shortcut keys can not be used normally. Common to have input method. Then close the input method and try again.