Class 8: Data Validation Copy

Add Your Doubts: Click Here

Summary : In this class you will learn data validation. It is a feature that allows you to control the type of data entered into your worksheet. For example, Excel data validation allows you to limit data entries to a selection from a dropdown list and to restrict certain data entries, such as dates or numbers outside of a predetermined range.

Process: 1) Open the Data Validation dialog box. Select one or more cells to validate, go to the Data tab > Data Tools group, and click the Data Validation button. …

1. Create an Excel validation rule. …
2. Add an input message (optional) …
3. Display an error alert (optional)