Forum Discussion
JRees405
Oct 10, 2024Copper Contributor
Insert Multiple checkboxes at once.
Hi, I'm finding this very frustrating; I have an Excel 365 sheet of around 400 lines which I am constantly adding new columns to. I wish some of these new columns to be populated by checkboxes...
HansVogelaar
Oct 10, 2024MVP
That many check boxes would be difficult to manage anyway.
I'd let the user enter an "x" or something like that in the relevant column.
You can then filter on "x" or on "<>x".
By the way, if everyone has Microsoft 365 version 2408 or later, they should be able to use the new in-cell check box:
It's easy to insert multiple in-cell check boxes: select a range and click Checkbox on the Insert tab of the ribbon.