How to create a checklist in Google Sheets


Creating checklists in Google Sheets is now easy with our step-by-step guide. Learn how to create checklists in Google Sheets in a simple way.

How to create a checklist in Google Sheets

Looking for information on How to create a checklist in Google Sheets? You've come to the right place! 

In this blog article, we'll take a closer look at how you can create a checklist in Google Sheets in a simple and easy way.

Google Sheets is a free alternative to Microsoft Excel that you can use from your browser without having to download anything. It's a powerful tool, although perhaps not as powerful as Excel.

Checklist in Google Sheets - checkbox formula

Google Sheets is a great tool for organizing and analyzing data. With its many features, it can rival even the Microsoft Office suite. One great feature it has is the ability to add a checklist. 

This can be really useful in a variety of situations.

Let's get started!

Create a checklist in Google Sheets

First, let's open a new spreadsheet in Google Sheets. We'll prepare the spreadsheet with the data we need to create a list. Then, we'll select the column and rows to the right of the list where we want the checkboxes to appear.

checklist in Google Sheets

After selecting the column and the rows, we will have to click on "Insert" in the toolbar at the top, from here we will have to choose Checkbox.

a checklist in Google Sheets

We only need to do this and we can see the checkboxes appearing where we selected them. All we have to do is press the checkboxes to mark or deselect them. 

If we want more users to be able to select checkboxes, we need to make sure to update the sharing settings to allow full edit access to the spreadsheet. 

Although this checklist is quite basic, we're pleased to see that Google is still working on improving this interesting and useful tool - especially since it's free and can be accessed from any device.

As you can see, it's extremely easy to add a checklist in Google Sheets. Likewise, remember that if you have any kind of doubt about this guide, you can leave it in the comment box that you will find a little further down and we will be happy to help you with anything you need.


Creating a checklist in Google Sheets is a useful (if basic) feature, and we're glad to see Google continue to update Google Sheets to add features like this.

$hide=home, label, search

$hide=home, label, search


Academic-calendar,38,Adsterra,3,Affiliate-Marketing,1,Ajira-Portal,1,Articles,82,Australia,2,Bank Jobs,2,Blackboard,5,Blogger Templates,2,Blogging,19,Blogging-Tips,2,Business,3,Business-Ideas,1,Camping,4,Canvas,5,Check WAEC Results,1,Colleges,1,CRDB Bank,2,Credit-Cards,8,Destinations,7,Diamond Platnumz,1,Digital Marketing,8,Download-FRP-Tools,1,Editors-Choice,9,Education,17,Email,6,Entertainment,1,Featured,10,Featured Updates,3,Fiverr,8,Food-and-Drink,4,Form-Five-Second-Selection-2022,1,Form-Five-Selection-2022,1,Freelancing,46,FRP-Bypass,6,Gaming,1,Gig Economy,3,Google AdSense,1,Grills-Smokers,1,Guides,2,How-To,9,Insurance,5,JKT-Selection,1,Jobs,50,Kenya,1,Life Style,1,Login Portal,2,Login-guide,36,Login-Portal,6,Mabumbe-Jobs,2,Make Money,15,Malawi,3,Marriot-Login-Portal,1,Matokeo,3,Mental Health,1,Money,1,Moodle,1,MSNBC-Anchors-Female,1,MSNBC-news-anchors,1,Music,1,NBC-Premier-League,1,NECTA-2022,2,nesa-rwanda-exam-results,3,News,3,News Female Anchors,2,Nigeria,1,NMB Bank Jobs,1,Other-LMS,1,PeoplePerHour,1,Queen-Elizabeth-ii,1,RV-Guides,6,RV-Insurance-Companies,1,RV-Rentals,1,Rwanda,2,Scholarships,1,Schools-Guide,6,Self Development,1,SENSA-2022,8,SEO,1,South-Africa,31,Sponsored,1,student-portal,55,TAMISEMI,1,Technology,16,TPES-OF-RVS,1,Tunzaa,1,Txrhlive,1,UCSD,3,United-States,15,Upwork,7,WAEC Result Checker,1,WAEC Results,1,Wakuu-wa-mikoa,1,Wealth,9,zambia,2,zambia-census,2,
KIDIGITALI - Information Guides: How to create a checklist in Google Sheets
How to create a checklist in Google Sheets
Creating checklists in Google Sheets is now easy with our step-by-step guide. Learn how to create checklists in Google Sheets in a simple way.
KIDIGITALI - Information Guides
Loaded All Posts Not found any posts VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES POSTS View All RECOMMENDED FOR YOU LABEL ARCHIVE SEARCH ALL POSTS Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS PREMIUM CONTENT IS LOCKED STEP 1: Share to a social network STEP 2: Click the link on your social network Copy All Code Select All Code All codes were copied to your clipboard Can not copy the codes / texts, please press [CTRL]+[C] (or CMD+C with Mac) to copy Table of Content