How to Insert a Checkbox in Excel: Easy Step-by-Step Guide (2022)

If you want to collect user input in your spreadsheet there’s no better way than the checkbox.

Checkbox in Excel - example

User-friendly, slick-looking, and easy for you to work with. Well… After you learn it at least.

If you’re having a hard time understanding the ins and outs of checkboxes, look no further.

Whether you’re into looks or functionality, I’ll guide you through everything step-by-step.

If you want to tag along, please download my sample data workbook here.

Let’s dive in🤿

Adding the Developer tab to Excel

There’s only one way to create a checkbox in Excel, and that’s from the Developer tab.

So, if you don’t see the Developer tab in your Ribbon already, you need to insert it first.

1. Click File on the Ribbon, and then click Options.

2. Click on ‘Customize Ribbon’.

3. Make sure there’s a checkmark in the Developer checkbox (kinda meta, right?)

Checkbox in Excel - Add Developer tab in Excel

Click OK and now the Developer tab is visible from the Excel Ribbon.

How to insert a checkbox in Excel

Here we have a small list of upsells.

In this list, a salesperson or the customer should be able to easily select the relevant upsells to the order.

And checkboxes are the perfect tools for that.

Eventually, we want that list to be able to calculate the total upsell price automatically, based on the selections. But, let’s save that for later and start with just getting the checkboxes into the spreadsheet.

Kasper Langmann, Microsoft Office Specialist

1. Go to the Developer tab (here’s how to add it) and click Insert.

2. In the menu that appears, pick the Check Box form control.

Checkbox in Excel - Insert Form Controls Check Box

Don’t select the ActiveX Check Box control. The reason why is complicated but for 99% of checkbox creators, the ‘Form Controls’ Checkbox is more than enough👍

3. Insert the checkbox by dragging its outline in your spreadsheet somewhere.

How to insert a checkbox in Excel - Drag Form Controls Check Box

4. Change the name and size of the checkbox, and move it so it fits what you’re trying to achieve.

The checkbox doesn’t have to have a visible name. You can just double-click the name and delete it, and make the checkbox all small like this if you want.

Checkbox in Excel - Form Controls Check Box small example

Voila! Now the user (and you) can left-click the checkbox to put a checkmark in it🙌

Insert multiple checkboxes in Excel

Now, you’ve learned how to insert a checkbox in Excel.

Easy peasy lemon squeezy🍋

But in many cases, you want to insert multiple checkboxes.

You do that by first inserting one checkbox, and then copying either the checkbox or the cell that contains the checkbox.

1. After you’ve inserted a checkbox, right-click it and select ‘Format control’.

How to insert a checkbox in Excel - multiple check boxes

2. In the ‘Format Control’ dialog box go to the Properties tab.

3. Make sure the middle option ‘Move but don’t size with cells’ is selected and click OK.

Checkbox in Excel - Format Control Dialog Box Properties tab

4. Now, copy (or drag) the cell containing the original checkbox anywhere you want it.

Checkbox in Excel - Copying Check Box Form Control

Visually, the upsell list is complete👏

Users are now able to indicate which upsells they want.

Checkbox in Excel - Multiple Form Controls Checkboxes

BUT this doesn’t do anything but visually indicate the user’s choices.

By linking the checkboxes to cells we can make it calculate the upsells total automatically.

Kasper Langmann, Microsoft Office Specialist

How to link checkboxes to cells

Now, this is where the fun begins.

A visual checkmark in a checkbox doesn’t allow for any calculation. It’s pure visuals.

But you can link the checkbox to a cell so it displays a TRUE or FALSE value when it’s checked or unchecked.

It’s basically like making a cell reference.

1. Right-click on the first checkbox and click ‘Format Control’

Right-click to Format Control Check Box

2. In the ‘Format Control’ dialog box, go to the ‘Control’ tab.

3. Select the ‘Unchecked’ option (radio button). That ensures the checkbox is unchecked by default when you open the spreadsheet containing it.

If you want the checkboxes to be checked by default, then select that option instead🕵️‍♂️

Format Control dialog box for Check Box - Unchecked option from Control tab

4. In the ‘Cell link’ box make a reference to the cell you wish to display either TRUE or FALSE depending if the checkbox is checked or unchecked.

Checked = TRUE, unchecked = FALSE.

Cell link from check box to Excel cell

5. Do the same for all the checkboxes.

It should look like this by now.

Checkbox in Excel - Cell link example

If the FALSE (or TRUE) values don’t show, try checking and unchecking the checkboxes a few times.

Now, all you need is a formula that adds up the upsells.

6. Write the formula:

=SUMIF(D2:D5, “TRUE”, B2:B5)

Checkbox in Excel - Formula to add TRUE values

And that’s it!

Your interactive user interface now adds up the upsell prices from the chosen upsells. All selected by checking and unchecking cool-looking checkboxes.

Well done💪

To make this look prettier, change the font color to white on all the linked cells.

Kasper Langmann, Microsoft Office Specialist

Conditional formatting based on checkboxes

Now that you have established a cell link from the checkbox to the cell, you can do lots of things with it.

You can even use conditional formatting to add some visual interactivity.

That could be something like highlighting the text if the checkbox is checked. This works quite well when you have multiple checkboxes.

Example of conditional formatting from linked cells (multiple checkboxes)

Let’s try that.

1. If you haven’t already, insert cell links from your checkboxes.

2. Select the titles of the items, in A2:A5, and click ‘Conditional formatting’ on the Home tab.

3. Click on ‘New rule’ and select ‘Use a formula to select which cells to format’.

4. Type the formula: =D2=TRUE

5. Define the format you want to apply if the formula is true and press OK.

Now, the upsell names are highlighted when the checkbox is checked – all due to linked cells.

Dynamic highlight based on linked cells with conditional formatting

How to format your checkbox

If you want to make your checkbox look a little cooler, you can format it (almost) any way you want to.

Note that this formatting is static (normal formatting) and not dynamic (conditional formatting).

1. Right-click your checkbox and click ‘Format Control’.

2. In the control dialog box, go to the ‘Colors and Lines’ tab.

Formatting options for Form Controls Check Boxes

3. Choose the formatting you want and press OK.

And if you’re feeling crazy, you might end up with something like this🎉

Form c

VIDEO: How to insert checkboxes in Excel

Watch this video to learn how to insert a checkbox in Excel in just a few minutes.

That’s it – Now what?

That’s how to insert a checkbox in Excel.

Pretty cool, huh?😎

I hope you’re as excited about the interactive capabilities of checkboxes as I am.

As I described earlier, automation functions like IF and SUMIF, and even VLOOKUP, work great with checkboxes in Excel.

So, do you want to learn how to use these functions?

Then enroll in my free 3-part training and learn them (+ pivot tables) in 30 minutes.

Other resources

As I showed you in this guide, conditional functions such as IF/IFS and SUMIF work very well with a checkbox in Excel.

If you want to geek out on the possibilities in the developer tab, read more about it here.

Also, if you don’t need an actual checkbox but just the checkmark symbol, you can read up on that here.

Frequently Asked Questions

If I didn’t answer all your questions in the guide, please have a look below. Maybe you’re lucky🤞

You delete a checkbox in Excel by right-clicking it, pressing the Esc key, and then pressing the Delete key.

The same method is used to delete multiple checkboxes but you must hold down Shift while right-clicking the checkboxes.

If you don’t need the interactive capabilities of a Form Control checkbox, then maybe the checkmark symbol is enough for you.

You insert the checkmark symbol by going to the Insert tab and clicking the Symbols button to the right.

Pick the check mark symbol and insert it in your spreadsheet.