Now, select the rule type as ‘Use a formula to determine which cells to format’. Select the tasks which you have added in previous steps, click on ‘Conditional Formatting’ under ‘Home’ tab and select ‘New Rule’. Repeat this step for the remaining checkboxes as well. Make sure that you give the cell address as ‘ H7’ only and not in any other format. In ‘Formal Control’ dialog box under ‘Control’ tab give the address of the cell in ‘ Cell link’ box which you want to assign to the checkbox. To do so, right-click on the checkbox and click ‘ Formal Control’.

Now, we need to assign a cell to each checkbox such that, when we tick and untick the checkbox, then values TRUE and FALSE need to be shown respectively. Repeat this step for the remaining columns also (F8 and F9 in this case). To remove that, right-click on the checkbox, select ‘Edit Text’ and delete the text. We can see that some default text was added along with the checkbox.

Now, click on the Excel cell where we want to insert this checkbox and in this case it is F7. To do so, first, click on ‘Developer’, click on ‘Insert’ and click the checkbox icon under ‘ Form Controls’. So, for every entry in column E7 to E9, we need to add checkboxes from F7 to F9. Besides the ‘ To Do’ column we need to add Checkboxes. Now, prepare a column ‘ To Do’ and enter the tasks that you want to do. Now you could see ‘Developer’ tab on the Excel ribbon. In ‘Excel Options’ dialog box, select ‘ Customize Ribbon’ and on the right side check the box beside ‘Developer’ and click Ok. 1] Activate Developer Tab in ExcelĪs a first step, you need to enable the ‘Developer’ tab in Excel. I will take you through few series of steps so that it would be easy to understand. Follow through to the end of the article to know how to do it. But, in this article, I will let you know how to use checkboxes to create a checklist in Excel. We generally use checkboxes in Excel only while creating forms. But, if you are an Excel lover like me then we can use Microsoft Excel to create a checklist or To-Do list easily. This keeps us completing our tasks without any procrastination. Most of us use To-Do apps to list down the tasks which we want to do on a particular day.

Make to do list in excel