{"id":33155,"date":"2023-11-20T20:38:13","date_gmt":"2023-11-20T19:38:13","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=33155"},"modified":"2024-03-22T16:16:52","modified_gmt":"2024-03-22T15:16:52","slug":"create-to-do-list-in-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/create-to-do-list-in-excel\/","title":{"rendered":"Create To Do List in Excel  3 Examples"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Copy-of-Copy-of-MICROSOFT-365.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-38526\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Copy-of-Copy-of-MICROSOFT-365-1024x576.png\" alt=\"To do list\" width=\"1024\" height=\"576\" title=\"\"><\/a><\/p>\n<p>In the fast-paced world we live in, <strong>managing tasks efficiently is crucial<\/strong> for success. One powerful tool that can significantly <strong>enhance your productivity is a well-organized to do list<\/strong>. Excel provides you with various solutions that can be used to create to do lists.<\/p>\n<p>In this article, we&#8217;ll explore how to create and optimize 3 different to do lists in Excel &#8211;<\/p>\n<p>Let us look at each of these <a class=\"wpil_keyword_link\" title=\"templates\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-excel-templates-and-spreadsheets\/\" target=\"_blank\" rel=\"noopener\" data-wpil-keyword-link=\"linked\">templates<\/a>.<\/p>\n<p>&nbsp;<\/p>\n<h3><strong><span id=\"1\" style=\"color: #ff0000;\">Template 1 \u2013 Simple To do list<\/span><\/strong><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/To-do-list-3.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-38040\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/To-do-list-3.png\" alt=\"To do list\" width=\"724\" height=\"692\" title=\"\"><\/a><\/p>\n<p>This is a <strong>straightforward and printable <a class=\"wpil_keyword_link\" title=\"template\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-excel-templates-and-spreadsheets\/\" target=\"_blank\" rel=\"noopener\" data-wpil-keyword-link=\"linked\">template<\/a><\/strong> for to do list in <strong>Excel<\/strong>. It contains the following columns &#8211;<\/p>\n<ul>\n<li><strong>Task<\/strong> &#8211; This column specifies the task name, description, or any other relevant information.<\/li>\n<li><strong>Due Date<\/strong> &#8211; This column specifies when each task needs to be completed.<\/li>\n<li><strong>Status<\/strong> &#8211; This column tracks the progress of each task. It includes &#8220;Not Started&#8221; &#8220;In Progress&#8221; and &#8220;Completed&#8221;.<\/li>\n<\/ul>\n<p>The primary purpose of the template is to provide a<strong> structured format<\/strong> for your to-do list that is easy to print. This can be helpful if you <strong>prefer to have a physical copy<\/strong> or if you want to share the list with others.<\/p>\n<p>You can download this template, easily print it at home, and then use it to keep track of your tasks.<\/p>\n<p><a class=\"IRPP_minimalist icon-download\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/To-Do-List-1-1.xlsx\" target=\"_blank\"><span class=\"ctaText px-3 text-capitalize\"><strong>download excel\u00a0<\/strong><strong>workbook<\/strong><\/span><span class=\"postTitle px-3\">To-Do-List-1-1.xlsx<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><strong><span id=\"2\" style=\"color: #ff0000;\">Template 2 \u2013 To do list with Dropdown<\/span><\/strong><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/To-do-list-2.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-38039\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/To-do-list-2.png\" alt=\"To do list\" width=\"718\" height=\"699\" title=\"\"><\/a><\/p>\n<p>This is an Excel template with the following columns &#8211;<\/p>\n<ul>\n<li><strong># &#8211;<\/strong>\u00a0This column likely represents a task number for each item on the to-do list. This number will be automatically generated.<\/li>\n<li><strong>Task &#8211;<\/strong>In this column, you would list the names or descriptions of the tasks you need to complete.<\/li>\n<li><strong>Due Date &#8211;<\/strong>\u00a0This column indicates the deadline or due date for each task. It helps you prioritize and manage your time effectively.<\/li>\n<li><strong>Status &#8211;<\/strong>\u00a0The status column provides information on the current state of each task. For example, &#8220;In Progress&#8221; means you are actively working on it, and &#8220;Not Started&#8221; indicates that you haven&#8217;t begun that particular task. This column is a <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/analysis\/data-validation\/#:~:text=You%20can%20create%20a%20drop,list%20to%20enter%20their%20choices.\" target=\"_blank\" rel=\"noopener\"><strong>dropdown<\/strong><\/a> with the options &#8211; Not Started, In Progress, and Completed.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/analysis\/conditional-formatting\/#:~:text=Conditionally%20Format%20a%20Cell's%20Value,way%20to%20visualize%20your%20results.\" target=\"_blank\" rel=\"noopener\"><strong>Conditional formatting<\/strong><\/a> is applied to strike through and change the font to green when a task is completed.<\/p>\n<p><a class=\"IRPP_minimalist icon-download\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/To-Do-List-2-1.xlsx\" target=\"_blank\" rel=\"noopener\"><span class=\"ctaText px-3 text-capitalize\"><strong>download excel\u00a0<\/strong><strong>workbook<\/strong><\/span><span class=\"postTitle px-3\">To-Do-List-2-1.xlsx<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><strong><span id=\"3\" style=\"color: #ff0000;\">Template 3 \u2013 Advanced To-do list<\/span><\/strong><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/To-do-list-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-38037\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/To-do-list-1.png\" alt=\"To do list\" width=\"1192\" height=\"704\" title=\"\"><\/a><\/p>\n<p>This workbook combines a to-do list and a setup worksheet. It includes columns for &#8211;<\/p>\n<ul>\n<li><strong>Done<\/strong> &#8211; Type 1 in the Done column when a task is complete.<\/li>\n<li><strong>Description<\/strong> &#8211; List the names or descriptions of the tasks you need to complete.<\/li>\n<li><strong>Due Date<\/strong> &#8211; This column indicates the deadline or due date for each task.<\/li>\n<li><strong>Priority<\/strong> &#8211; This column contains a dropdown with the options &#8211; High, Medium, and Low. This column will help you focus on high-priority tasks first.<\/li>\n<li><strong>Assigned to<\/strong> &#8211; This column contains a dropdown with a list of names that you can add to the setup worksheet.<\/li>\n<\/ul>\n<p>Few things that you need to note here &#8211;<\/p>\n<ul>\n<li>If a task is due today, then the entire row is highlighted in orange.<\/li>\n<li>If you type 1 in the 1st column, it indicates that the task is completed and the row will be strikethough.<\/li>\n<li>The tally of the total task due today and the tasks overdue will be displayed at the top.<\/li>\n<li>The <strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/inserting-a-hyperlink-in-excel\/\" target=\"_blank\" rel=\"noopener\">navigation links<\/a><\/strong> are placed at the top right corner of the worksheet.<\/li>\n<\/ul>\n<p><a class=\"IRPP_minimalist icon-download\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/11\/To-do-list1.xlsm\" target=\"_blank\" rel=\"noopener\"><span class=\"ctaText px-3 text-capitalize\"><strong>download excel\u00a0<\/strong><strong>workbook<\/strong><\/span><span class=\"postTitle px-3\">To-do-list1.xlsm<\/span><\/a><\/p>\n<p><a href=\"https:\/\/create.microsoft.com\/en-us\/learn\/articles\/create-to-do-list-in-excel\" target=\"_blank\" rel=\"nofollow noopener\"><strong>Click here<\/strong><\/a> to download to do list in Excel provided by Microsoft.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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&#8217;ll explore how to create and optimize 3 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":33166,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[6,10,1],"tags":[1455,1453,1454],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/33155"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=33155"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/33155\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/33166"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=33155"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=33155"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=33155"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}