Then, we must go to the “home” tab and select “conditional formatting,” then “new rule.” under “new rule,” we will mention the formula as =$c2= true.

How to add checklist to excel. Click “add,” and you’ll see your list items appear in the “custom lists” box. On a new spreadsheet, type the name of the checklist in one of the cells, preferably in a1, so that it will be easy for you to know what the list is about. On the second sheet, create the following named ranges.

Release the ctrl button on your keyboard. You can use either a checklist or a document/image preview, but not both. Import a list of items from cells

In the source field, enter the formula: On the developer tab, in the controls group, click insert. Web here’s what you should do on the excel spreadsheet:

Go to the data tab on the ribbon, then data validation. Set the checklist as the task preview to make it easy to see what work is involved in a task. If you can’t click data validation , the worksheet might be protected or shared.

Click check box in the form controls section. Web go to the data tab and click on data validation in the data tools group. Press enter to add another item to the list.

Unlock specific areas of a protected workbook or stop sharing the worksheet, and then try step 3 again. Web then, enter your list items in the “list entries” box. Web to insert a checkbox, execute the following steps.