How To Insert A Checkbox In Excel?

Enable the Developer tab: File > Options > Customize Ribbon > check Developer > OK

Go to Developer > Insert

Under Form Controls, select Checkbox

Click on the worksheet where you want the checkbox

To edit the checkbox text, right-click the checkbox and select Edit Text

To move or resize the checkbox, right-click it and drag the border

To link the checkbox to a cell, right-click the checkbox > Format Control > Control tab > Cell link > select a cell > OK

Copy and paste the checkbox to add more checkboxes if needed

Suggested for You

Trending Today