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.

check1.jpg


check2.jpg

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.

check3.jpg

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

check4.jpg

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

check5.jpg

Now countif formula use for given below.

Categories

More Articles

© 2020 DotNetHeaven. All rights reserved.