how to add tick mark in excel

To add a tick mark (check mark) in Excel, you have several effective methods:

Using the Symbol Dialog

1. Select the cell where you want the tick.
2. Go to the Insert tab on the ribbon.
3. Click Symbol (usually on the far right).
4. In the Symbol dialog box, set the Font to Wingdings.
5. Scroll down to find the tick symbol (character code 252) or other check marks.
6. Select the tick symbol and click Insert.
7. Close the dialog box. The tick will appear in the selected cell

Using Keyboard Shortcut with Wingdings Font

1. Select the cell.
2. Change the font of the cell to Wingdings.
3. Hold the Alt key and type 0252 on the numeric keypad for a tick mark.
4. Release the Alt key, and the tick will appear

Using a Formula with CHAR Function

1. Select a cell.
2. Enter the formula =CHAR(252) and press Enter.
3. Change the font of the cell to Wingdings to display the tick symbol.
4. You can copy this formula to other cells as needed

Using AutoCorrect for Frequent Use

1. Insert a tick symbol using any method above.
2. Copy the symbol from the formula bar.
3. Go to File > Options > Proofing > AutoCorrect Options.
4. In the Replace box, type a shortcut word (e.g., "tickmark").
5. In the With box, paste the copied tick symbol.
6. Click Add and OK.
7. Now typing "tickmark" in a cell will automatically convert to a tick symbol (apply Wingdings font if needed)

Using Emoji Panel (Windows)

• Press Windows key + . (period) to open the emoji panel.
• Search for "check" and select a tick emoji to insert it into the cell.
• Note this is a colored emoji and may look different from traditional ticks

These methods allow you to insert tick marks in Excel cells either as symbols, formulas, or shortcuts, depending on your preference and frequency of use. The most common and visually consistent approach is using the Symbol dialog with the Wingdings font