How to create Checklist in Excel 2010

Now we are going to learn about how to create Checklist in Excel 2010.
  • 29974

Check Box in Microsoft Excel 2010

In this article we will create checklist in Excel 2010. Firstly we will take some list of name. Then click on developer and then drag down Checkbox in b2 cell then drag checkbox to insert option.



After that Check box will come in the B2 cell then select the B2 cell and drag it down right lower corner of the list.


Now right click on the Top of the check box. Then go to the format control.


Link the checkbox to the cell next to it mean C2. This condition apply all the check box.


Now countif formula use for given below.


More Articles

© 2020 DotNetHeaven. All rights reserved.