How to find and select cells with entered values in Google Sheets
Why you need this tool
Efficiently managing data in Google Sheets can be challenging, especially when working with large datasets. This tool makes it easy to find and select cells with specific types of manually entered values, saving time and ensuring accuracy. Whether you’re analyzing data, cleaning up spreadsheets, or preparing reports, this feature simplifies your workflow.
What are entered values?
Entered Values refer to data manually typed or imported into cells. These values exclude formulas and are recognized by the add-on as non-empty cells without any calculations involved.
This is distinct from Cells with Formulas, where the add-on specifically targets cells containing formulas.
How to Use the Tool
First, you need to install the Select Special addon for Google Sheets. Visit the instruction page to learn how to do it step by step.
1. Select the range
Start by choosing the range or ranges of cells where you want to find and select entered values.
2. Customize selection options
Choose the types of values you want to select from the following options:
- Numbers: Targets cells with numeric data, including integers and decimals.
- Boolean: Selects cells containing TRUE, FALSE, or checkbox values.
- Dates: Identifies cells with date values.
- Text: Highlights cells containing text strings.
- Errors: Selects cells displaying formula error messages without an actual formula.
3. Execute the selection
Once your options are set, press the Select button at the bottom of the add-on interface. The add-on will process your selection and highlight the matching cells.