How to Create To-Do Lists (with Excel Templates)

A to-do list is very important in ensuring that you conduct all of your important daily activities. One of the character traits of humans is being forgetful, so sometimes you can come to the end of the day only to realize that you forgot a certain task. A to-do list does away with all the possibilities of forgetting something that you wanted to do. Examples of to-do lists that you can have include shopping, work, assignments, and targets to meet. Luckily, you can create your own to-do list using Excel from your computer. This article shows you how you can create a to-do list with checkboxes using excel.

Steps to Creating a To-Do List in Excel

To create your To-Do list effectively, follow the steps below: 

  1. Depending on the to-do list that you want to create, open an Excel application, and add relevant column headers. These may include tasks, priority, status, due date, and done/completed.
  2. After creating the column headers, fill them with relevant information. This includes all the tasks that you want to accomplish in order of their relevance.
  3. At the Home tab, highlight the column headers then click on the center icon to center the highlighted text.
to do list

Adding checkboxes to your to-do list

Your to-do list is more fun and easier to accomplish if you add checkboxes. These will remind you of the tasks that you have not accomplished easily. Here is how to add checkboxes to your to-do list: 

  1. Click on File > options then select the customize ribbon located in the pop-up box.
  2. Looking at the right side where the Main Tabs are located, you will see a box next to Developer. Click on it, and you should see a new developer tab added to your excel file.
to do list 2
  1. On the Developer tab, click insert and select the checkbox option.
insert-checkbox-excel

    4. Click on the area where you want your checkbox to appear, and it will automatically do so.

to do list 3
  1. To enable editing, right-click on the text. You can use the provided text or delete them and add yours. You can also resize the boxes at this stage.
  2. After putting your checkbox in a cell, click on it and drag down to the other columns so that you can auto-populate the checkboxes.
  3. Create a formula that will help you determine whether the information put on the checkboxes is true or false.

Free To-Do List Templates

To Do List Template Excel

Task To Do List Template

To Do List with Due Date

Priority To Do List Template Excel 01

Priority To Do List Template Excel 02

Priority To Do List Template Excel 03

Action To-Do List Template
smartsheet.com

Basic To-Do List Template Sheet
smartsheet.com

Business Travel To-Do Checklist Template
smartsheet.com

Group Project Task To-Do List Template
smartsheet.com

To-Do List Checkboxes Template
smartsheet.com

To-Do List Double Click Excel Sheet
smartsheet.com

To-Do List Printable Template
smartsheet.com

To-Do List With Drop-Downs Template
smartsheetcom

    Conclusion

    To-do lists are very important in helping to work on all of your day’s tasks. Fortunately, you can create one using excel as shown above depending on what you want to achieve.

    Scroll to Top