109k views
3 votes
You want to restrict data entry to whole numbers greater than 100. what do you create to enforce this data-entry restriction

1 Answer

3 votes

You can use data validation to restrict the type of data or the values (say whole numbers greater than 100) that users enter into a cell. The most commonly used data validation is to create a drop-down list to an Excel cell.

User Zkcro
by
7.7k points

No related questions found

Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.