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.
Display Developer Tab
Click the "File" tab on the Ribbon and select "Options" from the left panel.
Click "Customize Ribbon" to display two panes.
Click the box next to "Developer" to select it in the right pane. Click "OK."
Make Check Box
Click the "Developer" tab on the ribbon.
Click "Insert" and select the check box. A cross will appear on the screen.
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.
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.