Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Google Sheets: Check Multiple Checkboxes At The Same Time

Google Sheets: Check Multiple Checkboxes At The Same Time

check a lot of checkboxes

Check A Bunch of Checkboxes

As expected the new feature in Google Sheets to be able to create a checkbox and select it is one of my favorite things in Google Sheets. I previously blogged how to insert them into your sheets! They are incredibly helpful for checking in students in a roster, although they have plenty of other innovative uses.
Checkboxes google sheets

Too Many Checks?

What if you need to check off a LOT Of checkboxes all at once? This can be a little disheartening. Click Click Click Click is only fun so many times. Luckily, we have a shortcut for this!

Use the Spacebar Key


Highlight a range of boxes by either clicking and dragging, or by clicking a cell, holding shift, and clicking another cell in the range. Press the spacebar, and all of the checkboxes in the range will be checked as true.
spacebar checkboxes

Google Sites: Aligning and Centering Text and Images

3 thoughts on “Google Sheets: Check Multiple Checkboxes At The Same Time

  1. I am using the checkboxes on a spreadsheet. I have tried to put in a count formula to give me a total count of how many checkboxes are in a column. It returns a “0”. Do you have a solution?

Leave a Reply

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

© 2024 All Rights Reserved.

❤️ Become a Premium Teacher Tech Member

Regular price is $249. Save $150 and pay only $99 for the 2024/2025 school year!

Monthly installments is only $12 a month.

Exclusive Teacher Tech Content! 
Exclusive Online Courses
Premium Add-ons for Google Workspace
Office Hours with Alice
Weekly Check In Support
Exclusive Webinars
And more! 

Exit this pop up by pressing escape or clicking anywhere off the pop up.