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

Mixed – This will leave the checkbox empty as neither a true or false statement until an action is taken.Īs for the cell link, this contains the checkbox status (true or false) of the cell it’s referencing.

Checked – This displays a box that is checked and returns a “TRUE” statement.

Unchecked – This displays a box that is unchecked and returns a “FALSE” statement.

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

Modify the value and cell link, then click “OK.”.

If you upload a workbook with these controls, you’ll first have to disable them to start editing. Note: Currently, you cannot use checkboxes in the web version of Excel. Under the Developer tab, click “Insert” and under “Form Controls,” click the checkbox icon. On Windows, there are a few extra steps to see the checkbox option. Then, select the Developer checkbox and save. Then, select the Developer checkbox and click “save.” On IOS, click Excel > Preferences > Ribbon & Toolbar > Main Tabs. To do this on Windows, click File > Options > Customize Ribbon. Learn about how to run a macro from buttons on either the View or Developer tab.

Right-click the checkbox to edit the text and adjust sizing. You can run a macro from the Macros button on the View tab or the Macros button on the Developer tab.

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

Navigate to the Developer tab and locate the “Checkbox” option. Open Excel, and on the Ribbon, click the Developer tab (if its missing, follow these instructions to show it) Click the Add-ins button.

Learn everything you need to know about checkboxes below.

Adding a checkbox to your workbook may sound simple but it can expand the possibilities of what you can do in Excel.įrom checklists to graphs, there’s so much you can do.

How to view developer tab in excel