Skip to content

Simple Data Validation in Google Sheets

In this article, you will learn how to apply simple data validation to specific cells in Google Sheets.

What Is Data Validation

Data validation is a feature that ensures only certain values are entered into specific cells.

For example, data validation can be used to ensure that only positive numbers are entered into cell B2.

Another instance would be to make sure that only values from a specified list are entered into a specific cell.

If you’re still confused, follow the simple example below.

Data Validation Example

In this example, we will show you how to add data validation to make sure only a number between 1 and 10 can be entered into cell C3.

Start by selecting cell C3.

Next, click on Data in the Google Sheets Tabs, and then select Data Validation.

The Data Validation panel will open on the right side of your spreadsheet. Go ahead and click on the Add rule button.

 

Setup the Criteria as follows.

  1. Select Is between
  2. Enter a value of 1
  3. Enter a value of 10

 

Next, click on Advanced options.

 

Make sure you select Reject the input so that the user cannot enter a value outside the constraints of the data validation.

 

You can also check the Show help text for a selected cell checkbox if you want to. If you do, you can customize the error message that is displayed to anyone who enters a value that does not comply with the data validation rules set in place.

 

Finally, click Done. You can now see your new validation rule listed in the Data validation rules panel.

You can test out the data validation by trying to enter a value of 12 into cell C3. An error message should appear signifying that your data validation is working correctly.

And that’s how to apply and use simple data validation in Google Sheets.

This Post Has 0 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top