Share via

How do I add checkboxes to multiple cells at once in Excel?

Anonymous
2024-11-12T20:05:36+00:00

I have Excel 365, there was no checkbox in the Ribbon, so I added it, but it only adds one. The Developer tab is only adding one, too. Neither of them are being added with good formatting to the one cell. I need hundreds of checkboxes that look good in the cells.

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.4K Reputation points MVP Volunteer Moderator
    2024-11-12T20:20:56+00:00

    If you have Microsoft 365 version 2409 or later, you should have a Checkbox button on the Insert tab of the ribbon.

    If you select multiple cells. then click this button, a check box will be inserted in every selected cell.

    If you have an older version of Excel without this Checkbox button, you can insert only one check box at a time from the Developer tab.

    6 people found this answer helpful.
    0 comments