Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

The Reason to Love Google Sheets: Make Checkboxes

The reason to love Google Sheets Spreadsheets is CHECKBOXES! it is so easy! Insert -> Checkboxes.

The Reason to Love Google Sheets: Make Checkboxes

checkboxes in google sheets

Note that you can make checkboxes in Google Sheets. However in November of 2021 Google Sheets has updated the menus. The Insert Checkboxes option is still the same. However, you will notice some icon changes.

Make Checkboxes in Google Sheets

A new feature in Google Sheets spreadsheets is the ability to add a checkbox to a cell. Pretty much this is going to end up being the feature I use the most often! Who doesn’t need to check things off?! Click here to view my sample spreadsheet.

Check boxes

Make a Spreadsheet

Easily create a new Google Sheets spreadsheet by going to sheets.new. OR simply go to Google Drive and create a new spreadsheet.

Choose a Column

You will need a column for your checklist. This should be an empty column. You may want to first INSERT a column. If you are using a spreadsheet from a Google Form and need to check off things you have to insert a column into the spreadsheet for your checklist. Hover over the column you want to “check off.” Notice a tiny triangle appears in the column header. Choose “Insert 1 left.”
Insert a column to the left

Want More Help with This? Become a Premium Member

Highlight the Column

Click on the column indicator for where you want the checkboxes. Alternatively, you can highlight the range of cells that you want the checkboxes in.
Highlight the range of cells with checkboxes

Data Validation

Either right click on the column indicator or hover over the column indicator and look for the tiny triangle. Choose “Data validation.”

A pop up will appear. Check the range of cells that will receive a checkbox. If you highlighted the column it will say something like B1:B1000 however, that first row is probably your column headers and you do NOT want a checkbox in that first cell. EDIT to say “B2” instead of “B1” or whatever letter your column is.
Pop up data validation


The default criteria is “List from a range.” Change this. Choose “Checkbox” from the dropdown list.
Checkbox criteria

And there you go! Actual checkboxes in Google Sheets!
Editable checkboxes

Sort Checked

The checkboxes return a value of True if checked or False if unchecked. If you click on the tiny triangle in the column indicator with the checkboxes you can choose to “Sort sheet.” This will cluster together the rows that are checked. Very handy.

Insert Menu

You can also use the Insert menu to create checkboxes for your highlighted range of cells.

Insert with Checkboxes

5 Easy Steps for Teaching with Digital Tools

Introducing digital tools into your teaching can seem challenging at first. There are many tools out there, and it might feel like there’s a lot to learn. But with easy steps for teaching with digital tools, you can start simply and gradually. There’s no need to dive in all at once – just take it one step at a time. Taking easy steps for teaching with digital tools starts with trying something!

Read More »
Students Prepare to Present

Help Your Students Prepare to Present

Maximize student success in presentations with ‘Speaker Notes by AliceKeeler,’ the ideal Google Slides add-on. Enhance how students prepare to present with easy transfer of speaker notes to Google Docs, promoting effective communication skills. Dive into the world of engaging, technology-aided presentations and empower students to shine in their academic endeavors. Discover the key to transforming student presentations into interactive, skill-building experiences.

Read More »

Infographic 7 Basic Steps for a Google Form

New to using Google Forms? This tool is essential for teachers to not only save time but to be adaptive to student needs. Use Forms to survey students, play games, personalize instruction, and assessment. This infographic on the 7 basic steps for a Google Form will help you get started.

Read More »

Online Workshop: Get Your Add-on Published

How can you make Google Workspace (Docs/Sheets/Slides) even better? You can create custom Add-ons with Google Apps Script. Wondering How to Get Your Google Workspace Add-on Published? Join Alice Keeler, Google Developer Expert, to learn the steps to get your Add-on officially published.

Read More »

5 thoughts on “The Reason to Love Google Sheets: Make Checkboxes

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.