How to Insert a Checkbox in Excel in 4 Easy Steps

Learn more quick and easy excel hacks with our free templates.

Download Now: Free Excel Templates
Martina Bretous
Martina Bretous

Published:

Adding a checkbox to your workbook may sound simple but it can expand the possibilities of what you can do in Excel.

excel user inserts a checkbox in workbook

From checklists to graphs, there’s so much you can do. However, it starts with the checkbox.

Learn everything you need to know about checkboxes below.

Download 10 Excel Templates for Marketers [Free Kit]

How to Insert a Checkbox in Excel

  1. Add the developer tab to your Ribbon.

  2. Navigate to the Developer tab and locate the "Checkbox" option.

  3. Select the cell where you want to add the checkbox control then click the checkbox.

  4. Right-click the checkbox to edit the text and adjust sizing.

To do this on Windows, click File > Options > Customize Ribbon. Then, select the Developer checkbox and click "save." On IOS, click Excel > Preferences > Ribbon & Toolbar > Main Tabs. Then, select the Developer checkbox and save.

On Windows, there are a few extra steps to see the checkbox option. Under the Developer tab, click "Insert" and under "Form Controls," click the checkbox icon.

Note: Currently, you cannot use checkboxes in the web version of Excel. If you upload a workbook with these controls, you’ll first have to disable them to start editing.

How to Format a Checkbox in Excel

  1. Open up the format control.

  2. Modify the value and cell link, then click "OK."

To access it on Windows, right-click the checkbox and select "Format Control." On IOS, navigate to the "Format" tab and select "Format Control."

With value, there are three options:

  • Unchecked – This displays a box that is unchecked and returns a "FALSE" statement.
  • Checked – This displays a box that is checked and returns a "TRUE" statement.
  • Mixed – This will leave the checkbox empty as neither a true or false statement until an action is taken.

As for the cell link, this contains the checkbox status (true or false) of the cell it’s referencing.

Now that you have those details down, you can start fully customizing your checkbox.

How to Delete A Checkbox in Excel

Deleting a checkbox in Excel is a simple two-step process:

  1. Right-click the checkbox.
  2. Click "delete" on your keyboard.

excel marketing templates

 

Topics: Excel

Related Articles

We're committed to your privacy. HubSpot uses the information you provide to us to contact you about our relevant content, products, and services. You may unsubscribe from these communications at any time. For more information, check out our Privacy Policy.

Tired of struggling with spreadsheets? These free Microsoft Excel templates can help.