Excel Guides

Functioning Check Boxes in a Protected Worksheet in Excel

When creating a protected worksheet in Excel, you have the option to include check boxes. Check boxes can be used to allow users to select certain options, or to mark certain items as complete. If you want to include check boxes in your protected worksheet, there are a few things you need to do.

First, you need to insert the check boxes. To do this, go to the Insert tab and click on Shapes. From the drop-down menu, select the Check Box option. Then, click and drag to draw a check box on your worksheet.

Once you have inserted the check boxes, you need to link them to cells. To do this, right-click on the check box and select Format Control. In the Control tab of the Format Control dialogue box, click on the Cell link field and enter the cell address that you want to link the check box to.

Now that your check boxes are inserted and linked to cells, you need to protect the worksheet. To do this, go to the Review tab and click on Protect Sheet. In the Protected Sheet dialogue box, make sure that the Locked option is selected for both the cells with check boxes and the cells that are linked to them. Then, click OK. Your worksheet is now protected and users will not be able to change any data or delete any check boxes.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.