Thursday, 11 July 2013

Add checkboxes to an Excel spreadsheet


Designing a spreadsheet for you may not require detailing. But, if you are preparing it for others then you need to make it more mouse-friendly. Let’s see this technique below on Excel 2007, 2010, and 2013.


Excel 2010 or 2013

· Insert checkboxes on Excel’s Developer lab. This tab is hidden by default. To make it visible in Excel 2010 or 2013, click the “File” tab.

· Select “Options.”

· After then, click “Customize Ribbon.” Then you will see two lists.

· Check for the right side list which should be titled with “Main Tabs.”

· Go to that and check the option “Developer.”

Excel 2007
·         Click the Office orb in the upper-left corner.
·         Go to “Excel options” button available near the lower-right corner of the resulting pop-up box.
·         Then choose “Popular” in the left pane.
·         Check “Show Developer” tab in the Ribbon.
After opening Developer tab, following instructions work for all three versions:
·         Click the “Developer” tab and then choose the “Insert” icon in the “controls” section.
·         From the resulting pop-up menu, select the checkbox icon in the “Form Controls” section.


Now, the mouse pointer will turn into a plus sign. Just click it where you want the checkbox to appear. Also, you can drag and drop it somewhere else later.

· Check the checkbox up. Right-click it and select “Format Control.” Various options available here, these two are particularly important.

· By clicking the “Control tab”, go to Cell Link field and enter an address. The content changes as per the checkbox. If it is checked then it will display True. If it is unchecked then it will display False.

This is how you can create checkbox for Excel. For more suggestions, contact Techvedic’s computer support helpdesk, as per below contact-details:

U.S. +855-859-0057 ( )

U.K. +800-635-0716 ( )

CA 1-855-749-5861 (

AU 1-800-197-298 ( )

We would be more than happy to help you. We are available 24/7.


Post a Comment