How to insert tick mark or tick box in excel cell?


Excel treats the tick mark as text. This implies that the location can be altered by using regular Copy and Paste commands, and the color and size may be altered just like any other text. Simply clicking on a tick box with the mouse, also known as a tick box or tick mark box, the user can choose or deselect an option, tick, or check a tick box.

If users seeking functionality like this. A particular sign that can be placed in a cell is a tick symbol, additionally referred to as a tick symbol or tick mark.

Example 1: To Insert a Tick Mark or Tick Box by using the Symbol Command Option

Step 1

In this step, the user has selected a particular cell in the worksheet and writes the message over there i.e. select the cell. Following is the screenshot of this step.

Step 2

After choosing a cell then in the previous step, the user clicks on the Insert tab that is shown in the title bar and taps on it. After that user is seen the symbol group option on the right-hand side of the toolbar and finally user clicks on the symbol tab. Following is the screenshot of this step.

Step 3

In this step, the user selects the Wingdings option by clicking the drop-down arrow next to the text box on the Symbols tab of the Symbol dialogue box. Following is the screenshot of this step.

Explanation

Arrows, checkmarks, bullets, geometric forms, as well as other symbols are among the many that can be found in Wingdings. In Wingdings, every character on the keyboard correlates to a certain symbol. users won't see the typical letters or numbers when they are typing in the Wingdings typeface, though, as it substitutes for the regular numeric characters.

If the users share the Excel file with some other users who do not have the Wingdings font set up on their machine, then that user might not be able to view the symbols properly. So, in these circumstances, it's best to offer a key or legend to describe the significance of the symbols used by the users.

Step 4

And then choose the tick box from the Symbol tab. Following is the screenshot of this step.

Step 5

In this step, the user has to select the tick box option from the symbol tab and then click on the insert button. Following is the screenshot of this step.

Step 6

In this step, users want to close the tick mark or tick box by clicking on the Close button. After that option will disappear from the screen. Following is the screenshot of this step.

Conclusion

The step-by-step instructions are given in the specified example. By following the instructions in the steps above, the user can insert the tick mark or tick mark box into an Excel cell to satisfy the criterion easily.

Updated on: 21-Aug-2023

66 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements