How to Make a Check Box in Excel

By Danielle Cort

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.

Display Developer Tab

Step 1

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

Step 2

Click "Customize Ribbon" to display two panes.

Step 3

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

Make Check Box

Step 1

Click the "Developer" tab on the ribbon.

Step 2

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

Step 3

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 4

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.