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. …
- Create an Excel validation rule. …
- Add an input message (optional) …
- Display an error alert (optional)
