Know these 10 Excel shortcut keys and your work efficiency will instantly soar

Introduction

Lan Se recently discovered that there are many operations in Excel that can be completed with one click, but some students are still using stupid methods. So I have the urge to summarize it again! !

1. Press the ctrl N key combination to create a new excel file with one click.
Are you still in File - New - Blank Workbook

2. Press Ctrl 1 (number 1) to quickly open the cell formatting box.
Are you still using right-click - Format Cells

3. Press CTRL A to quickly select the current continuous data area.
No matter how large the table is, you can select it in one second. Are you still dragging with the mouse?

4. Press CTRL 9 or 0 key combination to hide rows or columns with one click
Many students are looking for this shortcut key. Right-click operation is too troublesome

5. Press ctrl - (minus sign) to delete a line with one click (insert line: ctrl shift plus sign: )
This trick is very fast when deleting or inserting rows multiple times in a row!
Are you still in the right-click menu - Delete row

6. Press Ctrl p to open the "Print" interface with one click.
Are you still in File-Print....

7. Press Ctrl F1 to hide the ribbon with one click.
Are you still right-clicking - Collapse Ribbon

8. Press Ctrl Pgdn to quickly switch worksheets (Ctrl pgdn goes backward, Ctrl Pgup goes forward)
Are you still tagging one table after another?

9. Press Pgdn to turn pages with one click.
When scrolling down, keep turning the mouse wheel. Aren’t your fingers tired? Click PgDn to turn pages. Press Alt PgDn to page right. This is very convenient when the table has many columns.

10. Press ctrl alt A to take a screenshot with one click. (When QQ is opened)
When you need to save a table as an image format, are you still looking for screenshot software? In fact, when QQ is open, press Ctrl alt A to start taking screenshots. After intercepting, press ctrl alt S and a file saving window will pop up. Just save the image to the specified location.

Lanse said: Every time I share a shortcut key, many students will ask me why it cannot be used. There are 3 main reasons:
Conflicts with input method shortcut keys
The FN key is enabled. Try pressing FN in addition to the original key combination
You are using WPS form, some shortcut keys are not supported

The above is the detailed content of Know these 10 Excel shortcut keys and your work efficiency will instantly soar. For more information, please follow other related articles on the PHP Chinese website!