Excel Guides

Check Boxes in Excel

There are a few different ways to create check boxes in Excel. The first way is to use the Symbol font. To do this, type the character code for the check mark (252 for a filled check box or 168 for an empty check box), then press Alt+X to convert it to a symbol. You can then change the font back to whatever you want.

Another way is to use the Wingdings 2 font. Type an uppercase "P" for a filled check box or an uppercase "N" for an empty check box. Again, you can change the font back to whatever you want after.

The last way is to insert a check box control from the Forms toolbar. This method is probably the easiest, but it only works in Excel 2003 and earlier. To do this, go to View > Toolbars and make sure that Forms is checked. Then click on the check box control tool and click where you want to insert the check box.

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.