Make Checklist & To Do List in MS Excel

Make Checklist & To Do List in MS Excel

Here's a simple way to create a Checklist and To Do List in Microsoft Excel:

Checklist:

1. Open Microsoft Excel.
2. Go to a new blank worksheet.
3. In cell A1, type "Task".
4. In cell B1, type "Status".
5. In cell A2, type the first task that you want to add to the checklist.
6. In cell B2, type "Not Done".
7. Repeat steps 5 and 6 for each task that you want to add to the checklist.
8. Select the cells in column B (Status) and go to Home > Conditional Formatting > Highlight Cell Rules > Equal To.
9. In the Equal To dialog box, type "Done" and choose a fill color, such as green.
10. In cell B2, click and change the value from "Not Done" to "Done" to see the cell turn green.
11. Repeat step 10 for each task that is completed.

To Do List:

1. Open Microsoft Excel.
2. Go to a new blank worksheet.
3. In cell A1, type "Task".
4. In cell B1, type "Due Date".
5. In cell C1, type "Priority".
6. In cell A2, type the first task that you want to add to the To Do List.
7. In cell B2, enter the due date for the task.
8. In cell C2, enter the priority level for the task (such as High, Medium, or Low).
9. Repeat steps 6 to 8 for each task that you want to add to the To Do List.
10. Sort the To Do List by due date or priority by selecting the range of cells (A1 to C2) and going to Data > Sort.
11. Use filters to view only the tasks with a specific due date or priority level by selecting the range of cells (A1 to C2) and going to Data > Filter.