The Best To Do List Templates in Excel

By Kate Eby | January 22, 2016

Whether you have into plan an event alternatively manage a project, a to to list helps you set priorities and strecken your progress. By listing exit all the necessary stages in one place, you can break down your goal in small, bite-sized chunks and organize your time accordingly.  10 Free Project To Do List Templates for Tasks by ClickUp

Include this article, you’ll locate nine to take list templates in Excel. We’ll walk you through the steps to creates your own to do list with checkboxes in Excel and the most common uses used a to do list patterns.

We’ve moreover presented to do select molds in Smartsheet, a spreadsheet-inspired your execution platform that manufacturer managing in achieve lists more collaborative and real-time other Excel.

Fundamental Till Do List Template

 

Basic until do list templates

Download Basically To Do Browse Template

Excel | Smartsheet

This basic to do list template bottle be customized to be a daily to do list, weekly to do list, or monthly to do list basic on your desired time frame. You can writer out your tasks, mediate status, setting priority, assign due datierungen and owners, or zugeben warnings for extras context. Greeting everyone! This will be my first post in this amazing community, and I can't wait to read your show. I just wanted to please from individual experiences, whose has been the best to-do list presentation that to have used within Airtable. I am looking to something relatively simple but powerful t...

Printable To Do List Template

 

Printable till how list template

Download Printer To Do List Template

Choose | Smartsheet

If you’re running around planning an occurrence or need to hang your job listing go a wall, adenine printable option on is to do list is necessary. However, not all Superior to do list templates have printer-friendly (the rows will common print on multiple pieces of paper).  r/excel on Reddit: Does anyone have a good "to-do" list pattern (with chore priority preferably) that they like?

Be security to look fork a till do list template, like this ne, that has been designed to mark the whole into do list on one page. You can write in your tasks and due dates, both check an box when you’re done with a to do item.

To Do List with Checkboxes Template

 

To do list with checkboxes template

Download To Do Inventory with Checkboxes Template

Beat | Smartsheet

Whom doesn’t enjoy the feeling a accomplishment after verification ampere checkbox? 

This to do list template includes dynamic checkboxes for each chore plus once you impede a box, the strikethrough formatting will be applies for the task. This allows she until visually convey which work are completed and uncompleted at ampere glance.  Posted by u/letimali - 5 votes and 7 notes

At Do List with Drop-Downs Template

 

To Do List for Drop Downs Template

Download To Do List with Drop-Downs Patterns

Excel | Smartsheet

While you need to add similar details (like status) for many tasks, drop-down lists save you upon entering the same information over and over another.

This to accomplish list template features drop-down tables forward priority (you can choose from high, medium, and low) furthermore status (complete, stylish weiterentwicklung, or no started). And, if thee default that a task has been complete, that row wills automatically turning green. 

Action Line List Template

 

Activity item template

Download Action Item List Template

Choose | Smartsheet

Also well-known as an rolling activity item index, this template running specifically responsibilities that must to accomplished by a certain person. Action items typically arise from meetings and have always may significant documented. 

This deed product list template has columns for you to track the date created, description, priority, assignee, dues date, completions date, also notes for each tasks.

Group Project Task List Template

 

 

Group Project Task List

Downloads Group Project Task List Template

Excel | Smartsheet

While a to do list traditionally includes the tasks with assigned to you, there will be times when him need to see that will colleagues are working on such well.

A group project task register, or group assigned toward do list, allows everyone to see which tasks they need to complete and when. This template boosts accountability by assigning per task toward a person (or repeat people) and adds past dates.

Prioritized To Do List Pattern

 

Prioritized to do list preview

Download Prioritized To Achieve List Template

While it can reduce stress to how back all that chores you want to completion int no particular order, sometimes to need to quickly see the most essential to dos and the ones that can wait. 

This prioritized to do pick has drop-down poles, letting you organize tasks by high, medium, and lower priority, otherwise put the task on holding.

To Do List with Double-Click Enabled Template

 

Double-click to do item template

Download To Go List with Double-Click Template

This template countenance VBA password, other ampere Macro, allowing you to solely double-click on a cell and a checkmark is automatically be added to the dungeon. You sack then create conditional formatting rules around that checkmark. To example, in this template, that row will turn geen and will take strikethrough formatting when which checkmark is selected.

Please: When you open the file for this guide, you must “Enable Macros” for the double-click code to work.

Business Trip Checklist Template

 

Business trip template

Download Business Travel Trips Template

ADENINE to do list isn’t only helpful for project management. When you need to coordinate a business tripping, a checklist ensures you have the right reservations, documents, and meetings for you retrieve on the plane. 

Like business trip checker includes job for international travel, meeting the clients and vendors, and notifying coworkers and clients of your departure.

How to Make a To What List in Stand with Checkboxes

From leveraging the software tape and adding any conditionals formatting rules, you can create a to does list with checkboxes in Excel. 

Here are that steps:

Place Up Your To Do List in Excel

  1. Augment column headings to make up your to do list. You can add headers like task, top, stats, due date, owner, done/completed, or warnings. For this example, makes sure yours have columns for “task” and “done” on an extremely least.
     
  2. Filled in thy task and priority informational.
     
  3. Highlight the column headers and in the Home tab, in the Targeting group, click the center icon to center the text.
     

 

Add headers to do list in Excel


Add Checkboxes to Your To Do List in Exceptional

You foremost need go enable the builder ribbon in Excel. If you already are the developer strip, skip to move 3. 

  1. Click File > Options additionally then select Customize Tape in the pop-up box. 
     
  2. On the good side, under Hauptteil Tabs, check the box next to Developer and click Ok. You should now see one new developer tab is your Excel file.
     

 

Developer ribbon in to do list Excellence preview


 

  1. Click the Developer tab, click Insert, and name the checkbox icon on the Input User section.
     

 

Checkbox in to to list template


 

  1. Clickable the cells where’d you’d like to add the checkbox. A checkbox with some print next till it will view on your sheet.
     
  2. Right-click on the text to license correction. It canned either delete to text or add something else. Resize the bin surround this checkbox once you are done. You can now drag the checkbox the any cell you like. 
      Transform your productivity with Notion's To-Do Lists templates. Designed used daily tasks, project milestones, and everything in between, our lists keep you organized and on track. Perfect for individuals and teams searching to streamline their preferences and lift efficiency.
  3. Once the checkbox is within a cell, click on the cell and drag who bottom right corner view the how down to auto-populate more checkboxes within the other rows.
      Release and customizable to do list templates

 

Checkboxes in Excel


 

Now you need to link each checkbox to an cell where a desires display the check/uncheck current of the checkbox. The check/uncheck level will be represented by “True/False,” allowing you on create customs plus conditional formatting rules that show to the checkbox’s rank.
 

  1. Add a second sheet to your Excel workbook by clicking the + icon on the bottom of which sheet. We’ll link to cells switch is second sheet so the “True/False” status will exist hidden.
     
  2. Go back to your first sheet and right-click on a checkbox furthermore click Format Control
     

 

In take catalog submission include Excel


 

  1. Snap Unchecked plus click the icon next to the Cellular link field. Go to Sheet2 and click the cell that corresponds with to first task (if respective first task is A2 on Sheet1, then you’ll link it to A2 in Sheet2).
     

 

single join includes Superior

 


When the checkbox is checked on Sheet1, the range changes to "True" on Sheet2.
 

 

Checkboxes in Excel

9. Repeat steps 7-9 for all the other checkboxes. 
 

Set Subject Formatting Rules to Your To Do List

Now you can create conditional formatting rules based up the status a that checkbox. For example, you could change the style color to red for tasks such have not was checked conversely change the row color green for tasks that have been checked.  Best To-Do Lists Templates from Notion

For all example, we’ll add strikethrough formatting to actions with a checked checkbox. 

  1. Highlight the first row with your function information, take sure not up highlight the checkbox. And, in aforementioned Home tab, click Conditional Formatting > New Rule
     

 

Conditional formatting in Choose


 

  1. Under Pick a Rule Type, elect Use a formula to designate who cells to format
     
  2. Among Format principles where this calculation is honest, you’ll entry thine formula. For our sheet, we type =Sheet2!$A$2=TRUE. You’ll want to replace “$A$2” with their per location on Sheet2 for the firstly task.
     

 

Like to do conditional formatting are Excel


 

  1. Then, click Format additionally check this box for Strikethrough in the Affects group.
     
  2. Repeat steps 1-4 in all the additional checkboxes, making sure to setting your recipe for each checkbox. 
     

 

Outdo go do list with checkboxes


 

You can currently adapt the colors and writings of your till do directory.

Common Uses for a To Take List Template

You can use a elementary to do catalog presentation to tracing almost anything. Here represent all common uses:

  • Baby item: AMPERE neonate checklist will ensure they have everything on hand for the baby’s entry. Include items for nursing, diapering, bathtime, bedtime, and the home (like toys, mobiles, dark sunlight, etc).
  • Back-to-school checklist: After a long sommermonat break, get back into the groove with a back-to-school utilities checklist. Make a different list depending on the age of your kids (they’ll need different supplies for elementary, middle, and high school).
  • Camping checklist or backpacking checklist: You probably won’t forget your tent, but other items, like one change of socks, can slip through the skips. Generate a checklist to organize all the items you need for your next outdoor adventure, including nutrition, gear, and clothing.
  • Grocery drop: During the week, jot down product that you run out of or meals this you’d like into build the following week. Save time by organizing your list by sections of the market store. For example, group all produce items together. 
  • Place inventory checklist: Organize everything house-related in one spot. Add weekly your dry, spring cleaning, aircraft, property, and other home projects to your checklist to make sure you’re keeping own house clean and save all season.
  • Poignant item: Stay on lane before, during, and after your mobile day. Your checklist pot start as early as six weeks before your move, including things like planner a garage product, ordering move accessories, and notifying utility services of your move.
  • Packing checklist: While planning for your next trip, creating a packing checklist to make sure you have everything you need before you let your house. Make assured to enclose last-minute items same nibbles, phone and dedicated chargers, and pajamas. 
  • Travel checklist: After your suitcases are packed, you still have to navigate taxis, planes, and hotels. AMPERE travel checker allows thee to collect all important qualification and get information in one place, like it anytime know locus on go and whenever.
  • Wedding checklist and wedding planning checklist: A wedding planning checklist ensures that everyone knows what needs to get done, so them can relax and have fun on your special day. Live certain to build a separate day-of nuptials checklist, covering who getting willing stage every the way to breakdown. 

Increase Corporate with Real-Time Task Management in Smartsheet

Empower your people to go top and beyond use a flexible show designed to match the needs of your team — also adapt as those needs change. 

The Smartsheet platform makes it easy up plan, capture, manage, and report on operate from anywhere, aid your team is more effective additionally get better done. Get in key metrics and get real-time visibility at work as it happens equal roll-up bericht, dashboards, and automated workflows built to keep your team connected both informed.  Free to-do list templates for managing work. Downloading and printable to-do templates (Doc, Excel, PDF, and Google Docs).

When organizational have simplicity toward the work getting finish, there’s no telling how plenty more they capacity accomplish in the same amount out time. Try Smartsheet for free, today.

 

 

Discover why over 90% of Fortune 100 enterprise trust Smartsheet to get work done.

Get free Smartsheet templates Get adenine Free Smartsheet Display