Manage your ToDo lists in Excel

To Do List Assistant in detail

The To Do List Assistant for Microsoft Excel is a feature rich way to manage your to do lists. It allows you to construct To Do worksheets that are the way you want them. You can completely customize your to do list worksheets. The to do list worksheets can be kept in any file and/or in workbooks dedicated to to do lists. You can have as many to do worksheets and to do workbooks as you want.

The following is a picture of a simple To Do List:

You can customize the worksheets to meet your needs. You can add columns, delete columns, and rename the columns. The Task column on a to do worksheet is where you put in all the to do's that you have. The columns to the left of the task column represent ways to group related tasks. The columns to the right of the task column are where you can put entries related to the tasks. Such as comments, contacts, start dates and status columns.

To Do List Assistant's features:

• Quickly open and display your default to do list workbook
• Create new to do list worksheets by using any of the templates that come with the To Do List Assistant
• Create new to do list worksheets based on a customized to do list worksheet you are using
• Archive (store) completed tasks quickly and easily
• Easily move tasks up or down to arrange in order of importance
• Easy move groups of tasks up or down
• Display rows based on cell color!
• Filter rows to show only rows containing particular text, such as a person's name
• Display rows based on date!

The To Do List Assistant adds the following additions to the Excel worksheet menu:

Clicking on the button And if it is an active workbook, it will be hidden when you click on the so that it does not clutter Excel. The button displays a navigation list of the to do list worksheets in the active workbook. And it displays a list of entries in the columns to the left of the task column.

Clicking on any of these entries in either list takes you to it automatically:

The three buttons allow you to move items in your to do lists up or down, to archive them, or to delete them.

The first addition to the worksheet menu is the menu "To Do". Clicking on it displays the following menu:

Your first step in using the To Do List Assistant is to create a to do list workbook. The easiest way to create a new to do list workbook is to click on the To Do menu item "Create A New To Do List Workbook". The workbook will then be created with two to do list worksheets. These worksheets contain sample entries that you can delete at any time. You can customize these workbooks as much as you want.

You can add as many more to do worksheets as you want to your to do workbooks. The easiest way to do this is via the "Create A New To Do Worksheet" menu item. It displays a dialog with the following options:

See also in "Excel - Management related"

• Report Runner - Automate printing your Excel reports.