In this article:

How to Make a Checklist in Google Sheets (2024 Update)

May 8, 2024

Google Sheets Checklist Template

Get a copy of our free Google Sheets checklist template here. This template is designed for easy customization to streamline your task management.

How to Make a Checklist in Google Sheets

Follow the steps below to make a checklist in Google Sheets. 

1. Name Your Checklist and List Items in Google Sheets

At the top of the page, click on the untitled spreadsheet area and give it a relevant name, such as "Task Checklist." In column A, list down the items or tasks you need to track. Start from the first cell right under the column title.

google sheets checklist

2. Insert Checkboxes Next to Each Item 

Highlight the cells in column B next to your items. Click on the "Insert" menu, then choose "Tick box" from the dropdown.

3. Customize Your Checklist's Appearance with Text and Cell Formatting

Use the toolbar to change the text style, size, cell background color, or add borders to make your checklist more readable.

checklist google sheets

4. Track Progress by Marking Off Completed Tasks

Mark tasks as complete by clicking the checkboxes. This visual cue helps in monitoring what's been accomplished and what remains.

how to make checklist in google sheets

We hope that you now have a better understanding of how to make a checklist in Google Sheets and use our Google Sheets checklist template. If you enjoyed this article, you might also like our article on how to set up commission tracking in Google Sheets or our article on how to insert infinity symbols in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->