Top 10 shortcut keys in Excel: one-click summation, currency formatting, filling to the right.

Do you feel that your work efficiency is too low? Don't worry, today, Mr. Wang specially sorted out ten shortcut keys for everyone. The best shortcut keys in Exce are of great help to the daily office. Let's take a look at them.

1. One-button summation shortcut: Alt + =

One-click summation, one of the most commonly used shortcut keys in Excel, can obtain not only columns and rows with one click, but also the sum of multiple columns and rows.

2. One-click comparison of two columns of data shortcuts: Ctrl +\

How to quickly compare the two columns of data to find out the different data content? First select the cells that need to be compared, and then use the shortcut key "Ctrl +\" to do it with one click.

3. Fill down and fill right shortcut keys: Ctrl + D / Ctrl + R

Ctrl + D can be filled down, not only to copy the fill content, but also to copy the formula. Ctrl + R fills to the right.

Copy content

4. Quickly select cell shortcut key: Ctrl + Shift + direction arrow

Sometimes the table is so long that it takes a long time to select the data down. So, at this point, we can use the shortcut key "Ctrl + Shift + ↓" to select all the cells below with one click. "Ctrl + Shift + →" can select all cells on the right.

5. Repeat the previous operation shortcut key: F4

Repeating the shortcut keys in the previous step can help us do a lot of repetitive work.

6. Percentage setting shortcut: Ctrl + Shift + 5

You can set the cell number format to the percentage format.

7. Shortcut key to set currency format: Ctrl + Shift + 4

You can quickly change the data into a "currency" format.

8. Enter the shortcut key for multiple cells: Ctrl + enter

Want to enter the same content in multiple blank cells, we can first use the "conditional format", select all the blank cells, and then enter the content, and finally press "Ctrl + enter" to enter the same content in these cells.

9. One-button shortcut to beautify the table: Ctrl + T

Want to quickly beautify your form? Or convert the table into a super table? We can use the shortcut key "Ctrl + T" to do it.

10. Quick fill shortcut: Ctrl + E

This is one of the most powerful keyboard shortcuts in Excel and can help us get a lot of work done.

Segment number

Mixed data split

Add units in batch

This article comes from the official account of Wechat: Word Alliance (ID:Wordlm123), author: Wang Wangqi