Stop Manually Searching Cells in Google Sheets™
Select Special Cells is a lightweight Google Sheets™ add-on that helps you instantly select:
- Blank cells
- Duplicate values
- Formula cells
No formulas. No filters. No manual scanning.
Just select → act → move on.
What is Select Special Cells?
Select Special Cells is a utility built to solve a simple but time-consuming problem in Google Sheets™:
Finding specific types of cells quickly.
Instead of writing formulas or applying filters every time, this add-on lets you directly select the cells you care about – so you can take action immediately.
It’s built for speed, accuracy, and real workflows.
What problems it solves
- Missing data hiding in blank cells
- Duplicate entries affecting reports
- Difficulty auditing formulas in large sheets
- Time wasted on repetitive manual checks
If you work with data regularly, this removes friction instantly.
Where to find it
You can download this add-on for FREE by searching for “Select Special Cells” from the Google Workspace Marketplace:
https://workspace.google.com/marketplace/app/select_special_cells/1066791307119?flow_type=2
How to install
- Open Google Sheets™
- Go to Extensions → Add-ons → Get add-ons
- Search for Select Special Cells
- Click Install and authorize
Once installed:
- Go to Extensions → Select Special Cells
- Choose what you want to select
- Done
How it works
- Open your sheet
- Launch the add-on
- Choose:
- Blank cells
- Duplicate cells
- Formula cells
- The add-on instantly selects them for you
You can then format, delete, or analyze those cells immediately.
Detailed Guide
If you want to read a deeper walkthrough with use cases and explanations:
👉 Read the full guide here:
How to Select Blank, Duplicate, and Formula Cells in Google Sheets™
Coming Soon
A full video walkthrough demo on use-cases.