AliceKeeler Select the Cells is a Google Sheets Add-on designed to help teachers select cells with a background color more efficiently. With this add-on, teachers can single-click on any cell in a range that has a background color and automatically select all the other cells in that range with the same color. How Do You Highlight Cells of the Same Color
Category: Sheets
What! That is cool… Format Painter in Google Sheets
This is going to be amazing… and easy Use format painter in Google Sheets. It is truly fun to magically apply formatting in multiple places across your spreadsheet.
Sheets: Automating Sorting from Google Forms
If you use a Google Form and want to automate sorting in Google Sheets so that each time you open the spreadsheet you do not have redo the sorting here is a tutorial by Alice Keeler queen of spreadsheets.
How to Use XLOOKUP in Google Sheets
Do you have a table of student data and need to lookup the guardian name for example? In this how to use XLOOKUP in Google Sheets Alice Keeler shows you how to return values in a table based on a look up value.
How to Create a Spreadsheet in Google
Spreadsheets can be made using Google tools. If you wan to know how to create a spreadsheet in Google here are some tips from the Queen of Spreadsheets Alice Keeler
Bingo Ice Breaker with Alice Keeler
Have fun with a Bingo Ice Breaker! Try out this free Add-on by Alice Keeler to create a fun activity to get students or participants up out of their seats and getting to know each other.
FASTER! Create Rubrics for Google Classroom
Rubrics for Google Classroom are slow to create and hard to reuse. Try GC Rubric by Alice Keeler to create faster and better rubrics for Google Classroom.
Fast – Add Student Birthdays to Google Calendar
Add multiple Google Calendar events at once. CalAdd by Alice Keeler makes it fast to add student birthdays to Google Calendar. Or any list of calendar events.
How to Lock Areas of a Google Doc
You want to restrict editing on PART of a Google Doc. This step by step guide will show you a hack for how to lock areas of a google doc.
For Goodness Sake Only Put In Once in Google Sheets
The Rule of One! Only Put In Once in Google Sheets!! Here is how to handle if you need something twice or more in a spreadsheet.
Grab a Spreadsheet Cell from Each Student
Finally! A way to grab a spreadsheet cell from individual student spreadsheets. This allows you to easily review all students responses to a question in one place.
How to Update Student Spreadsheets
You make a copy of a spreadsheet per student, but what if you have a typo or want to add to the spreadsheet? sheetPusher by Alice Keeler and Heather Lyon helps you update student spreadsheets. Here is how to update student spreadsheets.
Something Fun for the End of the Year
What is something fun for students to do at the end of the year? While there are many choices, a fun word search can give students something to do while other students are finishing a task. Try my template!
Collaborate with Students – reuse TemplateTab
Reuse TemplateTab to collaborate with students and have less paperwork to grade.
COUNTA in Google Sheets™
How to use COUNTA in Google Sheets. This helpful formula works differently than COUNT. I will explain how.