How to Make a Check Box in Excel

Adding a check box in Excel can streamline the data entry process, particularly for users who may not be familiar with the program. By including check boxes, you can create a list of choices for users in a form that they do not have to type. Adding a check box also limits what a user can enter and can prevent errors. Excel includes a “Developer” section that allows you to design special data fields such as a check box.

...
You need to activate the Developer section before adding check boxes in Excel..

Display Developer Tab

Step

Click the “File” tab on the Ribbon and select “Options” from the left panel.

Step

Click “Customize Ribbon” to display two panes.

Step

Click the box next to “Developer” to select it in the right pane. Click “OK.”

Make Check Box

Step

Click the “Developer” tab on the ribbon.

Step

Click “Insert” and select the check box. A cross will appear on the screen.

Step

Click and drag to insert a box with a check box and text. Select the text next to the check box, delete it and insert your own text.

Step

Right-click the check box you created and select "Format Control" to format it. You can modify colors and lines, change its size or add protection.