How to Add Checkboxes in Excel with Claude AI (and Count Them with COUNTIF)
I wanted to see whether Claude inside Microsoft Excel could handle something visual instead of a formula: adding a column of real, clickable checkboxes. One short prompt, no fiddling with Form Controls — that was the test. Here's how it went, plus the manual fallback and the formula I use to count the ticks.
The setup
I'm working in a spreadsheet of fictitious customers. I need to track whether each one has been notified about a new return policy, and I want that to live in column I with a checkbox in every row — not text, not a Yes/No dropdown, an actual checkbox.
The prompt I sent to Claude
I clicked the Claude button in the ribbon to open the task pane, then typed exactly what I wanted into the prompt box:
Add a column and name that column "Notified about return policy". Inside that column, I actually want to see checkboxes.
The wording matters. I specifically named the column so Claude wouldn't guess at the heading, and I called out "checkboxes" so it would use the native control instead of TRUE/FALSE text or a workaround.
What Claude built
A few seconds later Claude had added column I, titled it Notified about return policy, and dropped a checkbox into every row of the table. No formulas to clean up afterward — these are Excel's native checkboxes, the same ones you'd get from the Insert tab.
I clicked a few of them to confirm they behave the way I expected: tick on, tick off, no surprises.
Don't have Claude? Insert checkboxes manually
If you don't have the Claude add-in available, you can get the same result yourself in a couple of clicks. Select the range you want to fill, then on the Insert tab, in the Controls group, click Checkbox. Excel drops a native checkbox into every selected cell. I've covered this in more detail in my guide to the new Excel Checkbox feature.
Count the ticks with COUNTIF
Once your checkboxes are in place, counting them is straightforward. Each checked box is stored as TRUE and each unchecked box as FALSE, so COUNTIF handles it directly:
=COUNTIF(range, TRUE) — counts the boxes that are checked.
=COUNTIF(range, FALSE) — counts the ones still unchecked.
In this example I'd point the range at column I. The "still unchecked" count is the one I actually care about — that's how many customers haven't been notified yet.
Bottom line
The takeaway: Claude in Excel handles UI work like inserting native checkboxes just as cleanly as it handles formulas. If you've got the add-in, a single descriptive prompt saves you a trip to the Insert tab. If you don't, the manual path is a few clicks longer — and COUNTIF closes the loop either way.
Related guides
