How to insert Checkbox in excel to simply click and tick it?

  • Follow


I just wanted to know how I can create a Check Box in Excel where I can 
simply chick the box and it gets Ticked.
0
Reply Utf 5/5/2010 5:46:01 AM

Insert a CheckBox from the Forms toolbar.



-- 
Regards
Dave Hawley
www.ozgrid.com
"Keegan" <Keegan@discussions.microsoft.com> wrote in message 
news:55CDC274-DE89-4717-8327-901032CEC23C@microsoft.com...
>I just wanted to know how I can create a Check Box in Excel where I can
> simply chick the box and it gets Ticked. 

0
Reply ozgrid 5/5/2010 5:50:44 AM

On May 5, 6:46=EF=BF=BDam, Keegan <Kee...@discussions.microsoft.com> wrote:
> I just wanted to know how I can create a Check Box in Excel where I can
> simply chick the box and it gets Ticked.

Assuming you may not know _exactly_ how to do it <g> . . .

1 Right-Click on a blank area of the menu area
2 On the list which appears click on Forms
3 Click on the CheckBox in this Forms toolbar.
4 Off the toolbar the mouse turns into a hair-cross
5 Click where you want the CheckBox to appear
6 Drag the shaded outline to position it accurately
7 Right-click within the shaded area but not in the checkbox
8 In the context menu which appears select Edit Text to change or
remove the text, dragging the shaded outline to size it.
9 In the right-click context menu (as in 7-8) select Format Control
10 Select the Control tab
11 Set the initial setting of the control box
12 Click in the Cell Link entry box, then click in the cell where you
want to place or receive the checkbox status
13 Click OK on Format Control

Alan Lloyd
0
Reply alanglloyd 5/5/2010 7:31:13 AM

If you're using Excel 2007, you need to have access to the Developer Tab - in 
Office button/Excel Options/Popular, the 3rd checkbox is Developer tab. Once 
you see the tab, in the Controls group, you'll see Insert dropdown - the top 
section is your forms controls (including checkbox) and the bottom section is 
your activeX controls (including checkbox). I recommend forms control 
checkbox.
By the way, to know if it's clicked or not, you should use the format 
control & assign the checkbox to a cell; then if it's checked, the cell will 
have TRUE, else it'll have FALSE.

"Keegan" wrote:

> I just wanted to know how I can create a Check Box in Excel where I can 
> simply chick the box and it gets Ticked.
0
Reply Utf 5/5/2010 2:21:01 PM

3 Replies
3345 Views

(page loaded in 4.34 seconds)


Reply: