-- Select Special Cells for Google Sheets™--
The fastest way to find, select, and highlight blank cells, duplicates, formulas, merged cells, notes and more in Google Sheets™.

Select Special Cells instantly identifies blank cells, duplicate values, formulas, and annotated cells in your Google Sheets™ - saving hours of manual data cleanup and spreadsheet auditing.

🎯 Instantly Find What Matters Most
Select Special Cells is the essential Google Sheets™ add-on for data professionals, accountants, and analysts who need to clean, audit, and organize spreadsheets with precision and speed.

Whether you're removing blank cells, finding duplicates, auditing formulas, locating cell notes, spotting merged cells, finding typed-in constants - this lightweight yet powerful tool eliminates repetitive manual work and helps you maintain data integrity.

⚡ Key Features
1. Select Blank Cells Instantly
Quickly highlight all empty cells in your selected range - no scrolling, no guesswork.

💎Perfect for:
Data cleaning and validation
Identifying incomplete records
Finding gaps in datasets
Preparing data for analysis

💎Pro Feature: Detect whitespace-only cells (spaces that look blank but aren't), or find only cells with trailing spaces - ideal for data normalization.

2. Find Duplicate Cells in Seconds
Identify all duplicate values within your dataset with a single click.

💎Ideal for:
Removing redundant entries
Deduplicating imported data
Ensuring dataset uniqueness
Preventing duplicate entries during data entry

3. Select Formula Cells with Precision
Instantly detect all cells containing formulas - see exactly where your calculations are.

💎Great for:
Auditing complex spreadsheets
Debugging formula errors
Preparing spreadsheets for sharing
Understanding calculation logic

4. Find Cells with Notes
Locate all cells with annotations and comments (Insert > Note) in your range - useful for reviewing documented data and tracking cell-level notes.

5. Locate Merged Cells  ★ NEW
💎Great for:
Auditing complex spreadsheets
Fixing imported data in spreadsheets

💡 Why Choose Select Special Cells?
✅ Save hours of manual work
Manually searching for blanks, duplicates, formulas, merged cells is tedious and error-prone. This add-on automates the process in seconds so you can save lots of time!

✅ Improve data quality
Clean, structured data leads to better analysis and fewer errors. Quickly detect inconsistencies before they cause problems downstream.

✅ Simple, intuitive interface
No learning curve. Select your range, choose a feature, and get results instantly. Works exactly like you expect.

✅ Lightning-fast performance
Processes thousands of cells in seconds - optimized for large datasets and complex ranges.

A test found 400190 blank cells in 7 seconds! Imagine that time compounded everytime you use this extension.

✅ Highlight matches
Optionally highlight results with a clean, professional color for easy visibility and visual verification.

✅ Privacy & Security First
Your spreadsheet data stays in your spreadsheet. No external storage, no data sharing.

👥 Who benefits from this add-on?
Data Analysts managing large, complex datasets
Accountants auditing financial statements and transaction lists
Business Analysts cleaning and validating data
Spreadsheet Managers maintaining data quality
Freelancers & Consultants handling client data
Business Owners tracking operations and inventory
Anyone tired of manual spreadsheet cleanup and workflows

🔧 How it works
- Select your data range in Google Sheets™
- Open the Select Special Cells add-on (Add-ons menu)
- Choose your feature (Blank, Duplicate, Formula, Notes, etc)
- See results instantly - matching cells are selected and optionally highlighted
- Act on your data - copy, delete, format, or edit the selected cells

📊 Real-World Examples
"I need to clean imported data with missing values"
→ Use Select Blank Cells to find and fill gaps in seconds.

"My customer list has unknown duplicates"
→ Find Duplicate Cells reveals every duplicate entry instantly.

"I'm taking over a spreadsheet and need to understand all the calculations"
→ Select Formula Cells shows you every calculated field at a glance.

"I documented critical cells with notes and need to review them"
→ Find Cells with Notes lets you navigate all annotated data quickly.

🚀 Boost Your Spreadsheet Efficiency Today
If you regularly work in Google Sheets™, Select Special Cells will quickly become part of your daily workflow.

Install now and take control of your data - no more wasted time searching for critical cell types.

🔒 Privacy & Security
✅ Your data stays in your spreadsheet
✅ Built with privacy-first design

💪 What Makes This Different?
Unlike bloated spreadsheet tools, Select Special Cells focuses on doing a few critical things extremely well:
Speed — Results in seconds
Accuracy — Find exactly what you're looking for
Simplicity — No configuration, no learning curve
Reliability — Works consistently, every time
No Clutter — Just the features you actually need

💎Select Special Cells: Do more with your data. Spend less time searching.