Subscriber only lesson.
Sign up to this course to view this lesson.
Data Validation Part 2
Data Validation explained.
When to use
This feature restricts what end users may type into a cell. Similarly to styles: many aren’t aware of this function in Excel, but once you use this functionality and understand what it can do for you, you never go back to whatever it was you were doing before.
Example 1 – Text Length
- To access data validation, from any cell in Excel:
- On the Data tab of the Ribbon, go to the Data Tools group and click the Data Validation icon (ALT + A + V + V)
- Change the selection in the ‘Allow’ drop down box to be ‘Text Length’.
- Enter the ‘Minimum’ and ‘Maximum’ characters to be 2 and 4 as shown in the example
- Click ‘OK’
- This will now only allow the users to type in text between 2 and 4 characters long
Example 2 – Custom Validation with the use of a formula
- Change the selection in the ‘Allow’ drop down box to be ‘Custom’
- In the ‘Formula’ box’ type the formula =MOD(E10,2)=0
- This formula will ensure that only an even number can be typed into that cell
Lesson notes are only available for subscribers.