To Do Liste Excel

Learn how to create dependent drop down lists.

To do liste excel. Create simple to do list with drop down list. Once you have set the completion to 100 excel automatically checks the item off as done. Examples of to do lists that you can have include shopping work assignments and targets to meet. A second drop down list contains the pizza items.

Be sure to look for a to do list template like this one that has been designed to print the whole to do list on one page. But if the user selects chinese from the first drop down list the second drop down list contains the chinese dishes. This simple and accessible to do list uses a table and conditional formatting. If the list of entries for your drop down list is on another worksheet and you want to prevent users from seeing it or making changes consider hiding and protecting that worksheet.

1 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. A to do list does away with all the possibilities of forgetting something that you wanted to do. However not all excel to do list templates are printer friendly the rows will often print on multiple pieces of paper.

After you create your drop down list make sure it works the way you want. This article shows you how you can create a to do list with checkboxes. For example if the user selects pizza from a first drop down list. You can write in your tasks and due dates and check the box when you re done with a to do item.

Luckily you can create your own to do list using excel from your computer. Add a row for a new task set the priority dates and notes.