Thursday 7 January 2016

[HM:258290] Creating Check List in Excel

Checklist Example

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.

Add a Check Box

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.

Copy Check Box

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

Format Control

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

Cell link

8. Repeat step 7 for the other check boxes.

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

Countif Function

10. Hide column C.

11. Insert an IF function into cell B16.

Result:

Checklist 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

--
--
We are also on Face Book, Click on Like to jois us
FB Page: https://www.facebook.com/pages/Hyderabad-Masti/335077553211328
FB Group: https://www.facebook.com/groups/hydmasti/
 
https://groups.google.com/d/msg/hyd-masti/GO9LYiFoudM/TKqvCCq2EbMJ

---
You received this message because you are subscribed to the Google Groups "Hyderabad Masti" group.
To unsubscribe from this group and stop receiving emails from it, send an email to hyd-masti+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment