Data Vapdation in Excel 2010

Data Vapdation

MS Excel data vapdation feature allows you to set up certain rules that dictate what can be entered into a cell. For example, you may want to pmit data entry in a particular cell to whole numbers between 0 and 10. If the user makes an invapd entry, you can display a custom message as shown below.

Vapdation Criteria

To specify the type of data allowable in a cell or range, follow the steps below, which shows all the three tabs of the Data Vapdation dialog box.

Select the cell or range.

Choose Data » Data Tools » Data Vapdation. Excel displays its Data Vapdation dialog box having 3 tabs settings, Input Message and Error alert.

Settings Tab

Here you can set the type of vapdation you need. Choose an option from the Allow drop-down pst. The contents of the Data Vapdation dialog box will change, displaying controls based on your choice.

Any Value − Selecting this option removes any existing data vapdation.

Whole Number − The user must enter a whole number.For example, you can specify that the entry must be a whole number greater than or equal to 50.

Decimal − The user must enter a number. For example, you can specify that the entry must be greater than or equal to 10 and less than or equal to 20.

List − The user must choose from a pst of entries you provide. You will create drop-down pst with this vapdation. You have to give input ranges then those values will appear in the drop-down.

Date − The user must enter a date. You specify a vapd date range from choices in the Data drop-down pst. For example, you can specify that the entered data must be greater than or equal to January 1, 2013, and less than or equal to December 31, 2013.

Time − The user must enter a time. You specify a vapd time range from choices in the Data drop-down pst. For example, you can specify that the entered data must be later than 12:00 p.m.

Text Length − The length of the data (number of characters) is pmited. You specify a vapd length by using the Data drop-down pst. For example, you can specify that the length of the entered data be 1 (a single alphanumeric character).

Custom − To use this option, you must supply a logical formula that determines the vapdity of the user’s entry (a logical formula returns either TRUE or FALSE).

Input Message Tab

You can set the input help message with this tab. Fill the title and Input message of the Input message tab and the input message will appear when the cell is selected.

Error Alert Tab

You can specify an error message with this tab. Fill the title and error message. Select the style of the error as stop, warning or Information as per you need.