Excel spreadsheet so you can see that I've got some data which is first name of the employee last name of the employee and phone number and let us assume that your manager has given you a task to identify all those employees which did not give a phone number. so you wanted to identify them using a check box right like you will be providing a check for all the employees that we have received the phone numbers and you will not be checking the employees which did not give the phone number right so let's try to do that so to include a check box you might want to get into the developer option but for few reasons Microsoft has disabled developer option.


                        Enable Developer Option in Excel

    • 1.              Right Click on the navigation ribbon
    • 2.        Click the Customize ribbon
    • 3.        And Select Developer Check box



You'll have the developer option now go to the developer option and select the insert option and there you can see the check box. Now draw the check box anywhere I'll draw it over here and there you go you have the first checkbox right now if you want you can even customize. so carefully click it you can edit the text and write it has done now you can even copy this to all the cells just select and drag and there you go now you can go ahead and check. All the employees which you have received the phone numbers and you can eliminate the ones which did not provide you with the phone numbers that's how you can do it and there's also another option where you can use this to include it in a formula since this data is only of 25 rows you can manually check in the data and you can leave the data which is you have not received but what if you had 2500 right then you might need formula so in such scenarios you can use a formula so how do you use that so for example uh if this particular box is checked then you will get a true value here and if it's not checked you will have a false value then you can use that value to include in your formula right sounds interesting now let's try to implement that you can right click the cell and you can find format control then you can see here you have an option called cell link here select the cell link and press ok 

               Follow Few Step to Create Easily Check Box in Excel. Like this

       1. To add a checkbox, click the Developer tab, click Apply, and under Form Controls, click


        2. To add an option button, click the Developer tab, click Apply, and under Form Controls, click


3. Click on the cell where you want to add the checkbox or option control button.

          4. To edit or delete the default text to control, click the controller, and update the text as needed.



   So, here you can see if you have checked this the value is true and if you uncheck this you can see the value turned false now you can use this particular cell reference for including this in a formula now let us also check how to include checkboxes on google sheets in google sheet it's really simple all you have to do is get into the insert option and you can see a really available check box you don't have to use any developer options over here and there you go you can just check and uncheck it now with that we have come to an end of this post on check boxes in excel if you have any queries regarding any of the topics covered in this session.