[www.keralites.net] Creating Check List in Excel

 

Creating Check List in Excel
 

 

 

 

This example teaches you how to create a checklist in Excel. First, turn on the Developer tab. Next, you can create a checklist.

To create this checklist, execute the following steps.

1. On the Developer tab, click Insert and then click Check Box in the Form Controls section.

2. Draw a check box in cell B2.

3. To remove "Check Box 1", right click the check box, click the text and delete it.

4. Select cell B2.

5. Click on the lower right corner of cell B2 and drag it down to cell B11.

6. Right click the first check box and click Format Control.

7. Link the check box to the cell next to it (cell C2).

8. Repeat step 7 for the other check boxes.

9. The count the number of items packed, insert a COUNTIF function into cell B14.

10. Hide column C.

11. Insert an IF function into cell B16.

Result:

Note: we created a conditional formatting rule to change the background color of cell B16 depending on the cell's value.

Source: excel-easy
 

Junaid Tahir 
www.DailyTenMinutes.com

 

 

---

Posted by: Junaid Tahir

---

---

www.keralites.net

__._,_.___

---

Posted by: prasannam n <iampresanam@yahoo.co.in>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

KERALITES - A moderated eGroup exclusively for Keralites...

To subscribe send a mail to Keralites-subscribe@yahoogroups.com.
Send your posts to Keralites@yahoogroups.com.
Send your suggestions to Keralites-owner@yahoogroups.com.

To unsubscribe send a mail to Keralites-unsubscribe@yahoogroups.com.

Homepage: http://www.keralites.net

Visit Your Group

• New Members 12

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___