Tick boxes make Excel easier to use when you are tracking tasks, approvals, packing lists, or simple yes-or-no choices. The fastest option in Microsoft 365 desktop Excel is the built-in checkbox command on the ribbon. Here is the clean way to add clickable boxes, manage older Form Controls, and use symbols when you only need a visible tick.
Insert a checkbox from the ribbon
Select the cell or range where you want the tick boxes to appear.
Open the Insert tab on the Excel ribbon.
Select Checkbox.
Use this first in Excel for Microsoft 365 or Excel for Microsoft 365 for Mac because it creates modern in-cell checkboxes.
Tick and untick boxes after adding them
Click a checkbox to switch it between checked and unchecked.
To change several boxes faster, select one or more checkbox cells and press the Spacebar.
If the Spacebar does not change the selected boxes, click one checkbox directly, then select the checkbox cells again and press Spacebar.
Find the Checkbox command when it is missing
The most common cause is that your Excel version does not include the modern in-cell checkbox command.
Microsoft lists Insert > Checkbox for Excel for Microsoft 365 and Excel for Microsoft 365 for Mac. It does not list Excel 2024, Excel 2021, Excel mobile apps, or Excel for the web for that modern checkbox command.
If Checkbox is missing from the Insert tab, use the supported desktop Form Control method or insert a static check mark symbol instead.
Use the older Form Control checkbox
Desktop Excel still supports checkbox controls through the Developer tab. These numbered steps are the Excel for Windows path.
- 1.Open File, then go to Options > Customize Ribbon.
- 2.Under Customize the Ribbon and Main Tabs, select the Developer check box.
- 3.Open Developer, select Insert, and choose Check Box under Form Controls.
- 4.Click the cell where you want to add the check box.
- 5.To duplicate it, right-click the control and select Copy > Paste.
Excel for Mac turns the tab on somewhere else. Open the Excel menu and select Preferences, choose View under Authoring, then select Developer tab under In Ribbon, Show. Open Developer, select the check box control you want, and click where it should go on the worksheet.
Format or link a Form Control checkbox
Form Control checkboxes are worksheet objects, not the newer in-cell checkbox format. To change one, right-click the control and select Format Control.
In the Format Control dialog box, open the Control tab to set Checked, Unchecked, or Cell link. Select OK when you are done.
To delete one, right-click the checkbox and press DELETE. Modern in-cell checkboxes use a different removal method from selected cells.
Remove modern checkboxes cleanly
Select the cells that contain the modern in-cell checkboxes.
Press Delete.
If any selected checkbox was checked, press Delete again after Excel changes the boxes to unchecked.
To remove the checkbox formatting but keep the TRUE or FALSE values, select the cells and choose Home > Clear > Clear Formats.
Unchecked modern checkboxes disappear with one press of Delete; checked ones need the second press.
Add a plain tick mark instead
Use a symbol when you want a printed check mark or visual tick, not a clickable checkbox.
- 1.Place the cursor in the cell where the symbol should go.
- 2.Select Insert > Symbols > Symbol.
- 3.Choose Wingdings in the Font box.
- 4.Enter 252 or 254 in the Character code box.
- 5.Select Insert, then select Close.
You can also use Segoe UI Symbol with character code 2705, 2713, or 2714.
Handle Excel for the web and mobile limits
The most common cause of checkbox trouble in Excel for the web is that browser Excel does not support the same checkbox controls as desktop Excel.
Microsoft says Excel for the web cannot use legacy check box controls. It also warns that editing a workbook with unsupported objects in the browser can remove objects such as check boxes and combo boxes.
If a workbook needs older Form Control checkboxes, select Open in Excel and add or edit the controls in the desktop app.
Microsoft does not offer a current native checkbox insertion method for Excel mobile apps.
Try a dropdown when checkbox tools are unavailable
A dropdown works when each cell only needs a choice such as Yes, No, or a tick-style value. It is not a native checkbox, but Excel supports it through data validation in current desktop Excel and Excel for the web.
Select the cells, open Data, choose Data Validation, set Allow to List, type the list values in Source separated by commas, keep In-cell dropdown selected, and choose OK.
If a dropdown does not fit, use desktop Excel with Insert > Checkbox for modern in-cell boxes or Developer > Insert > Form Controls > Check Box for older desktop controls.
Skip older instructions that use Developer > Insert > ActiveX Controls > Check Box. Microsoft says ActiveX controls are disabled for security reasons and do not work in newer versions of Excel. In Microsoft 365 and Office 2024 they are disabled by default, so you cannot create new ActiveX objects or interact with existing ones, and Microsoft strongly encourages leaving them disabled. If a trusted workbook genuinely needs them, they can be turned back on under File > Options > Trust Center > Trust Center Settings > ActiveX Settings.
Frequently Asked Questions
Can I insert tick boxes in Excel for free on the web?
Excel for the web cannot use legacy check box controls, and Microsoft does not list the modern Insert > Checkbox feature for the web. Use the desktop app for checkboxes or use a data validation dropdown instead.
Are Excel tick boxes the same as check mark symbols?
No. A checkbox is clickable or toggleable. A check mark symbol is only a static character in a cell.
Why did pressing Delete only untick my boxes instead of removing them?
With modern in-cell checkboxes, Delete first changes checked boxes to unchecked. Press Delete again after they are unchecked to remove them.
Do I need the Developer tab for Excel checkboxes?
Not for the modern Microsoft 365 checkbox command. You only need the Developer tab for the older Form Control checkbox method in desktop Excel.
