Put Tick in Excel

Inserting a Tick in Excel

To insert a tick in Excel, you can use several methods. The tick symbol is often used to indicate “yes,” “true,” or “checked” in a dataset. Here are the ways to insert a tick in Excel:

First, you can use the Wingdings font to insert a tick. To do this:

• Select the cell where you want to insert the tick.
• Change the font of the selected cell to Wingdings.
• Type the character "P" (for a tick) or "O" (for a cross) in the cell.

Alternatively, you can use the Symbol dialog box to insert a tick. To do this:

• Go to the Insert tab in the ribbon.
• Click on Symbol in the Text group.
• In the Symbol dialog box, select the Wingdings font.
• Choose the tick symbol and click Insert.

You can also use the CHAR function to insert a tick. The CHAR function returns the character specified by the code number. For example, the code number for the tick symbol is 252.

• Type the formula =CHAR(252) in the cell where you want to insert the tick.
• Press Enter to apply the formula.

Using Conditional Formatting to Insert a Tick

You can also use Conditional Formatting to insert a tick in a cell based on a condition. To do this:

Select the cell range that you want to apply the formatting to.

• Go to the Home tab in the ribbon.
• Click on Conditional Formatting in the Styles group.
• Choose New Rule.
• Select Use a formula to determine which cells to format.
• Enter the formula that you want to use to determine when to insert the tick.
• Click on the Format button.
• In the Format Cells dialog box, select the Wingdings font and choose the tick symbol.
• Click OK to apply the formatting.

💡 Note: The above methods will insert a tick symbol in the selected cell. You can adjust the font and size of the tick symbol as needed.

Using VBA to Insert a Tick

You can also use VBA (Visual Basic for Applications) to insert a tick in a cell. To do this:

Open the Visual Basic Editor by pressing Alt + F11 or by navigating to Developer > Visual Basic in the ribbon.

• In the Visual Basic Editor, insert a new module by clicking Insert > Module.
• Paste the following code into the module:

Code
Sub InsertTick()
Range("A1").Value = Chr(252)
End Sub

• Close the Visual Basic Editor.
• Run the macro by pressing Alt + F8 or by navigating to Developer > Macros in the ribbon.
• Select the InsertTick macro and click Run.

A tick symbol will be inserted in the cell A1.

To summarize, there are several ways to insert a tick in Excel, including using the Wingdings font, the Symbol dialog box, the CHAR function, Conditional Formatting, and VBA. You can choose the method that best suits your needs.