Remember these shortcut keys! Excel is more efficient!

In the process of copy editing, we often encounter some problems in the use of software. Word belongs to pure text editing software, but the actual copy is not a single text editing, there will be many forms of editing copy. For example, accounting wage calculation requires excel tables.

Both word and excel have their shortcut keys, which can improve work efficiency, especially in excel table editing. It is necessary to skillfully use these shortcut keys. So, what shortcut keys are set in excel?

Bian Xiao takes the wide application of function and number format in practical application as an example;

Take the digital format as an example:

1. Press Ctrl+Shift+~ (`) to set it as a common format.

2. press Ctrl+Shift+ 1 (! ) is set to the rounded currency format.

3. Press Ctrl+Shift+3(#) to set the date format.

4. Press Ctrl+Shift+5(%) to set the format as a percentage.

5. Press Ctrl+ 1 to quickly open the cell setting window.

Secondly, take the shortcut key setting of the function as an example:

1. Select some expressions of the formula and press F9 to convert them into calculation results.

2. Select the cell reference, and then press F4 to change the reference mode.

3. Enter the function name (for example =vlookup) and press Ctrl+A to bring up the function wizard.

4. The formula is not edited correctly. Press Esc to quickly restore the original formula.

In fact, in addition to the above two shortcut key settings, there are many shortcut key settings in excel tables, but these two shortcut key settings are the most practical and widely used. So remember that these shortcut keys can be more efficient in the office process and achieve twice the result with half the effort.