Select cells that have the same background color in the sheet.
Listing updated:December 17, 2025
Works with:
29K+
Overview
🎨 Manage Colors in Google Sheets™ 
AliceKeeler Select the Cells helps you visually organize your spreadsheet data. Single click a colored cell to target that color. Run the Add-on to highlight all matching cells in the range. 

ADDITIONAL FEATURES 
Count cells by color across the entire sheet. 
Count cells by color within a specific column. 
Automatically color code unique values with readable pastels. 
Insert large emoji stickers like ⭐ and 🏆 for visual feedback.

📖 Fluency Practice Tools 
This feature is from the book "50 Ways to Engage Students with Google Apps" by Alice Keeler and Heather Lyon. Randomly populate a word list into a grid for student practice. Easily clear the grid to restart the activity. Find the book at alicekeeler.com/books

💎 Premium Membership 
Become a premium member to support Add-on creation for educators at alicekeeler.com/membership. Your subscription unlocks advanced organization and automation features. 
Extract data to a new sheet based on background color. 
Create an automatic Table of Contents. 
Sort all sheets alphabetically. 
Randomly apply colors to all tabs. 
Create a color legend from your selection. 
Generate a summary count of all colors in a selected range.

🔒 Privacy & Safety Created by Google Developer Expert Alice Keeler. This Add-on collects NO user data. NO PII. Check out more of her Add-ons at http://alicekeeler.com/codedbyalice
Additional information
PricingFree of charge
Developer
Privacy policy
Terms of service
AliceKeeler Select the Cells will ask for the permissions shown below. Learn more
AliceKeeler Select the Cells will need access to your Google account
This will allow AliceKeeler Select the Cells to :
View and manage spreadsheets that this application has been installed in
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Mafalda Capelo
January 15, 2025
I do not know how to use the extension. I click on a cell, then on Extensions, then on the add-on and the only option it feeds me is Help. Is there a video where I could see it being used?
Is this review helpful?
Yes
No
Profile Picture
catticorner
April 27, 2024
this is so so handy for charts that rely on heavily color coding! makes it super easy to fine-tune colors when my boxes are all super scattered
Is this review helpful?
Yes
No
Profile Picture
Benedict Schor
March 1, 2023
I recently tried the AliceKeeler Select the Cells Addon for Google Sheets and I have to say, it's a game changer! This addon has completely revolutionized the way I work with data in Google Sheets. The AliceKeeler Select the Cells Addon allows me to easily select cells based on color. This is incredibly useful when working with large sets of data, as it allows me to quickly and easily isolate certain cells without having to manually search through the entire sheet. For example, if I have a sheet with various colors assigned to different types of data, I can quickly select all of the cells that are green, or all of the cells that are red. This makes it so much easier to analyze the data and spot any trends or patterns. Overall, I would highly recommend the AliceKeeler Select the Cells Addon for Google Sheets to anyone who works with data on a regular basis. It's incredibly easy to use, and it saves a ton of time and effort when working with large sets of data.
Is this review helpful?
Yes
No
Profile Picture
Spencer Vetrano
March 1, 2023
Oh wow this is easy.
Is this review helpful?
Yes
No
1-4 of 4
Search
Clear search
Close search
Google apps
Main menu