Forum Discussion
EveSC1300
Jul 12, 2021Copper Contributor
Inserting a checkbox into Excel Online
Hello, is there any way to insert a checkmark box in the Online version of Excel, which doesn't have access to the Developer tab? Thank you!
- Jul 12, 2021
No, it's not supported
PeterBartholomew1
Jan 23, 2024Silver Contributor
I believe the new check boxes, that are more like conditional formats rather than form controls, do work online. On the desktop they are set using
> Insert / Cell Controls / Checkbox
The checkbox appears as formatting within a cell that actually contains TRUE/FALSE. Applying further condition formatting can achieve other effects such as the red/green cells shown in the picture. Clicking on the cell still toggles the setting.
- SergeiBaklanFeb 01, 2024MVP
Nope, it's only on Desktop, Beta. Status is in What's New https://techcommunity.microsoft.com/t5/excel-blog/what-s-new-in-excel-january-2024/ba-p/4026581
- PeterBartholomew1Feb 01, 2024Silver Contributor
There must be some logic to that! On the desktop I have the option of using form controls or even VBA events and shapes. It is online that there is a dearth of controls so I had hoped that might be the primary platform targeted .
- SergeiBaklanFeb 01, 2024MVP
Who knows what is in background, devil is in the details.