Data Validation Restricting Cell Entries
It is possible to restrict cells so that only certain values can be entered into them, by controlling what data is entered into a cell will make worksheets more reliable.For example you may require a column to only accept numeric numbers for calculations, therefore you may wish an error message to be displayed if any other value is entered like text.
In the Example below we want to allow only a who number between 10 and 20 to be entered in column ‘A’.
1. Select column ‘A’
2. Click Data tab → Data Validation.
3. Setting: Setting the Validation criteria
Allow: Data type to be entered.
Data: additional setting.
These additional setting will change depending on what data type that you have selected.
4. Input Message:
Enter a Title for the Input Message box (optional).
Enter the Message to be displayed to the user.
5. Error Alert: display an error when the wrong data has been entered into the cell
Enter a Title for the Error Alert Message box (optional).
Enter the Error Message to be displayed to the user.
Data Validation Building a Drop-‐Down List.
A drop-down list could contain a list of departments that you choose from, this way a user must select from the list not typing in the data manually causing errors, for example typing a department two different ways ‘HR’ or ‘Human resources’.1. Create a list of department to choose from. In this example type four different department using the range A1:A4.
2. Click Data tab → Data Validation.
3. Setting: Setting the Validation criteria.
Allow: List.
Source: Highlight the source (departments to choose from).
4. Input Message:
Let the user know what to type into the cell.
Enter a Title for the Input Message box (optional).
Enter the Message to be displayed to the user.
5. Error Alert: display an error when the wrong data has been entered into the cell
Enter a Title for the Error Alert Message box (optional).
Enter the Error Message to be displayed to the user.
No comments:
Post a Comment