Forum Discussion
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...
The in-cell check box works in the desktop version of Excel if your version of Microsoft 365 is recent enough.
Clicking it sets the value of the cell it is in to TRUE/FALSE.
So the function was removed from some previous version, only to be readded later?
How do io find out if my version of 365 is recent enough?
I simply want to make it so that someone can change the value of each cell from false to true with a single click.
Yes, I realise that another work around could be a dropdown box with a true/false condition, but that turns a single click into 2 clicks interspaced with a precise mouse movement.
More effort, more time, and more chance of someone screwing up.
Multiplied by 400 lines this is a lot of opportunity for screwups, not to mention to time and frustration added.
How do io find out if my version of 365 is recent enough?
I simply want to make it so that someone can change the value of each cell from false to true with a single click.
Yes, I realise that another work around could be a dropdown box with a true/false condition, but that turns a single click into 2 clicks interspaced with a precise mouse movement.
More effort, more time, and more chance of someone screwing up.
Multiplied by 400 lines this is a lot of opportunity for screwups, not to mention to time and frustration added.
How do io find out if my version of 365 is recent enough?
Assuming you are on Windows, in Excel check File->Account. If you are on Current channel checkboxes shall be available.
