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.