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?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |