Three practical tricks in Excel

Original title: "Excel can change the background color of documents, really super easy to use!" Don't waste any more money!"

Hi, I'm the witty and lovely Qiu Xiao E~

Last night, when I was about to get off work, I overheard my boss say to my colleague, Xinlaide: Work overtime tonight, accompany me to make a watch.

Overtime? That's impossible.

Xinlaide one operation, 1 minute to complete 3 forms, punctual time off work!

Want to know how he did it? Please see the tutorial below.

Check the difference between two columns: There are two columns of data to check, how to quickly find different data?

Excel：

Select the data and press Ctrl+\(\above your Enter key).

WPS：

Select the data, press Ctrl+G, and click Row Content Difference Cell-Positioning.

The effect is the same as Ctrl+\in Excel.

Highlight duplicate value problem: there is a sign-in sheet, how to find employees who have not signed in?

It was very simple, using the [Conditional Format] function.

In the Start tab, select Conditional Format-Highlight Cell Rule-Duplicate Value, and confirm.

Changing the background color of photos: How to change the background color of ID photos from gray to blue?

Select the picture, click Delete Background in the picture format, mark the part to be kept, and click Keep Change.

Then insert a blue rectangle, place it at the bottom of the picture, select all, press the right mouse button-[Combination], and combine them together.

Save the final screenshot and you can ~

Well, today's Excel skills sharing is here, if it helps you, please click on the likes and look at the support small E~(́) than the heart

This article comes from Weixin Official Accounts: Autumn Leaf Excel (ID: excel100), author: Zhu Lan