Скачать или смотреть Input Restriction with Data Validation Function

How to create restriction using data validation.
In order to retain the validity of data, sometimes you need to restrict the input value and offer some tips for further steps. For example, age in this sheet should be whole numbers and all people participating in this survey should be between 18 and 65 years old. To ensure that data outside of this age range isn’t entered, go to Data. Data Validation. Setting. Input the conditions by selecting whole number from the allow option. Under the data, select between. Then set the minimum and maximum by entering 18 and 65. Under the Input Message tab, you can give prompts like, “Please input your age with whole number, from 18 to 65.” Users will get this prompt when hanging the pointer in this area and get a warning message if the inputted information is unqualified.
For more videos, visit:    / igorotech  
#igorotech #igorotech #ComputerKnowledge #ComputerTips #Shorts #ExcelQuickTips