Insert Checkbox in Excel

Now you can Insert Checkbox in excel to mark items as completed. The excel checkbox are actionable and very clear visual indicators . These checkbox can be inserted very easily in excel spreadsheets and these are primarily used to task lists and checklists.
How to Insert Checkbox in Excel
You can insert form controls such as check boxes or option buttons to make data entry easier. Check boxes work well for forms with multiple options. Option buttons are better when your user has just one choice.

Sample check boxes Sample radio button controls

To add either a check box or an option button, you’ll need the Developer tab on your Ribbon.

Notes: To enable the Developer tab, follow these instructions:

In Excel 2010 and subsequent versions, click File - Options - Customize Ribbon , select the Developer check box, and click OK.

In Excel 2007, click the Microsoft Office button Office button image - Excel Options - Popular - Show Developer tab in the Ribbon.

To add a check box, click the Developer tab, click Insert, and under Form Controls, click Button image .

the check box control on the ribbon

To add an checkbox , click the Developer tab, click Insert, and under Form Controls, click Button image .

the radio button control on the ribbon

Click in the cell where you want to add the check box or option button control.

Tip: You can only add one checkbox or option button at a time. To speed things up, after you add your first control, right-click it and select Copy -Paste.

To edit or remove the default text for a control, click the control, and then update the text as needed.

edit text of a checkbox

Tip: If you can’t see all of the text, click and drag one of the control handles until you can read it all. The size of the control and its distance from the text can’t be edited.

How Format a checkbox in excel
After you insert a check box or option button, you might want to make sure that it works the way you want it to. For example, you might want to customize the appearance or properties.

How To format a checkbox in Excel

right-click the control, and then click Format Control.

In the Format Control dialog box, on the Control tab, you can modify any of the available options:

Checked: Displays an option button that is selected.

Unchecked: Displays an option button that is cleared.

In the Cell link box, enter a cell reference that contains the current state of the option button.

The linked cell returns the number of the selected option button in the group of options. Use the same linked cell for all options in a group. The first option button returns a 1, the second option button returns a 2, and so on. If you have two or more option groups on the same worksheet, use a different linked cell for each option group.

Use the returned number in a formula to respond to the selected option.

For example, a personnel form, with a Job type group box, contains two option buttons labeled Full-time and Part-time linked to cell C1. After a user selects one of the two options, the following formula in cell D1 evaluates to "Full-time" if the first option button is selected or "Part-time" if the second option button is selected.

=IF(C1=1,"Full-time","Part-time")

If you have three or more options to evaluate in the same group of options, you can use the CHOOSE or LOOKUP functions in a similar manner.

Click OK.

How to delete checkbox in excel

Right-click the control, and press DELETE.

Download Practice Files from
http://www.myelesson.org/downloads

** Useful Excel formulas and Functions **
10 Most Used Formulas MS Excel
https://www.youtube.com/watch?v=KyMj8HEBNAk

Learn Basic Excel Skills For Beginners || Part 1
https://www.youtube.com/watch?v=3kNEv3s8TuA

10 Most Used Excel Formula
https://www.youtube.com/watch?v=2t3FDi98GBk
**Most Imporant Excel Formuls Tutorials**

Learn Vlookup Formula For Beginners in Excel
https://www.youtube.com/watch?v=vomClevScJQ

5 Excel Questions Asked in Job Interviews
https://www.youtube.com/watch?v=7Iwx4AMdij8

Create Speedometer Chart In Excel
https://www.youtube.com/watch?v=f6c93-fQlCs

Learn the Basic of Excel for Beginners || Part 2
https://www.youtube.com/watch?v=qeMSV9T1PoI

Create Pareto Chart In Excel
https://www.youtube.com/watch?v=2UdajrDMjRE

How to Create Dashboard in Excel
https://www.youtube.com/watch?v=RM8T1eYBjQY

Excel Interview Questions & Answers
https://www.youtube.com/watch?v=Zjv1If63nGU
To watch more videos and download the files visit http://www.myelesson.org
To Buy The Full Excel Course visit . http://www.myelesson.org/product or call 9752003788
Connect with us on Facebook - https://www.facebook.com/excelmadeasy/
Connect with us on Twitter - https://twitter.com/Excelmadeasy

Top Rated Products on Amazon That You Might Like
https://www.amazon.in/shop/mye-lesson