Excel shortcuts

The easiest shortcut for adding a checkmark in Excel

If you're like most people, you probably use Microsoft Excel for a variety of tasks. Whether you're tracking your personal finances, managing a household budget, or creating a complex spreadsheet for work, Excel is a powerful tool that can help you get the job done.

But even if you're an experienced Excel user, there are still some things that can trip you up from time to time. One of those things is adding a checkmark to a cell. If you're not sure how to do it, don't worry - we're here to help.

The easiest way to add a checkmark to a cell in Excel is to use the Wingdings font. Wingdings is a special font that contains a variety of symbols, including a checkmark. To use Wingdings, simply select the cell you want to add the checkmark to and then change the font to Wingdings. Once you've done that, you can press the "P" key on your keyboard, and a checkmark will appear in the cell.

If you don't want to use Wingdings, or if you're working in a version of Excel that doesn't have that font, you can also use the CHAR function. The CHAR function takes a numeric code as an argument and returns the character that corresponds to that code. For a checkmark, the code you need to use is 10003. So, to add a checkmark to a cell using the CHAR function, you would enter the following formula:

=CHAR(10003)

Once you've entered the formula, you can press Enter, and the checkmark will appear in the cell.

If you want to add a checkmark to multiple cells at once, you can use the fill handle. To do this, select the cell with the checkmark and then drag the fill handle (the small square in the bottom-right corner of the cell) down or across to the other cells you want to fill. Excel will automatically copy the checkmark to all of the cells you've selected.

You can also use the fill handle to add a checkmark to every other cell in a range. To do this, select the cell with the checkmark and then drag the fill handle down or across to the last cell in the range. Then, hold down the Shift key and drag the fill handle back up to the first cell in the range. Excel will automatically add a checkmark to every other cell in the range.

If you want to add a checkmark to every third cell in a range, you can use a similar technique. Select the cell with the checkmark and then drag the fill handle down or across to the last cell in the range. Then, hold down the Shift key and drag the fill handle back up to the first cell in the range. This time, however, also hold down the Ctrl key. Excel will automatically add a checkmark to every third cell in the range.

You can also use the fill handle to add a checkmark to every fourth cell in a range. To do this, select the cell with the checkmark and then drag the fill handle down or across to the last cell in the range. Then, hold down the Shift key and drag the fill handle back up to the first cell in the range. This time, however, also hold down the Ctrl and Alt keys. Excel will automatically add a checkmark to every fourth cell in the range.

If you want to add a checkmark to every fifth cell in a range, you can use a similar technique. Select the cell with the checkmark and then drag the fill handle down or across to the last cell in the range. Then, hold down the Shift key and drag the fill handle back up to the first cell in the range. This time, however, also hold down the Ctrl, Alt, and Shift keys. Excel will automatically add a checkmark to every fifth cell in the range.

As you can see, there are a few different ways you can add a checkmark to a cell in Excel. Which method you use will depend on your needs. But now that you know how to do it, you can easily add a checkmark to any cell in your spreadsheet.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.