Excel To Do List Template 4 Examples [FREE Download]
- -- By Sumit Bansal
You start your day. Plan some tasks. Write it down somewhere and start working on it.
When its way past your work time, you think about that to-do list [stare at it if you have it written] and curse the world for not having enough time in the day.
Sounds familiar?
If you are nodding your heading in agreement, you my friend, are suffering from an acute condition of expanding-to-do-list.
Well, I am neither a brain doctor nor a self-help guru. I can not help you in overcoming procrastination and getting your work done.
BUT
I can give you an Excel To Do List template that can handle your ever-expanding list [you will still have to make one and do all the work].
Jokes aside, I do believe it is helpful when you maintain a to-do list. I create one every morning, and on some lucky days, I also get the pleasure of checking off most [if not all] the items.
Excel To Do List Templates [Free Download]
Here are the four Excel To Do List templates you can download:
- A Simple printable Excel To-do List.
- To-do List with drop downs to mark atask as complete.
- To-do List where you can check a box to mark a task as complete.
- To-do List where you can simply double to mark the task as complete.
Excel To Do List Template #1 Printable To Do List
This one is for people like me.
I like to print my to-do list and stick it rightin front of my eyes and then work on the items on the list.
Here is a simple Excel template where you can fill the tasks and take a print-out. If you prefer writing the tasks yourselves, simply print it first and then fill in the tasks.
There is a separate column to mention date and comments [if any]. If you dont need it, delete these columns before printing.
Download simple printable to-do list template
Excel To Do List Template #2 With Drop Down List
If you prefer making and maintaining the To Do list in Excel itself, you are in for a treat.
Here is an Excel To Do List template where you can:
- Enter key tasks to be completed.
- Assign priority to the tasks [High, Medium, Low].
- Mark a task as completed by selecting it from the drop-down list. As soon as you mark the task as completed:
- The task gets crossed off [strike-through format is applied].
- The row automatically gets shaded in green color.
- The progress bar changes to show the % of tasks completed [based on the priority].
Additional Notes:
- The weights are given as follows [in the pic below]. If you want to change the weights, you can easily do it by changing these values. In the download file, columns G to J are hidden. Unhide it to change the weights.
- To calculate progress using the progress bar, we calculate:
- Total Score: Add all the weights for all the activities. For example, if there are 2 high priority tasks and 1 medium priority task, and 1 low priority task, the total score would be 14 [5+5+3+1].
- Completed Score: Here we add all the weights for all the activities that are completed. For example, if out of 4activities, 1 high priority activity has been completed, then the Completed Score would be 5.
- % Completed: The value when we divide Completed Score with Total Score. For example, in the above case, it would be 35.7% [5/14].
Download to-do list with drop-downs
Excel To Do List Template #3 With Check Boxes
This template is exactly like the one with drop downs, with a minor difference it has checkboxes instead of the drop-down.
You can mark the task as complete by checking the checkbox. If not checked, it is considered incomplete.
Here is how you can use this Excel To Do List Template:
- Enter key tasks to be completed.
- Assign priority to the tasks [High, Medium, Low].
- Mark a task as completed by checking the checkbox. As soon as you check the box for a task:
- The task gets crossed off [strike-through].
- The row automatically gets shaded in green color.
- The progress bar changes to show the % of tasks completed [based on the priority].
NOTE: Be careful while adding deleting rows. Deleting a row does not deletethe checkbox.
Download to-do list template with checkboxes
Excel To Do List Template #4 Double-click Enabled
I find this version of the template the best of all.
It uses a small VBA code to enable the double click event where you can mark a task as completed by simply double-clicking on it. As soon as you double click on the cell, it automatically inserts a checkmark in that cell.
NOTE: Since this contains a VBA code, it should be saved in .XLS or .XLSM format.
Here is how you can use this Excel To-do List Template:
- Enter key tasks to be completed.
- Assign priority to the tasks [High, Medium, Low].
- Mark a task as completed by checking the checkbox. As soon as you check the box for a task:
- The task gets crossed off [strike-through].
- The row automatically gets shaded in green color.
- The progress bar changes to show the % of tasks completed [based on the priority].
Download Excel Template To Do List #4 Double Click Enabled
NOTE: Since this template contains a VBA code,when you open it, Excel will show a prompt to enable content. You need to enable it for this to work.
So here are 4 Excel To-do list templates that I find useful and often use while planning my work.
Common Use Cases of Using these To-do list templates
While I have shown you the example of common daily tasks, you can use these to-do list templates in many different ways.
Here are some use cases that come to my mind:
- Project Management Checklist: Since a project can have many moving parts to it, creating a daily or even weekly/monthly to-do lists can help you keep a tab on all the important stuff.
- Client onboarding checklist: You can create a quick client onboarding checklist and hand it over to your sales/customer executives. This will make sure a client gets a seamless and complete onboarding experience.
- Grocery checklist: While it may sound weird to create one in Excel, I have seen people do this. This has become more useful now that we can order stuff groceries online in a few minutes.
- Event Management Checklist: Event management can get crazy and out of control if not planned well. A handy to-do list can save you [and others] a lot of time and money.
- Travel Itinerary and Packing checklist: I love to keep my traveling hassle-free by having a to-do list of stuff that needs to be done [bookings, visa, tickets, etc]. You can also create a packing list to make sure you dont leave important stuff behind.
- Blog Publishing Checklist: I have created a to-do list to make sure I dont miss out on the important parts when publishing a blog post on this site. These tasks include doing grammar and spell-check, making sure titles are correct, images are present, tahs and categories are assigned, etc.
What goes into making the Excel TO DO List template?
There is no rocket science at play here. Simple Excel techniques come together to make it happen.
Here are the components that make these templates:
- Conditional formatting[to highlight arow in green when atask is marked as completed].
- Strikethrough Format[appears when a task is marked as completed].
- Excel Drop-down Lists[to show the status in the drop-down].
- Check Boxes[to mark a task as complete by checking it].
- VBA[to enable double click event].
- Excel Charting[to create the progress bar].
I hope these templates will help you become more productive and save some time.
I am sure you also have tons of To-do list success/failure stories and I would love to hear it. I am waiting in the comment section
Other Excel Templates You Might Like:
- To Do List template Integrated with Calendar in Excel.
- Task Prioritization Matrix Template in Excel.
- Shared Expense Calculator in Excel.
- Employee Timesheet Calculator.
- Vacation Itinerary and Packing List Template.
FREE EXCEL BOOK
Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster
37 thoughts on Excel To Do List Template 4 Examples [FREE Download]
- Peggy WongFebruary 2020 at 7:18 am
hi can teach me how ? you do it. for all this check list. Cause I also need to do for my co cash book checking. it is using Excel VBA?
- Dr sekhar KidambiJuly 2019 at 6:52 am
need to use smple way..
- GeeJune 2019 at 3:43 am
Hi just downloaded your template thank you!! Just wondering how i copy to another sheet so i have a PERSONAL and BUSINESS to do list & also how do i extend beyond 25 fields [sorry not good with excel]
- New tabJuly 2019 at 8:41 pm
Just right click on the tab. Choose Move or Copy, put a check in Make a copy box at the bottom and then [move to end]. You can then right click again and re-name them personal and business.
- MartinMay 2019 at 5:31 am
LINK FOR FINAL TEMPLATE DOESNT WORK!
- Emily DApril 2019 at 8:44 pm
I am unable to download the templates. It is just showing a page with a large number of symbols.
- BobJanuary 2019 at 2:37 am
Is there a way to increase size of font, make columns wider, stuff like that.
It is too small for me to use. Thanks Bob - YarZarOctober 2018 at 12:36 pm
Thank You Very Much!
Very Useful for my daily office duty - LuqmanAugust 2017 at 1:51 pm
Hi Sumit. Could you please further explain how you did the progress bar? Because the only way I know how to do it is by conditional formatting. I dont see you use conditional formatting for this one. Appreciate it a lot. Thanks!
- Angelina SepulvedaJune 2017 at 8:13 pm
Thank you!
- UmucoJanuary 2017 at 12:58 pm
Thank you very much. This is very useful.
- Sumit BansalJanuary 2017 at 5:23 pm
Glad you found it useful!
- LanceSeptember 2016 at 3:13 am
How do you add new priority state and/or set your priority list back to say 0 state due to say new entries
- LanceSeptember 2016 at 1:10 am
What are the instructions to add more cells beyond 25?
- Mike MacLeodSeptember 2016 at 10:59 am
Hi, I have tried your to-do-list, but when I tick row 21, the ribbon goes backwards to about the 30% mark and only goes to 100% when all boxes are ticked, what could the problem be, otherwise an excellent article?
- Putu YudisAugust 2016 at 2:44 pm
Hi Summit,, I would like to learn about how to make the last template..
could you please teach me
reaching me atRegards
- Jennifer JacksonJuly 2016 at 11:07 pm
I am seeking a formula or macro to automatically move completed items to the next blank line of sheet 2.
- disqus_rOazeB4gHhJune 2016 at 1:36 am
Thanks for the templates, very cool.
I am no good with excel but I have thought of an idea.
It would be good to have a deadline column and then depending on how far the deadline is from the current date, excel works out the priority. For e.g. maybe have a priority bar that changes colour blue yellow orange then red. For those tasks that have no deadline also have that option and it will always stay low priority for e.g. stay blue.
I dont know if this is possible to do but this is definitely something I would benefit from and so maybe others too.
This is probably just something that bugs me: the fact that when it is completed it is still on the to do list which isnt necessary and blocks the view of what you need to do next, but then the % bar wouldnt work which I think is really cool. Maybe there could be a running total of tasks completed [but these will be removed off the to do list] and tasks left undone and a % based on that? I know it will then never be 100% if you keep adding to the list but thats more like reality you will always have tasks to do.
Thanks again for the template I will be using this one for now until I master coding so I can create sheets like this myself.
Kind regards,
F - disqus_rOazeB4gHhJune 2016 at 1:36 am
Thanks for the templates, very cool.
I am no good with excel but I have thought of an idea.
It would be good to have a deadline column and then depending on how far the deadline is from the current date, excel works out the priority. For e.g. maybe have a priority bar that changes colour blue yellow orange then red. For those tasks that have no deadline also have that option and it will always stay low priority for e.g. stay blue.
I dont know if this is possible to do but this is definitely something I would benefit from and so maybe others too.
This is probably just something that bugs me: the fact that when it is completed it is still on the to do list which isnt necessary and blocks the view of what you need to do next, but then the % bar wouldnt work which I think is really cool. Maybe there could be a running total of tasks completed [but these will be removed off the to do list] and tasks left undone and a % based on that? I know it will then never be 100% if you keep adding to the list but thats more like reality you will always have tasks to do.
Thanks again for the template I will be using this one for now until I master coding so I can create sheets like this myself.
Kind regards,
F - Alysse BosworthMay 2016 at 11:55 pm
If u want to see family todo list u must look this
someka net - Bill KApril 2016 at 10:15 pm
Wonderful work Sumit. thanks! Ive been looking for something like this. Is it possible to have to-dos grouped within projects? Then if one has multiple projects, sort the projects and tasks based on prioirity, hi-med-lo or A, B, C, as I use.
The next key step is to take this sorted listing and add a numerical order to what Im going to do for the day or week. [This numerical order allows for some judgement between what is important and urgent.] This is what Ive been doing daily on paper for years. Its time to join the computer world.
One challenge in using this system Is the archiving of yesterdays or last weeks to-do list, so one can look at past records as a time log to see when a task was performed.
One perifierial suggestion I read you check off completed tasks daily. Me to. very fulfilling. In fact, I MUST do so in RED ink, which adds to my satisfaction! Should be easy to change in excel, right?
Thanks . I look forward to your reply!
Bil - Luciel FernandesApril 2016 at 6:36 pm
Hi Sumit, how can I add two columns before the Complete column, and keep the calculations?
- DuxiaoanMarch 2016 at 4:23 pm
Hi Pal, I love your tips and templates!!!
Please help to put a button to reset the Check Boxes
So I can start to do same activities daily.- Sumit BansalMarch 2016 at 5:15 pm
You got it!
Here is the template with the reset button: //www.dropbox.com/s/ylx8grh6yltil5k/Excel-To-Do-List-Template-Checklist_Clear.xlsm?dl=0
- Maria Lira EnriquezDecember 2015 at 1:15 pm
Hi! How can I add rows to the TO DO LIST with check box? Thanks.
- Sumit BansalMarch 2016 at 5:11 pm
Hello Maria, youll have to manually add checkboxes to addtional rows. Here is a tutorial on how you can do this: //trumpexcel.com/2015/11/insert-checkbox-in-excel/
- Christopher WilliamsDecember 2015 at 9:31 pm
I like #3 With Check Boxes. In mine, I dont use a text box next to the chart to indicate the total. I use a picture [using the excel camera tool] instead. I do that because this way I can conditionally format the cell that contains the total. Of course, that doesnt work if you hide the cell, but I solved that my simply moving all that stuff to column AA since there is no reason for me to need to scroll over there anyway.
- Irfan AslamOctober 2015 at 8:01 pm
HOW CAN I ADD ROWS IN THE TO-DO-LIST
- Sumit BansalDecember 2015 at 9:26 am
Here is a template where you can add up to 100 activities:
//www.dropbox.com/s/vnokxqp5ssgvmes/Excel-To-Do-List-Template-Double-Click_100%20Activities.xlsm?dl=0
- danJanuary 2019 at 10:02 pm
link goes to error page please help
- T.S. RamanathanSeptember 2015 at 1:45 am
Hi, thanks for the to-do-list template. simple but effective. please let me know how to increase the number of activities in the Excel-To-Do-List-Template-Double-Click
- Sumit BansalDecember 2015 at 9:25 am
To add rows, you need to modify the code a bit. Here is a template where you can list up to 100 activities.
//www.dropbox.com/s/vnokxqp5ssgvmes/Excel-To-Do-List-Template-Double-Click_100%20Activities.xlsm?dl=0
- Anand KumarSeptember 2015 at 10:58 am
Really Unique Sumit.
Keep it up and keep share these kinds of tricks..
- Sumit BansalDecember 2015 at 9:18 am
Thanks for commenting.. Glad you liked it
- UzairSeptember 2015 at 10:11 am
I think you should keep going, but try to promote yourself too, so that you get the motivation to write more.
- Sumit BansalSeptember 2015 at 10:58 am
Thanks for commenting Uzair.. Glad you likes the article. And I agree about self-promotion too. I shy away too much and I need to start working on it
- UzairSeptember 2015 at 10:11 am
Good article !!
Comments are closed.
BEST EXCEL TUTORIALS
Best Excel Shortcuts
Conditional Formatting
Creating a Pivot Table
Excel Tables
INDEX- MATCH Combo
Creating a Drop Down List
Recording a Macro
VBA Loops