How to use Excel to make Task Manager

How to use Excel to make Task Manager

Step 1: First locate the check box control from the form control in the Excel Developer tab, insert it into the table, remove the text caption from the check box, and then resize the check box to the appropriate size, and drop it in the A1 cell.

If you don't find the Developer tab in your Excel ribbon, you can start this feature from the Excel Options menu. The 2007 version of the Operation path is: "Office Button"--"Excel Options"--"common"--"show the Development Tools tab in the Ribbon"

The 2010 version of the Operation path is: "File"-"Options"-"Custom Ribbon"-check "development tools"

Step 2: Select the check box control in cell A1, and click the right button in the right-click menu, select Format Control to switch to the Control tab in the Open dialog box, enter C1 in the cell link formula at the bottom, and confirm that the status value of this control is associated to the C1 cell.