We will see Data Validation feature in excel by which we will restrict user to fill a value within permissible limits in excel. ![]() Suppose there is a metric X and its permissible value could only be between 150 and 500 so in this case we expect the user to fill the value between 150 and 500. In this post we will see how we could restrict a user to enter value between a minimum and maximum value in excel.Ĭases such as inputting values from users for some metrics for which we know the minimum and maximum limits, we could restrict user to enter values in a cell within those limit.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |