New: ready-to-use spreadsheet templatesExplore the collection →

Google Sheets tutorials›Spreadsheet basics›Reject invalid data

Google Sheets · Verified tutorial

Reject invalid data in Google Sheets

Add data validation to B2:B4 that accepts only numbers between 1 and 10, and set invalid data to be rejected. Leave the cells blank.

Verified by JosephineJuly 25, 2026About 60 seconds

Quick answer

Add data validation to B2:B4 that accepts only numbers between 1 and 10, and set invalid data to be rejected. Leave the cells blank.

Step-by-step

1

Select the targetAdd data validation to B2:B4 that accepts only numbers between 1 and 10, and set invalid data to be rejected.

2

Apply the changeLeave the cells blank.

Shortcut or faster method

Select the full target range first. This avoids repeating the same change cell by cell.

Expected result

B2:B4 has number-between validation for 1 through 10.

Common mistake

Applying the change to more rows, columns, or cells than the task specifies.

Troubleshooting

Re-select B2:B4 and repeat the final action. B2:B4 has number-between validation for 1 through 10.

Example spreadsheet data

This is the clean fixture used for the verified run.

Expense	Approval score
Hosting
Software
Design

Video transcript

Open the prepared Practice spreadsheet.
Select the target. Add data validation to B2:B4 that accepts only numbers between 1 and 10, and set invalid data to be rejected.
Apply the change. Leave the cells blank.
B2:B4 has number-between validation for 1 through 10.