How-to · Excel for Mac
How to insert a checkbox in Excel on Mac: native Checkbox steps for Microsoft 365
To insert a checkbox in Excel on Mac, select the cells where you want the boxes, then choose Insert > Checkbox in Microsoft 365. Click a box to check it, or select several boxes and press Space to toggle them.
Quick answer
- Select the cells, then choose Insert > Checkbox. Microsoft lists this native option for Microsoft 365 for Mac.
- Click a box, or select boxes and press Space, to toggle them. Checked boxes hold TRUE and unchecked boxes hold FALSE.
- Press Delete to remove boxes. If any box is checked, the first press only unchecks them.
- Microsoft documents no Mac keyboard shortcut for checkboxes. Space and Delete are the documented keys.
- If Insert > Checkbox is missing, update Microsoft 365 first. The rollout is staged, so some users get it later.
What you need
- Microsoft 365 for Mac, the product listed in Microsoft's checkbox article
- A Microsoft 365 update that includes the staged rollout
- A workbook you can edit, with the cells you want to use
How to Insert a checkbox in Excel on Mac in Excel on a Mac
Open the workbook and find the target cells
Open the workbook in Microsoft 365 for Mac and go to the sheet that needs the checklist. Scroll so the target cells are on screen. Excel places the boxes in the whole range you select, so settle the range first.
Tip: Put a label in the row above the first box so the column has a clear name.
Select the range for the boxes
Click the first cell, then drag to the last one. For a task list, select B2 to B20. Hold Shift and click the last cell if you would rather not drag.
Tip: Select only the rows you need. Extra boxes are easy to miss.
Choose Insert > Checkbox
Open the Insert tab in the ribbon, then click Checkbox. Excel adds a box to each cell in the selected range.
Tip: If Checkbox is not on the Insert tab, read the troubleshooting section before you try the Developer tab route.
Toggle the boxes with a click or Space
Space
Click a box to toggle it. To change several boxes at once, select them and press Space. Each press toggles the selected boxes.
Remove boxes with Delete
Delete
Select the boxes, then press Delete. If any selected box is checked, the first press unchecks them. Press Delete again to remove the boxes. If every box is already unchecked, one press removes them.
Keep the values and drop the box shape
Select the cells that hold the boxes, then go to Home > Clear > Clear Formats. Microsoft says this removes the check box formatting and keeps the TRUE and FALSE values.
Tip: Check the cells afterward. Clear Formats is a different command from Delete, so pick the one that matches your goal.
Read the values in a formula
In an empty cell, type =COUNTIF(B2:B20,TRUE) to count checked boxes. Change TRUE to FALSE to count unchecked ones. Check the total against the boxes you can see.
What the native checkbox does in Excel on Mac
The native checkbox is part of the cells you select. A checked box holds TRUE. An unchecked box holds FALSE. Because the value lives in the cell, formulas can read it, so the box does more than show a tick.
Microsoft's Excel blog first published this feature on June 27, 2024. The post was updated on January 29, 2026 to revise availability. That update says Windows and Mac desktop are fully rolled out to Current, Monthly Enterprise and Semi-Annual channel users.
Pick the cells before you insert anything
Insert > Checkbox works on the range you select. Click the first cell, then drag to the last one. For a checklist, choose one column, such as B2 to B20, and leave the nearby columns alone.
TRUE, FALSE and formulas
Each box has a value behind it. Microsoft says a formula can reference the cell and receive TRUE or FALSE. That makes checkboxes useful for status columns, progress counts and totals.
A worked example: count finished tasks
Put task names in column A, from A2 to A20. Select B2 to B20 and insert the checkboxes there. In an empty cell, type =COUNTIF(B2:B20,TRUE). Excel returns the number of checked boxes.
Swap TRUE for FALSE to count the open tasks. Then check the total against the boxes you can see. A range that stops one row short is the usual reason a total looks wrong.
Keep the values and drop the boxes
Some workbooks need the results but not the boxes. A summary that someone only reads on screen may not need clickable cells. Clear Formats gives you that result. The TRUE and FALSE values stay in the cells, and formulas keep reading them.
Why Microsoft's docs list no Mac keyboard shortcut
Microsoft's pages name two keys for checkboxes, Space and Delete. They do not give a ⌘, ⌥, ⌃ or ⇧ combination for this feature. If a website lists a Mac shortcut for checkboxes, check it against Microsoft's page before you rely on it.
Use the Insert menu to create the boxes. The keys only toggle and remove them, so the mouse is the reliable route for inserting.
Why Insert > Checkbox might be missing on Mac
The most common cause is the rollout. Microsoft says features are released over time, so some users see an option before others do. The checkbox article gives no Mac build number, so you cannot compare a version and know for sure.
Start with an update. Install the latest Microsoft 365 updates, quit Excel completely, and open it again. Then look at the Insert tab one more time.
- Your update channel is not one that Microsoft named as fully rolled out. The January 29, 2026 update lists Current, Monthly Enterprise and Semi-Annual.
- You are in Excel for the web or on a non-production build. Microsoft ties web and mobile rollout to Production builds.
- You are comparing with a colleague on another channel. Their Insert tab can differ from yours during a staged rollout.
Known problem: the option disappears after an update
A Microsoft Q&A thread dated April 15, 2025 describes this problem. The poster used Microsoft 365 Excel version 2408 on Windows. After an update, the checkbox option was gone from the Insert tab, and existing boxes changed to TRUE or FALSE.
I found no Mac report with a confirmed cause or fix. The original poster said the suggested fixes failed. The thread was locked as a duplicate, with no cause or fix timeline given.
Use the Form Control check box as a fallback
Excel also has a Form Control check box. It comes from the Developer tab, and it behaves differently from the native box. Use it when the native option is missing and you need a box now. First, show the Developer tab.
- Open Excel > Preferences > Ribbon & Toolbar.
- Under Customize the Ribbon, select Main Tabs, then tick Developer.
- Select Save, then close Excel Preferences.
- Go to Developer > Insert > Form Controls, choose the check box icon, and click the cell.
Microsoft's Form Controls article is written for Windows. It says a Developer tab is needed to add check boxes, but it gives no Mac steps for showing that tab. The Developer tab article covers Excel for Microsoft 365 for Mac, so use the steps above and check that the menu names match your copy.
Native checkbox or Form Control: side by side
| Question | Insert > Checkbox | Form Control check box |
|---|---|---|
| Where you find it | Insert > Checkbox | Developer > Insert > Form Controls |
| Needs the Developer tab | No | Yes, per Microsoft's Form Controls article |
| Value in the cell | TRUE when checked, FALSE when unchecked | Not covered in the sources I checked |
| Excel for the web | Rolled out on Production builds, per Microsoft's January 2026 update | Does not work, per Microsoft's Form Controls article |
| Space key | Toggles selected boxes | Not covered in the sources I checked |
For new work, use the native checkbox. Keep a Form Control box only when an existing workbook depends on it. Mixing both kinds in one list causes most of the confusion.
Excel for the web, iPad and other versions
Microsoft's January 29, 2026 update says the feature is rolled out to web and mobile. That covers iPad, iOS and Android, for users on Production builds. The checkbox article's Applies To line does not list Excel for the web.
Third-party guides say Insert > Checkbox works in the browser. I could not confirm that on a Microsoft page. Test it in your own browser before you depend on it.
Which Excel version you need on Mac
Microsoft's checkbox article lists Excel for Microsoft 365 and Excel for Microsoft 365 for Mac under Applies To. It gives no Mac build number. For the native checkbox, a Microsoft 365 subscription is the version to use.
The Developer tab article also covers Excel 2024 for Mac and Excel 2021 for Mac. That matters only for the Form Control route, since the checkbox article does not name those versions.
Common mistakes on a Mac
- Selecting one cell, then expecting a whole column of boxes. Select the full range first.
- Pressing Delete once on a checked list and assuming the boxes are gone. The first press only unchecks them.
- Mixing the two kinds of box. A Form Control box does not behave like the native checkbox.
- Looking for a Mac shortcut in Microsoft's docs. None is documented, so use the Insert menu.
- Sending a file without checking the recipient's Excel. A box may not show if their update has not arrived.
- Editing a Form Control box in Excel for the web. Microsoft says the control is removed when you edit it there.
Build a checklist that stays readable
Give the checkbox column one job. Keep typed Yes and No answers in other columns, so each row holds one kind of value. Put a clear header above the boxes and keep it on screen while you scroll.
Name the column in the header row, such as Done. Then the next person who opens the file knows what the column means without asking you.
What to do next with your checklist
Once the boxes work, the next question is usually how to summarize them. Read how to make a pivot table in Excel on Mac for grouped counts by status.
If a status column needs values from another sheet, use XLOOKUP in Excel on Mac instead of retyping them. Keep the checkbox column as the one place where each status is set.
Excel shortcuts for this on Mac
| To do this | Press |
|---|---|
| Toggle one box by clicking it | Click |
| Toggle every selected checkbox | Space |
| Remove checkboxes (first press unchecks checked ones) | Delete |
If it does not work
- Insert > Checkbox is missing from the Insert tab
- Install the latest Microsoft 365 updates, quit Excel, and reopen it. The rollout is staged, so some users get the option later. If it is still missing, use the Form Control route with the Developer tab.
- Delete unchecked the boxes but did not remove them
- That is the expected first press. Press Delete again. Boxes are removed when every box in the selection is unchecked.
- Existing boxes now show TRUE or FALSE
- Undo the change if you can. Microsoft's Q&A thread describes this after an update on Windows, with no confirmed fix. Keep a saved copy of the workbook and report the problem to Microsoft Community.
- Form Control box vanished in Excel for the web
- Microsoft says Form Control check boxes do not work in Excel for the web, and editing them there removes them. Open the file in the Excel desktop app. Microsoft's page says Previous Versions can restore them.
- Space does nothing
- Space toggles the boxes you have selected. Select the boxes first, then press Space. Clicking a box also toggles it.
Faster with Lazur
Do it faster: ask Lazur while you are in Excel
Hold ⌥ ⌘ and say what you want. Lazur sees your Excel window. Lazur draws a circle and a label around the button or menu you need.
- 1
Hold ⌥⌘ and talk
- 2
Lazur draws a circle and a label around the button or menu you need.
- 3
You stay in Excel. Nothing to copy into a chat window.
Free for 3 days, then $18/month. Download for Mac
You say“Where is the checkbox button in Excel?”
Lazur · points at itLazur circles the Checkbox button on the Insert tab and labels it on your screen. You still click it yourself.
Questions people ask
Is there a Mac keyboard shortcut to insert a checkbox in Excel?
Not that Microsoft documents. Insert the boxes from the menu with Insert > Checkbox. The documented keys are Space to toggle and Delete to remove, and neither key inserts a box.
Why doesn't Insert > Checkbox show up on my Mac?
The feature is rolled out in stages. Microsoft's January 29, 2026 update names the Current, Monthly Enterprise and Semi-Annual channels for desktop. Update Microsoft 365 and restart Excel. If the option still does not appear, use the Form Control route.
Does the checkbox work in Excel for the web?
Microsoft's blog says web and mobile have the feature on Production builds. Its checkbox article does not list the web under Applies To. Test it in your browser before you rely on it.
What is the difference between a checkbox and a Form Control check box?
The native checkbox comes from Insert > Checkbox and holds TRUE or FALSE. The Form Control check box comes from the Developer tab. Microsoft says Form Controls do not work in Excel for the web.
How do I count the checked boxes?
Use COUNTIF with your own range and TRUE, such as =COUNTIF(B2:B20,TRUE). Change TRUE to FALSE to count the unchecked boxes. Check the total against the boxes on screen.
Which Excel version do I need on a Mac?
Microsoft's checkbox article lists Excel for Microsoft 365 for Mac and gives no build number. The Developer tab article also covers Excel 2024 for Mac and Excel 2021 for Mac, which matter only for Form Controls.
Can I remove all the checkboxes in one go?
Select the range that holds them, then press Delete. If any box is checked, the first press unchecks them. Press Delete again to remove the boxes.
Will the checkboxes still work after I send the file?
The TRUE and FALSE values are saved in the cells, so the data travels with the file. Whether the box shows depends on your recipient's Excel build and rollout, so ask them to check.
Sources
- Using check boxes in Excel · Microsoft Support · checked 2026-11-09
- Introducing Checkboxes in Excel · Microsoft Tech Community · checked 2026-11-09
- Form controls · Microsoft Support · checked 2026-11-09
- Use the Developer tab to create or delete a macro in Excel for Mac · Microsoft Support · checked 2026-11-09
- Checkbox in Insert tab is gone with last update · Microsoft Q&A · checked 2026-11-09
Try Lazur free for 3 days
Hold a key and ask. Lazur sees your screen, points at the button and talks you through it, in any Mac app. No credit card.