You don't have to play √ one by one in Excel & # 215, just these three moves.

The original title: "there is no need to manually hit √ one by one, just these three moves!" "

Hello, everyone! I'm little E.

Today, my colleague suddenly asked me: Xiao E, do you know any skills of ticking and crossing? it's too painful to rely on pinyin every day.

It is best to enter only a letter or number, you can come out √ or ×.

Me: well, you have to pay me for such a troublesome (simple) thing.

Colleague: how about I treat you to dinner?

Me: well, for the sake of our good relationship, I'll give you a hand.

Here are three methods:

❶ modifies the font to enter "specific letters" to display as √ or ×

❷ custom cell format, enter "specific content" to display as √ or ×

Check box for ❸ ticking.

How to operate it? let's take a look.

01. Modify the font method under the Wingdings2 font, enter a specific English letter, which can be automatically converted to √ or ×.

The comparison table is as follows:

Don't find it difficult to remember, "OPQR" is in the order of the 26-digit English alphabet.

👉 procedure:

❶ select the area where you need to type √ or x, and set the font to Wingdings 2

❷ according to the above corresponding table, enter the corresponding "capital letters" on it!

Colleague: this is awesome, much faster than directly using Pinyin input method!

Me: don't worry, I have another way.

02. Custom format method We can customize the cell format of the data region to: [= 1] √; [= 0] ×.

It means that when the cell value is equal to 1, it is displayed as √, and when the cell value is equal to 0, it is displayed as ×.

So as long as the "custom cell format" is set to this, and then enter 1 and 0, you can display √ and ×!

Procedure:

❶ selects the areas that need to be √ or x, and [Ctrl+1] sets the cell format.

❷ input: [= 1] √; [= 0] ×, click OK, enter 1 or 0 in the cell range, and it will automatically display as √ and ×.

Colleague: this is also awesome. I've learned that the original cell format can still be used in this way!

Me: yes, by the way, I'll expand a frame where you can check.

03. There is a [check box] form control in the check box development tool, which allows us to tick directly.

Procedure:

❶, click [Development tools]-- [insert]-- Select the check box (that is)

❷ in Excel to draw, modify the text, you can check!

PS: if you want to move the position of this check box control, you need to right-click and then select move. You can't move if you click directly on the left.

All right, that's all for today.

This article comes from the official account of Wechat: Akiba Excel (ID:excel100), author: witty Qiu Xiao E Editor: Zhu Lan