How to find and select cells with values entered manually in Google Sheets
Why you need this tool
Working with large datasets in Google Sheets can get messy, especially when you need to focus on specific data. This tool lets you quickly go to special cells with manually entered values. It will select them all so you could analyze, modify or clean up your spreadsheet easily.
What are entered values?
Entered values are non-empty cells with the data that you manually enter or import into your tables, for example, text, numbers, dates, etc. Unlike cells with formulas, these values remain static and don’t change based on calculations.
This is different from Cells with formulas that contain formulas (calculations) rather than fixed data.
How to go to special cells with entered values
1. Select the range
Select the range(s) of cells where you want to find and select the entered values.
2. Pick the type of data to select
Choose the types of values you want to select:
- Numbers: Go to special cells with numeric values, such as integers, decimals, currencies, etc.
- Boolean: Select cells containing TRUE, FALSE, or checkbox values.
- Dates: Identify cells with dates.
- Text: Select cells with text strings.
- Errors: Go to special cells displaying formula error messages but without actual formulas.
3. Go to special cells
When you’re all set, click the Select button. The add-on will process your selection and highlight only the matching cells.