Pinterest Pixel

Create To Do List in Excel 3 Examples

In the fast-paced world we live in, managing tasks efficiently is crucial for success. One powerful tool... read more

Download Excel Workbook
John Michaloudis
Posted on

Overview

Create To Do List in Excel 3 Examples | MyExcelOnline Create To Do List in Excel 3 Examples | MyExcelOnline

To do list

In the fast-paced world we live in, managing tasks efficiently is crucial for success. One powerful tool that can significantly enhance your productivity is a well-organized to do list. Excel provides you with various solutions that can be used to create to do lists.

In this article, we’ll explore how to create and optimize 3 different to do lists in Excel –

Let us look at each of these templates.

 

Template 1 – Simple To do list

To do list

This is a straightforward and printable template for to do list in Excel. It contains the following columns –

  • Task – This column specifies the task name, description, or any other relevant information.
  • Due Date – This column specifies when each task needs to be completed.
  • Status – This column tracks the progress of each task. It includes “Not Started” “In Progress” and “Completed”.

The primary purpose of the template is to provide a structured format for your to-do list that is easy to print. This can be helpful if you prefer to have a physical copy or if you want to share the list with others.

See also  Conditional Formatting with Excel Icon Sets - A Step-by-Step Guide

You can download this template, easily print it at home, and then use it to keep track of your tasks.

download excel workbookTo-Do-List-1-1.xlsx

 

Template 2 – To do list with Dropdown

To do list

This is an Excel template with the following columns –

  • # – This column likely represents a task number for each item on the to-do list. This number will be automatically generated.
  • Task –In this column, you would list the names or descriptions of the tasks you need to complete.
  • Due Date – This column indicates the deadline or due date for each task. It helps you prioritize and manage your time effectively.
  • Status – The status column provides information on the current state of each task. For example, “In Progress” means you are actively working on it, and “Not Started” indicates that you haven’t begun that particular task. This column is a dropdown with the options – Not Started, In Progress, and Completed.
See also  Excel Harvey Balls Made Easy: Step-by-Step Tutorial

Conditional formatting is applied to strike through and change the font to green when a task is completed.

download excel workbookTo-Do-List-2-1.xlsx

 

Template 3 – Advanced To-do list

To do list

This workbook combines a to-do list and a setup worksheet. It includes columns for –

  • Done – Type 1 in the Done column when a task is complete.
  • Description – List the names or descriptions of the tasks you need to complete.
  • Due Date – This column indicates the deadline or due date for each task.
  • Priority – This column contains a dropdown with the options – High, Medium, and Low. This column will help you focus on high-priority tasks first.
  • Assigned to – This column contains a dropdown with a list of names that you can add to the setup worksheet.

Few things that you need to note here –

  • If a task is due today, then the entire row is highlighted in orange.
  • If you type 1 in the 1st column, it indicates that the task is completed and the row will be strikethough.
  • The tally of the total task due today and the tasks overdue will be displayed at the top.
  • The navigation links are placed at the top right corner of the worksheet.
See also  How to Use Excel Ink to Text Pen - Convert Handwriting Fast!

download excel workbookTo-do-list1.xlsm

Click here to download to do list in Excel provided by Microsoft.

If you like this Excel tip, please share it
Create To Do List in Excel 3 Examples | MyExcelOnline Create To Do List in Excel 3 Examples | MyExcelOnline
Founder & Chief Inspirational Officer at MyExcelOnline.com

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship Academy Online Course.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...