Nov
2
2011

How to insert a simple (Tick) Checkbox into office 2007?

Today I was struggling to insert a checkbox in Excel 2007, found a good tip as below,

This can be done via Developer ribbon bar. If you do not see Developer as one of the tab options along the top (in the ribbon bar), do the following:

1. Click the Office logo in the top left corner
2. Down below besides Exit Excel you will find ‘Excel Options’, click it
3. In the ‘Popular’ window, check the box for ‘Show Developer tab in the Ribbon’
4. Click OK

On the Developer tab, in the Controls section you should see an icon labeled ‘Insert’. Click this icon to see the available Forms and ActiveX objects you can insert.

In Excel 2007, the ‘ActiveX’ options are equivalent to the ‘Control Toolbox’ options in Excel 2003 and earlier. I’d suggest selecting from the ActiveX items rather than the Forms items for any version of Excel that supports it.

Download PDF

Related Posts

About the Author: Nitin Garg

Indian born, trekker, biker, photographer, lover of monsoons... I love to blog the topics I research and find useful for self or online community to save time and energy :) Everything you read on my blog is my own personal opinion!

Leave a comment

Subscribe to this blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 263 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

December 2020
M T W T F S S
« Nov    
 123456
78910111213
14151617181920
21222324252627
28293031  

View Post by Categories

%d bloggers like this: