How to Create a Check Box in Excel 2007

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.

...
Insert a check box in your Excel spreadsheet.

Step

Open Microsoft Excel 2007.

Step

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

Step

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

Step

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

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

Step

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