Validating Number Entries in Excel
|
|
In many worksheets that you create, users will enter data to get the desired calculations and results. Ensuring valid data entry is an important task. You may want to restrict data entry to a certain range of dates, limit choices by using a list, or make sure that only positive whole numbers are entered. Providing immediate help to instruct users and clear messages when invalid data is entered is also essential to make the data entry experience go smoothly. |
|
Data Validation in Excel - Just study the images carefully: |
|
|
| Data Validation of number entries in Excel continued |