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 that I can then run filters on.

After much searching online I have enabled the developers tab, but this only seems to allow me to draw one check box at a time, and these new boxes do not seem to be linked to the cells i draw them over.

I want a way to select a large range of cells and turn them all into checkboxes with a single action.

Why has the very simple task of turning a range of cells into checkboxes become so difficult and convoluted?
If I hadn’t already shared this sheet with other people, i would have migrated everything over to googlesheets.

​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 that I can then run filters on.After much searching online I have enabled the developers tab, but this only seems to allow me to draw one check box at a time, and these new boxes do not seem to be linked to the cells i draw them over. I want a way to select a large range of cells and turn them all into checkboxes with a single action.Why has the very simple task of turning a range of cells into checkboxes become so difficult and convoluted?If I hadn’t already shared this sheet with other people, i would have migrated everything over to googlesheets.  Read More

​