Explainry Tutorials to Expert in IT

Data validation in Google Sheets

The data validation feature helps you to ensure accuracy while data entry. In this lesson, we will learn how the data validation feature works.

1- Select a range of cells e.g. A1:A6.

2- Visit Data tab and select Data Validation.

3- A Data validation box will appear.

In our example, we will restrict cells in the selected range in a way that you could only enter number values less than 10. For this:

4- Next to Criteria, choose the option: Number > Less than > 10. Click Save.

5- Result. When you will enter a number value greater than 10, you will get the invalid error message.

Now enter any number value less than 10, Gsheets will let you enter the value.

Copyright © 2016 - 2020 Explainry.com | All Rights Reserved