How to easily create checklists in Excel sheets and Word documents?


Sometimes you would like to create forms using in Office in order to easily capture user feedback. In today’s tutorial, we’ll teach you pretty much everything you need to know in order to create and format check box lists either as part of your Excel spreadsheets or Word documents. Once done you might want to use your checklist as a template to jumpstart new work. The tutorial refers to Office 2016 applications, however it is relevant to 2010 and 2013 versions as well.

But first off we’ll need to enable the developer tab: 

Note: The developer tab allows you to access many useful controls that you’ll use when creating your form. You will need to enable the developer tab for each Office Application you’ll use.

  • Open Microsoft Word or Excel, click on file and select options.
  • Open Customize Ribbon tab and select Main tabs option under customize the ribbon.

pro



  • Click on Developer option and press OK button.

pro1

  • Once the Developer option is clicked it will be displayed as additional menu on top of the screen with several developer options.

Setting up check boxes in Word:

  • The user has to create the check list and click on Check Box Content Control under developer option tick . 

item

  • The same process should be repeated for the list of items.

 

Making Excel checklists:

  • Create the checklist items in cell.
  • Under Developer option click Insert and then click check box tick which is placed under form control .

xl

  • Select the required cell to place the check box.
  • To remove Check box 1, click on text and delete it.
  • Click on the right corner of the cell and drag down till the last item of the list.

check-box

  • Right click the check box and click format control.

format-control

  • Link the check box to the cell next to it. If C 2 then Click on Cell link under control and type $C$2.Repeat the same for all check boxes.

control

  • To count the number of items marked insert a COUNTIF function next to the last item of the list.

Untitled

  • Hide cell C.
  • Insert IF function at the end of the list.
  • The final result looks :

checklist2

That’s it, thanks for reading.

Leave a Comment: