Excel shortcuts

How to Insert a Check Mark in Excel: The Quickest Way

Do you need to insert a check mark in Excel? Maybe you're creating a to-do list, or tracking progress on a project. Whatever the reason, there are a few different ways to insert a check mark in Excel.

The quickest way to insert a check mark in Excel is to use a symbol. To do this, simply click on the cell where you want to insert the check mark, then click on the Insert tab on the ribbon. From there, click on the Symbol button. This will open the Symbol dialog box.

In the Symbol dialog box, scroll down until you find the check mark symbol. Once you find it, click on it to select it, then click on the Insert button. This will insert the check mark into your cell.

If you want to use a check mark more than once, you can click on the Insert button again to insert another check mark, or you can click on the Cancel button to close the dialog box. If you close the dialog box, you can always reopen it by clicking on the Symbol button again.

Another way to insert a check mark in Excel is to use a character code. To do this, simply click on the cell where you want to insert the check mark, then press Alt+0252 on your keyboard. This will insert a check mark into your cell.

If you want to use a check mark more than once, you can press Alt+0252 again to insert another check mark. Or, you can press Alt+0252, then release the Alt key, and press Enter. This will insert a check mark and move to the next cell.

You can also use a check mark in a formula. For example, if you have a list of items, and you want to count the number of items that have a check mark, you can use the COUNTIF function. To do this, simply enter the following formula in the cell where you want the result:

=COUNTIF(A1:A5,"")

This formula will count the number of cells in the range A1:A5 that contain a check mark.

There are a few other ways to insert a check mark in Excel, but these are the quickest and most common methods. So, next time you need to insert a check mark, try one of these methods.

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.