When you click it a VBA macro runs in the background and checks tabular area where you have entered to do items for anything with “done” status. The key functionality of this excel based to do list lies in the “remove done items” button. That is all, this spreadsheet to do list is soo simple that it leaves you tons of time to actually get some of the things done.Please be aware that once you remove the items you can never get them back. This will remove all the to do list entries with “Done” as the status. Finally once a day or so, click on the “Remove done items” button.When you return mark the items you have finished as done.Now, leave the spreadsheet here and go get some of the things done!.Start entering your to do tasks in the table.It may ask for enabling macros, please say “Yes” See below:Ĭlick here to download the Simple To Do List application in Excel When we have finished a task, we can mark it as “Done” in the sheet and it will be removed. Since most of us use Excel on day to day basis, why not use it as a productivity application as well by keeping track of all the things we must do (TO DO List). After seeing Andrew’s simple excel based check-list I got this idea of preparing a simple To-Do list application using excel.
