Excel can finish the work with one click, and you can't miss these skills.

Today, Mr. Wang is here to share with you some tips on getting work done with one click in Excel to make your work more efficient!

1. How to quickly compare the two columns of data with one button to find out the different contents? First select the data cells that need to be compared between the two columns, and then use the key combination "Ctrl +\" to compare them with one button, and eventually select different data cells.

2, one-click insert time and date how to quickly insert the date and time in the Excel table?

"Ctrl +;" inserts the current date with one button

"Ctrl + Shift +;" insert the current time with one button

3, one button to delete duplicate value data entry too much, there will inevitably be duplicate content, then how should we deal with it? It is obviously not efficient to look for it with the naked eye. Select the data, enter the "data"-"data tools"-"Delete duplicate values" to determine and quickly find and delete duplicate content.

4. One-click summation of the data in the table is a common thing we do in our work. How do you usually sum it? Try "Alt + =" for one-click summation.

5. Insert annotations with one button many people use the right mouse button directly to set annotations. In fact, we can use shortcut keys to do so.

"Shift + F2" one click to insert an annotation

6. One button to beautify the form to make the form more beautiful? We just need to use the shortcut key "Ctrl + T" to automatically format the table.

7. Do you want to quickly turn the data into a chart by creating a chart with one click? Select any cell in the data area and use the shortcut key "Alt + F1" to quickly generate the data into a chart.

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