Check boxes in Libre Calc?

[Cosmic6506]

Is it possible to create a check box like he does in this Tiktok but in Libre Calc (sorry for brainrot souneffects )? Or can I only make a floating checkbox beside a cell like they showed in this topic?

[fpy]

@Cosmic6506

floating

How to create check boxes in a spread sheet?

One other handy thing – if you set it to anchor to cell under the “General” properties, the checkbox will move properly when you add/remove rows/columns around it; by default it anchors to the sheet, so will not move

[Cosmic6506]

I was rather thinking if it is possible to make the selected cell into a checkbox. In that example you create a box over a cell which then get a check box linked to it, but I want to keep the cells I have right now and link B3 to A3 whereas B3 has the check box in it. The colored cells in my example is where the check box would’ve been.

Allbins köplista.xlsx (7.8 KB)

[Lupp]

I can’t see how your sheet (WHY XLSX ?) exemplifies what you tried to describe.
If you want to get a tool placing a checkbox into the selected cell, anchor it there, and set the cell as its “Linked cell”, you will need to write some user code.