How to Make a Checklist in Google Sheets

Did you know you can add checkboxes to a spreadsheet?  You can also assign point values to checkboxes and automatically keep track of students' progress!  Paper and pencil checklists are always great, but it can also be nice to have a digital version to help you keep track of things.

I've created a free checklist template you're welcome to use.  This sample checklist is perfect for teachers to use in the classroom to keep track of assignments, projects, quizzes, etc.  ​   It's editable, so you can make any changes you'd like.  Keep reading for directions on how to edit and create your own from scratch.  Make sure to scroll to the bottom to grab the free checklist template.

How to Make and Edit a Digital Checklist

It's super easy to add checkboxes in Google Sheets!  Watch the short video below to see how to make your own, or keep scrolling for written directions.

​How to Add Checkboxes:
Highlight the cells where you'd like checkboxes to appear.  Go to Data, then Data Validation.  Under Criteria, change List from a Range to Checkbox.
How to Change the Color of Checkboxes:
Highlight the checkboxes you'd like to change.  Click on Text Color (the A with the underline).  You can choose from the provided colors or click the plus button for more specific options.
How to Add Point Values to Checkboxes:
Highlight the checkboxes you'd like to change.  Go to Data, then Data Validation.   Check the "Use custom cell value" box.  Enter the number you'd like each box to be worth where it says checked.  Enter 0 where it says unchecked.
How to Create Alternating Row Colors:
Select the rows you'd like to change.  Go to Format, then Alternating Colors.  You can choose from a default color choice or individually choose each color.