In the Format Control dialog box, under the Control tab, please click button to select an adjacent cell to link the check box, see screenshot:Ħ. After inserting and editing the checkboxes, you should link each check box to a separate cell, right click a check box, and then choose Format Control, see screenshot:ĥ. Tips: If you have Kutools for Excel, with its Batch Insert Check Boxes feature, you can insert a list of checkboxes as quickly as possible. Then you can edit the checkbox to remove the text to get the following screenshot: Then drag the mouse to draw a checkbox, and then select the cell with the checkbox, drag the fill handle down to fill the checkboxes as following screenshot shown:ģ.
First, insert the checkbox by clicking Developer > Insert > Check Box (Form Control), see screenshot:Ģ. You can also create to do list by using a checkbox, when checking the checkbox beside the task item, the task item will be formatted as strikethrough as below screenshot shown:ġ. Now, when you select Complete from the drop down list, the task item will be deleted by a strikethrough, see screenshot: Then click OK > OK to close the dialogs, and, a simple to do list is created. Then click Format button to go to the Format Cells dialog box, in this dialog, click Font tab, and then check Strikethrough from the Effects section, and you can choose one color for the to do list item as you need, see screenshot:ħ. Note: In the above formula, B2 is the cell which contains the drop down list, and Completeis the text that you want to format.Ħ. In the New Formatting Rule dialog box, select Use a formula to determine which cells to format in the Select a Rule Type list box, and then enter this formula =$B2="Complete" into the Format values where this formula is true text box, see screenshot: And click Home > Conditional Formatting > New Rule, see screenshot:ĥ. And then select the cell range you want to create to do list. Now, the drop down lists have been inserted into the cells.Ĥ. In the Data Validation dialog box, under the Settings tab, please choose List from the Allow drop down, and then click button to select the cell values you want to use in the drop down, see screenshot:ģ. Select the cells where you want to insert the drop down list, and then click Data > Data Validation > Data Validation, see screenshot:Ģ. You can create to do list by using drop down list.
But, do you know how to create to do list in Excel worksheet?Ĭreate simple to do list with drop down list To do list is useful for us to mark the tasks which have been completed. How to quickly create simple to do list in Excel?