How to Add a Check Mark in Excel

Ever found yourself wanting to add a checkmark to a cell in Excel to indicate completion or success? While Excel doesn't have a built-in checkmark symbol like ✓, you can achieve this in a few simple steps. Let's explore how you can add a checkmark to your Excel cells.

Before we dive in, ensure you're using one of the supported Excel versions: Microsoft Excel 2010 or later, or the newer Microsoft 365 Excel. Now, let's get started!

The Unicode Checkmark Method

One of the easiest ways to add a checkmark to Excel is by using a Unicode symbol. Unicode provides a universal character set that includes a checkmark symbol. Here's how you can use it:

1. Click on the cell where you want to insert the checkmark.
2. On the Home tab in the toolbar, click on the drop-down arrow next to the cell you've selected.
3. Select 'Format Cells.'
4. In the 'Number' tab, under 'Category,' choose 'Custom.'
5. In the 'Type' field, enter the following: ✓
6. Click 'OK.'

Using Symbols in Excel

The method above uses the Unicode character for a checkmark. However, you can also insert checkmarks using the Symbols feature in Excel:

1. Click on the cell where you want to insert the checkmark.
2. On the Home tab in the toolbar, click on the drop-down arrow next to the cell you've selected.
3. Select 'Symbols.'
4. In the 'Symbol' dialogue box, under 'Subset,' choose 'Symbols.'
5. Find the checkmark symbol (it should look like a small box with a tick) and click on it.
6. Click 'Insert,' then 'Close.'

Using a Checkmark Shape in Excel

Another option is to use Excel's Shape feature to insert a checkmark. This method is particularly useful if you want a larger, more visible checkmark:

1. Click on the 'Home' tab in the toolbar.
2. In the 'Drawings' group, click on the small arrow in the 'Shapes' icon.
3. Select the 'Checkmark' shape.
4. Click on the cell where you want to insert the checkmark.
5. The checkmark will be inserted. You can then resize and adjust it as needed.

Formatting the Checkmark Shape

After inserting a checkmark shape, you can format it to match your Excel theme or add additional visual elements:

1. Click on the checkmark shape to select it.
2. On the 'Format' tab under 'Shape Styles,' choose a style that suits your theme.
3. You can also click on 'Shape Fill' to change the color of the checkmark or 'Shape Outline' to change its border color.
4. To make the checkmark more noticeable, you can add a glow or reflection using the 'Format' tab.

There you have it! Adding checkmarks to your Excel cells is a breeze once you know how. Happy checking!