How to Create a Check Box in Excel 2007

By Christopher Kennedy

Microsoft Excel features many different options for creating the perfect spreadsheet. In addition to calculating data and presenting graphs a user can create a form complete with a radio button or even a check box. Coupled with Excel's strong data management, users can send their Excel spreadsheets as surveys, applications, and have the data all in one location. Adding a check box to an Excel 2007 spreadsheet can be done after enabling Developer settings.

Step 1

Open Microsoft Excel 2007.

Step 2

Click the "Office" button located in the left corner of the window represented by the Microsoft Office Logo.

Step 3

Click "Excel Options" located along the bottom of the menu on the right.

Step 4

Click the tab titled "Popular" and select the check box next to "Show Developer tab in the Ribbon." Click "OK" when you have finished to exit.

Step 5

Click the "Developer" tab along the Office menu. Click "Insert" and select the check box from the set of options.

Step 6

Click-and-drag your mouse to draw the check box to your desired size.