🚀 Select Special — Find, Select & Highlight Cells in Spreadsheets

Select Special is the ultimate cell selection tool for data analysis, auditing, formula tracing, and cleanup — all without writing complex formulas.

🔎 Find & Select Any Cell Type

✅ Find constants (manually entered values) — Select cells with typed numbers, text, dates, booleans, or errors.

✅ Find formulas — Highlight cells containing formulas. Filter results by formula output type: numbers, text, dates, booleans, or errors.

✅ Find blank & empty cells — Instantly locate empty cells for cleanup, filling missing data, or validation.

✅ Find duplicate or unique values — Filter any selection to show only duplicates or unique values across your data.

✅ Find cells by background color — Identify and select cells by fill color. Match the exact same color or find all colored cells at once.

✅ Trace formula precedents & dependents — See which cells feed into a formula or depend on it. Choose between direct references or all levels deep.

✅ Find row & column differences — Spot discrepancies in values and formulas across rows and columns for data accuracy and auditing.

✅ Find cells with notes — Highlight cells that contain notes. Filter by unique or duplicate note text.

✅ Find conditional formatting — Locate cells with conditional formatting rules applied. Match the same rule or find all formatted cells.

✅ Find data validation rules — Identify cells with specific validation rules. Select matching rules or all validated cells.

✅ Select visible cells only — Skip hidden rows and columns when copying or analyzing filtered data.

✅ Select current data region — Automatically detect and highlight the full contiguous data block around your active cell.

✅ Jump to the last data cell — Navigate instantly to the last cell with data in a row or column.

⚡ Advanced Filtering (Paid)

Narrow down results for any action by:

Value type — numbers, text, dates, booleans, error values (#N/A, #DIV/0!, #VALUE!, etc.)
Unique or duplicate — isolate unique values or highlight repeated ones
Date ranges — narrow results to specific date intervals

⚡ Data Processing Tools (Paid)

✅ Place aggregate formulas — Add SUM, COUNT, COUNTA, AVERAGE, MIN, or MAX formulas directly next to your selected range, in a new column or row.

✅ Expand selection to full row or column — Extend your selection across the entire data row or column — left, right, up, down, or both directions at once.

💼 Built for data analysts, accountants, auditors, and anyone working with large datasets.

Free trial included — 30 days of actual use, not calendar days.