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

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.

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

Sure, I can help you with that!

Here are the steps to insert a checkbox in Excel:

1. First, make sure that the Developer tab is visible in the Ribbon. If it's not visible, you can enable it by going to File Options Customize Ribbon, and then checking the box next to "Developer" in the right-hand pane.
2. Click on the Developer tab in the Ribbon.
3. Click on the "Insert" drop-down menu in the Controls group, and select "Checkbox" under the Form Controls section.
4. Click and drag to draw the checkbox where you want it to appear on your worksheet.
5. Right-click on the checkbox and select "Format Control" from the context menu.
6. In the Format Control dialog box, go to the "Control" tab.
7. Under the "Checked" section, select the "Checked" option.
8. Click OK to close the dialog box.

Now, when you click on the checkbox, it should get ticked. You can also copy and paste the checkbox to other cells in your worksheet.

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

Insert a CheckBox from the Forms toolbar.



--
Regards
Dave Hawley
www.ozgrid.com
"Keegan" wrote in message
...
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.

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

On May 5, 6:46�am, 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.

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

Just to make sure that select right "check box" in FORMS from TOOL bar.
There is another check box available in CONTROL TOOL BOX. dont select that

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

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.