To Do List Excel Template

Excel To Do List:

Download Here

View other templates here: Excel Templates

This template does not contain macros/VBA code.

To do list with drop down percentage complete and auto-calculating overall progress bar.


Add a task name under the “Task” column and a due date under the “Due Date” column. If you leave the value under “Percent Done” as a dash “-” the total progress bar will not calculate it in. Adding a new task must be changed to 0% or higher to be included in the total progress average.

If you remove a task, change “Percent Done” back to a dash “-” to prevent total progress from using it in its calculation.

*If you need to add more than the provided 20 lines, modify cell D3 (the total progress bar). In the original formula “=IFERROR(AVERAGEIF(D4:D23,”<>-“),””)” where it states D23 may need to be increased to the proper cell if Excel fails to do it automatically. In most cases, it should automatically update.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.