How to find and select manually entered values in Google Sheets

Select 'Entered values' to go to special cells with manually entered values in Google Sheets

Why use Select Special in Google Sheets

When working with large datasets in Google Sheets, it’s easy to lose track of which cells contain manually entered data and which contain formulas.

This is where the Select Special add-on comes in. It finds and selects only the cells that contain data entered manually, so you can quickly analyze, clean up, or edit only the cells that matter.

What are manually entered values

Manually entered values, or static values, are any non-empty cells with the data you type or paste into a spreadsheet. This includes:

Numbers: Integers, decimals, percentages, etc
Text strings
Boolean values: TRUE/FALSE or checkboxes
Error values copied without formulas, for example, #VALUE!, #REF!
See Error.Type in the Google documentation.
Dates

Unlike cells with formulas, manually entered values remain static and don’t change based on calculations.

Why find manually entered values

Manually entered values are often the starting point in a spreadsheet. They feed your formulas and charts. Finding them helps you:

Fix formatting
Catch data-entry mistakes or outdated content
Quickly edit or validate core spreadsheet inputs

How to find and select entered values with Select Special

1. Select the range(s)

Select the range(s) of cells where you want to find manually entered values.

2. Choose the type of values to select

Mark the checkboxes for the data types you want to select:

Numbers: Whole numbers, decimals, currencies, etc
Text: Text strings
Boolean: TRUE, FALSE, or checkbox values
Errors: Cells displaying formula error messages but without actual formulas
Dates

3. Select matching entered values

Click Select at the bottom of the add-on. It will select all manually entered cells matching your criteria.