1. Open your Excel worksheet
Launch Excel and open the file where you want to add checkboxes to one or more cells.
2. Enable the Developer tab if needed
If the Developer
tab isn’t visible, go to File > Options
(Windows) or Excel > Preferences
(Mac), then customize the ribbon and check Developer
.
3. Click Insert in the Developer tab
Go to the Developer tab, then click Insert
and choose the Checkbox
(Form Control) option from the dropdown.
4. Click the cell where you want the checkbox
Click anywhere in the worksheet to place your first checkbox. Resize or move it as needed.
5. Copy the checkbox to other cells
To reuse it, copy and paste the checkbox into other cells where you want it to appear.
6. (Optional) Link the checkbox to a cell
Right-click the checkbox, choose Format Control
, go to the Control
tab, and set a Cell link to track if the box is checked (TRUE/FALSE).