Make checklist in Excel
What is a Checklist in Excel?In excel, we can create a checklist template and keep us up to date with all the tasks needs to do for a particular project or event. We all plan our tasks, events, etc. We usually memorize or note down somewhere to check the list of tasks needs to be completed or list of task that is completed. When we are planning for an event, marriage, work that includes many steps, or a project to carry out at different time frames, we need many tasks to be completed on time. Remembering all those tasks r list of tasks is not a walk in the park; maintaining all the excel checklist isnt that easy in a piece of paper. If you have experienced such kinds of problems in the past, you can learn the ways of creating checklists in excel. In this article, I will introduce you to the interactive excel checklist template. How to Create a Checklist in Excel Using CheckBoxes?The most common way of creating an excel checklist template is using CheckBoxes in ExcelA checkbox is a developer tool available in excel to place a checkbox in a cell. When ticked, the checkbox shows a tick mark, which means the task is completed and returns a true value, while an empty checkbox returns a false value.read more. In our earlier article, I have elaborated on the ways of using checkboxes. Checkboxes represent the selection and deselection visually. The checkbox is available under the Developer tab. If you do not see the Developer tab, enable it. Once the developer tab is enabled, you can see the checkbox, as shown in the below image. Example #1I will explain to you the simple excel checklist template for your competitive exam. Below are the tasks you need to carry out before the exam. Copy this list in excel. Go to the Developer tab, then Select CheckBox and Draw in B2 Cell. Now drag the checkbox against all the task lists. Now we have the checkbox for all the tasks. Right-click on the first checkbox and select Format Control in excel. Under Format Control, go to Control and select Checked and give cell referenceCell reference in excel is referring the other cells to a cell to use its values or properties. For instance, if we have data in cell A2 and want to use that in cell A1, use =A2 in cell A1, and this will copy the A2 value in A1.read more to C2 cell. Now, this checkbox is linked to the cell C2. If the checkbox is ticked, it will show TRUE as a result in C2, or else it will show FALSE as a result in C2 cell. Similarly, repeat the same task but keep changing the cell reference to the respective cell. For example, for the next checkbox, I will give cell reference as C3, for next, I will give cell reference as C4, and so on. Finally, all my checkboxes settings will be done, and it should look like the below one, as shown in the image. Now, as the tasks keep completed, keep ticking the respective task boxes to update your task list templateYou can use the Task List Template for tracking an event or project, managing checklists for both commercial & personal purposes. Its primary goal is to display the current status of all the tasks, which helps you maintain the deadline. read more. Example #2 How to Make Your Checklist More Attractive?The above checklist list template looks ordinary. We can make this a beauty by applying conditional formatting to it.
Example #3 Strikethrough all the Completed Excel Check ListWe can make the report more beautiful by going one extra mile in conditional formatting. We can strikethrough all the completed checklist templates with conditional formatting. In general perception, strikethrough means something which is already completed or over. So we will apply the same logic here as well. Step 1: Select the checklist data range Step 2: Go to Conditional Formatting and click Manage Rules Step 3: Now, you will see all the conditional formatting lists. Select the rule and click on Edit Rule. Step 4: Now click on Format and select Font and select Strikethrough. Step 5: Click on OK. All the tasks which are completed will be strikethrough. Step 6: Finally, hide column C to make the checklist template more beautiful. Things to Remember about Checklist in Excel
Recommended ArticlesThis has been a guide to Checklist in Excel. Here we discuss how to Create a Checklist in Excel using Checkbox along with excel example and downloadable excel templates. You may also look at theseuseful functions in excel All in One Excel VBA Bundle (35 Courses with Projects)
|
