Jul 12 2021 09:14 AM
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 09:23 AM
SolutionNo, it's not supported
Jan 04 2022 06:34 AM
Jan 07 2022 10:25 AM
@edurshpek Is there a way to suggest this update be made? I am also moving from google sheets to Microsoft and finding that these items may seem small, but have a large impact on an organization as a whole.
Jan 07 2022 11:30 AM
Practically the only way is to submit your idea here Excel · Community (microsoft.com) (or vote for similar one if already exists).
Jan 13 2022 11:27 AM
Jan 18 2023 06:33 PM
Mar 02 2023 01:39 AM
This would be very useful in 365. We have some projects sat in excel as a record of what to do and next steps. So many people have the file open that you can't pull the copy locally to add more information with check boxes.
Jun 08 2023 03:52 AM
Sep 19 2023 03:29 AM
Sep 19 2023 04:58 AM
If it is the functionality you need, rather than the appearance, I believe Slicers can be used to restrict the categories presented within a Pivot Table. The list could then be used within FILTER to down-select tabular data..
Jan 22 2024 11:25 PM
Hi, @EveSC1300 , I was facing the same problem as you after I researched and found a solution for this problem, I hope it will help you, the check box is not checked box by ticking, but you can create it this way as a drop list:
Step 1: Click on the Spreadsheet field you want to add the check box.
Step 2: From the ribbon menu click on Data --> Data validation.
Step 3: Click on Setting --> Allow --> List --> Source copy this "☐, ☑" and paste it inside the field --> click Ok.
Step 4: Align the text into the center, now you can see, that it is worked.
Good luck!
Jan 23 2024 04:47 AM
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.
Feb 01 2024 04:00 AM
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
Feb 01 2024 09:51 AM
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 .
Feb 01 2024 02:45 PM
Who knows what is in background, devil is in the details.
Feb 17 2024 07:57 AM
@SergeiBaklan et al.
I just found out that the Boolean checkbox feature is at the Beta stage, and it hasn't been rolled out as yet!
Like many, I used the checkbox in Google Sheet as common a row or column.
I was so shocked on learning that this feature is beta in Excel!
In VB/VBA this option is native, but you'll have to load a form first!
Let's Microsoft rollout an update soon!
Jul 12 2021 09:23 AM
Solution