How to Add a Checkbox and Other Form Controls to an Excel 2007 Spreadsheet

In: Microsoft

9 Sep 2008

Excel 2007 changed the menu system. You can only add form controls by using the “Developer” tab in the menu ribbon. By default the “Developer” tab is disabled. To enable the developer tab do the following:

  1. Click the circular Microsoft Office icon in the upper left corner of the Excel program
  2. Click the “Excel Options” button
  3. Select the left menu option “Popular”
  4. Check the option “Show the developer tab in the ribbon”
  5. Now the developer tab will appear on the ribbon. You can select the tab and press the “Insert” button to display check boxes and other form controls which can now be inserted into the spreadsheet.

Comment Form

About this blog

This blog is about technology related topics. It will primarily contain problems and solutions to IT problems that I encounter on a day-to-day basis. In addition interesting things I come across either on or off the internet will be posted here as well. I will also include step-by-step tutorials to common tasks people may need to do with their computers.

Web Hosting Discount

    Get the first month for only $0.01 using coupon code HGCOUPONBLOG. No contracts, cancel anytime.

Revolutionary One Time Password Device

Add to Technorati Favorites