Locate and select cells by type: values, formulas, notes, blanks, visible cells, precedents, fill colors, dependents, validations, formatting, and differences.
Listing updated:ā§¨ā§Ž āϜ⧁āύ, ⧍ā§Ļ⧍ā§Ģ
Works with:
ā§§Â āĻšāĻž+
āĻāĻ• āύāϜāϰ⧇
🚀 Find, select, and highlight cells in spreadsheets with Select Special!
Select Special is a tool that helps you quickly find and select specific types of cells for data analysis, auditing, and cleanup.

🔎 Key Features:
✅ Find manually entered values – Select cells that contain typed data (numbers, text, dates, errors, etc.)
✅ Highlight formulas & results – Select cells with formulas whose results match specified criteria (numbers, text, dates, etc.).
✅ Identify row & column differences – Spot discrepancies in values and formulas across rows and columns for better data accuracy.
✅ Trace precedents & dependents – See which cells affect or depend on a formula.
✅ Find Colors – Identifies and highlights cells filled with color.
✅ Find blank cells – Locate empty cells for cleaning or adding missing data.
✅ Select visible cells only – Avoid hidden rows and columns when analyzing data.
✅ Locate cells with data validation – Identify cells with specific validation rules.
✅ Find cells with notes – Highlight cells that contain notes for context or collaboration.
✅ Detect conditional formatting rules – Easily locate cells with conditional formatting applied.
✅ Select entire data regions – Automatically detect and highlight contiguous data ranges.
✅ Jump to the last data cell – Quickly navigate to the last cell in a dataset.

🔍 Works seamlessly in spreadsheet applications! Perfect for data analysts, accountants, and anyone working with large datasets.
Additional information
PricingāĻĢā§āϰāĻŋ
Developer
āύāύ-āĻŸā§āϰ⧇āĻĄāĻžāϰ
āĻ—ā§‹āĻĒāĻ¨ā§€ā§ŸāϤāĻž āύ⧀āϤāĻŋ
āĻĒāϰāĻŋāώ⧇āĻŦāĻžāϰ āĻļāĻ°ā§āϤāĻžāĻĻāĻŋ
āϰāĻŋāĻĒā§‹āĻ°ā§āϟ āĻ•āϰ⧁āύFlag as inappropriate
Select Special will ask for the permissions shown below. Learn more
Select Special will need access to your Google account
This will allow Select Special to :
āϝ⧇ āĻ¸ā§āĻĒā§āϰ⧇āĻĄāĻļā§€āϟāϗ⧁āϞāĻŋāϰ āĻŽāĻ§ā§āϝ⧇ āĻāχ āĻ…ā§āϝāĻžāĻĒā§āϞāĻŋāϕ⧇āĻļāĻžāύāϟāĻŋ āχāύāĻ¸ā§āϟāϞ āĻ•āϰāĻž āĻšā§Ÿā§‡āϛ⧇ āϤāĻžāĻĻ⧇āϰ āĻĻ⧇āϖ⧇ āĻ“ āĻĒāϰāĻŋāϚāĻžāϞāύāĻž āĻ•āϰ⧇
āφāĻĒāύāĻžāϰ āϏāĻŦ Google Sheets āĻ¸ā§āĻĒā§āϰ⧇āĻĄāĻļāĻŋāϟ āĻĻ⧇āϖ⧇
Google āĻāϰ āĻ…ā§āϝāĻžāĻĒā§āϞāĻŋāϕ⧇āĻļāύ⧇āϰ āĻĒā§āϰāĻŽā§āĻĒāϟ āĻāĻŦāĻ‚ āϏāĻžāχāĻĄāĻŦāĻžāϰ⧇ āϤ⧃āĻ¤ā§€ā§Ÿ āĻĒāĻ•ā§āώ⧇āϰ āĻ“ā§Ÿā§‡āĻŦ āĻ•āĻ¨ā§āĻŸā§‡āĻ¨ā§āϟ āĻĻ⧇āĻ–āĻžā§Ÿ āĻāĻŦāĻ‚ āϚāĻžāϞāĻžā§Ÿ
āφāĻĒāύāĻžāϰ āĻĒā§āϰāĻžāĻĨāĻŽāĻŋāĻ• āχāĻŽā§‡āϞ āφāχāĻĄāĻŋ āĻĻ⧇āϖ⧁āύ
āφāĻĒāύāĻŋ āϏāĻ°ā§āĻŦāϜāύ⧀āύāĻ­āĻžāĻŦ⧇ āωāĻĒāϞāĻ­ā§āϝ āĻ•āϰ⧇āϛ⧇āύ āĻāĻŽāύ āϝ⧇āϕ⧋āύāĻ“ āĻŦā§āϝāĻ•ā§āϤāĻŋāĻ—āϤ āϤāĻĨā§āϝ āϏāĻš āφāĻĒāύāĻžāϰ āĻŦā§āϝāĻ•ā§āϤāĻŋāĻ—āϤ āϤāĻĨā§āϝ āĻĻ⧇āϖ⧇
āϰāĻŋāĻ­āĻŋāω
Language:
āĻāχ āĻ…āύ⧁āϝāĻžā§Ÿā§€ āϏāĻžāϜāĻžāύ:
Google āϰāĻŋāĻ­āĻŋāω āĻ“ āϰ⧇āϟāĻŋāĻ‚ āϝāĻžāϚāĻžāχ āĻ•āϰ⧇ āύāĻžāĨ¤ āϰāĻŋāĻ­āĻŋāω āϏāĻŽā§āĻĒāĻ°ā§āϕ⧇ āφāϰāĻ“ āϜāĻžāύ⧁āύ
No comments
āϏāĻžāĻ°ā§āϚ āĻ•āϰ⧁āύ
āϏāĻžāĻ°ā§āϚ āĻŽā§āϛ⧁āύ
āϏāĻžāĻ°ā§āϚ āĻŦāĻ¨ā§āϧ āĻ•āϰ⧁āύ
Google āĻ…ā§āϝāĻžāĻĒā§āϞāĻŋāϕ⧇āĻļāĻžāύāϗ⧁āϞāĻŋ
āĻĒā§āϰāϧāĻžāύ āĻŽā§‡āύ⧁