How to Make a To Do List in Excel (3 Easy Methods)

We will use a sample dataset to illustrate. The following dataset represents the Task, Status, and Deadline.

Method 1 – Using the Filter Feature to Make a To-Do List in Excel

STEPS:

• Click any header cell. Here, I clicked cell C4.
• Select Home ➤ Editing ➤ Sort & Filter ➤ Filter.

• Click the drop-down icon beside the Status header cell.
• Check the boxes On Going and Pending.

• Press OK.

You’ll get your To-Do List.

Read More: How to Generate List Based on Criteria in Excel

Method 2 – Creating a To-Do List with a Drop-Down List

STEPS:

• Select the range B5:D10.
• Go to Data ➤ Data Validation.

• A dialog box will pop out.
• Select List in Allow, and in Source box, type the formula:

• Press OK and you’ll see your range featuring the drop-down icons beside them.

• Select B5:D10.
• Go to Home ➤ Conditional Formatting ➤ New Rule.

• Another dialog box will open.
• Select the last Rule Type, and in the red-colored box as shown below, type the formula:

• Press Format.
• The Format Cells dialog box will appear.
• Check the box for Strikethrough in the Effects section under the Font tab.

• Press OK and it’ll return the desired output.

Read More: How to Make a List within a Cell in Excel

Method 3 – Applying a Check Box for Making a To-Do List in Excel

STEPS:

• Select the Developer ➤ Insert ➤ Check box.

• Draw the check box shape by dragging the mouse in the required field.
• Use the AutoFill tool to complete the rest.

It’ll return the desired To-Do List and just check the boxes after completing that task.

Read More: How to Create List from Range in Excel

Common Uses of To-Do Lists in Excel

1. As a project has many moving parts, making a daily or weekly to-do list can help one to keep a tab on all the necessary stuff.
2. A to-do list keeps track of all the important parts when publishing a blog post.
3. Event management can be facilitated if we use a to-do list.
4. A to-list can assist us in our grocery shopping.
5. A quick onboarding checklist ensures a client gets a smooth and enjoyable onboarding experience.
6. A to-do list is most used when we are planning and packing for a tour.

Download the Practice Workbook

Download the following workbook to practice.

Related Articles

• How to Make a Numbered List in Excel
• How to Make a Price List in Excel
• Create a Unique List in Excel Based on Criteria
• How to Make a Comma Separated List in Excel
• How to Create a Contact List in Excel

<< Go Back to Make List in Excel | Excel Drop-Down List | Data Validation in Excel | Learn Excel