How To Add A Checkbox In Excel?

Enable the Developer tab in Excel

Go to File

Select Options

Click Customize Ribbon

Check the Developer box

Click OK

Open the Developer tab

Click Insert

Under Form Controls, select the Check Box option

Click on the worksheet where you want the checkbox

Resize or move the checkbox if needed

Edit the checkbox label by right-clicking and selecting Edit Text

To link the checkbox to a cell, right-click it and select Format Control

Go to the Control tab

Set the Cell link field

Click OK

Suggested for You

Trending Today