I will revive the blog during the next weeks and I am already working on a couple of new articles.įor one of the planned next posts I needed a checklist template. Unfortunately my blogging activities slowed down to a crawl during the last few months and I left you waiting for new posts far too long already.īe assured that this site is not dead.

When you see the Fill Handle (plus sign), drag to fill the additional cells and release.A Microsoft Excel template for a structured Checklist with the option to check and uncheck by double clicking To use AutoFill, put your cursor on the bottom-right corner of the cell containing the checkbox. Or for a quicker way, use AutoFill to copy the checkboxes through the cells of your other items. To use the “Cell Link,” simply type the cell reference into the box or click the cell in your spreadsheet to populate it automatically.įollow the above steps to add checkboxes to your remaining list items. RELATED: How to Use the COUNTIF Formula in Microsoft Excel You can base your formula off of the True and False values associated with the checked and unchecked boxes. Say your checklist has 25 items and you plan to use the COUNTIF function to see how many of the items are checked. When you enter a cell into this box, it will display a True or False value based on the box being checked or unchecked. If you plan to use your checklist in conjunction with Microsoft Excel formulas, you’ll likely use “Cell Link” on the “Control” tab. To do this, mark “Checked” under “Value” in the Control tab and click “OK.” This forces the user to uncheck items they don’t want. Depending on the type of checklist you create, you might want the boxes checked by default instead. Checkbox Valuesīy default, a checkbox is unchecked when you insert it. This one lets you set the value, add a cell link if necessary, and apply 3D shading. The other tab you may want to work with is the “Control” tab.

Todo template excel