Excel Checkbox in Cell

Question

Hey,

iam trying to add a checkbox in Excel, i found the developer tools and the active x elements but it only gives a checkbox above the sheet that i have to manually make smaller and adjust to the cells.

Is there an option to insert the checkbox into the cell itself and just drag down?

Also If ihave to do it manually how do i adress it in a function?

Best Danny

Answer 1

Hi DannyBerg!

There is an option to insert it in the cell itself but it is done manually (like you have to draw it like a rectangular shape).

To add a check box, click the Developer tab, click Insert, and under Form Controls, or active X control> click the check box.

Click in the cell where you want to add the check box, draw a rectangular shape in the cell and the check box will appear.

To edit the size, Right-click on the check box and click on the format control> click on the sidebar, then edit the size to what you want.

Tips: You can edit the height and width of the cells to make the Check box fit in more perfectly.

References: https://support.microsoft.com/office/9f201e46-8f6b-4a9d-a320-f44b28088cb0

Kind Regards, Shakiru