[ c ]Cellstronaut
ProductsSelect Special
Select Special product icon

Select Special

v1.2for Google Sheets

Find cells by value, formula, note, formatting, or relation — then filter and act on them without writing a formula.

5 ★ 2500+ installs
OverviewPricingDocsChangelog
Overview

What it is

Select Special is a Google Sheets add-on that lets you select cells by value, formula, note, formatting, or relation — then filter and act on them.

Google Sheets has no native way to select cells by criteria — you either hunt for them by hand or fight with helper formulas. This add-on does it for you, with 14 selection types, advanced filters, a review panel, and data processing — all without leaving the sheet.


How it works

Four steps

Step 01
Pick your target
14 selection types — formulas, notes, blanks, validation, colors, and more.
Read docs
Step 02
Narrow it down
Add filters: value ranges, duplicates, date ranges, text patterns.
Read docs
Step 03
See what's found
Review every match in a list. Click to jump, toggle to include or exclude.
Read docs
Step 04
Process it
Expand to row or column, insert formulas
Read docs

Capabilities

Select, filter, act

Browse all docs
Select Special · all features
Entered values
Numbers, text, booleans, errors
Free
Formulas
By result value type
Free
Notes
Cells with comments
Free
Blank cells
Truly empty cells
Free
Visible cells only
Skip hidden rows/cols
Free
Data region
Contiguous block of data
Free
Last data cell
Bottom-right of data region
Free
Precedents
Cells a formula depends on
Free
Dependents
Cells that use a formula
Free
Data validation
Cells with validation rules
Free
Conditional formatting
Cells with CF applied
Free
Row differences
Rows that differ from active cell
Free
Column differences
Columns that differ from active cell
Free
Fill colors
Cells by background color
Free
Filters
Narrow the selection with type-specific filters
Advanced
Processing
Actions on selected cells
Advanced

Pricing

Simple pricing

Free
$0forever
  • Core 14 selection types
  • Blank cells
  • Fill Colors
  • Trace dependents
  • Visible cells only
  • 10+ more
Install free
AdvancedRecommended
$14/year · 2 accounts
14-day money-back
  • Everything in Free
  • Advanced filters
  • Data processing
  • Email support
  • Free trial. 7 days of actual use, not calendar days
Start free trial
Advanced
$3/month · 2 accounts
14-day money-back
  • Everything in Free
  • Advanced filters
  • Data processing
  • Email support
  • Free trial. 7 days of actual use, not calendar days
Start free trial

FAQ

Common questions

Is my data sent anywhere?

No. Select Special runs entirely inside your Google account. The only external connection is to Lemon Squeezy for license validation. No spreadsheet data ever leaves Google.

What happens to Pro features after cancel?

Your selection types and basic functionality remain free. Advanced filters, data processing, and unlimited rows are locked back to free limits.

Stop hunting cells.

Select Special finds exactly what you need — by type, formula, format, or relation. Free to start.