How to Make a Checklist in Excel-Checklist
Inserting a checkbox in Excel is easy. For example, use checkboxes to create a checklist or a dynamic chart. You can also insert a check mark symbol. Insert a Checkbox To insert a checkbox , execute the following steps. 1. On the Developer tab, in the Controls group, click Insert. 2. Click Check Box in the Form Controls section. 3. For example, draw a checkbox in cell B2. 4. To remove "Check Box 1", right click the checkbox, click the text and delete it. Link a Checkbox To link a checkbox to a cell, execute the following steps. 1. Right click the checkbox and click Format Control. 2. Link the checkbox to cell C2. 3. Test the checkbox. 4. Hide column C. 5. For example, enter a simple IF function. 6. Uncheck the checkbox. Note: read on for some cool examples. Create a Checklist To create a checklist, execute the following steps. 1. Draw a checkbox in cell B2. 2. Click on the lower right corner of cell B2 and drag it down to cell...