How to perform Data Validation Settings in Microsoft Excel

In the Older Post I Already Gives Explanation On How To Edit Data Using the Replace Feature in Microsoft Excel, this time I will give further explanation of the Data Validation Settings in Microsoft Excel.

Data Validation settings is relatively easy because we only live determines what data should the user entered into a cell to be validated.

1. Press Ctrl + N to create a new workbook. Block cell or range to be validated, in this example the block range A1: A5.

2. Select the Data tab> Data Validation> Data Validation dialog box will bring up the data validation.

3. To perform the validation settings tab select settings. In the box Allow choice: you can choose the following options are available:

• Any Value. If you choose this option, then the user is allowed to enter any value without any restriction.
• Whole number. If you choose this option, then the user is only allowed to enter data such as numbers.
• Decimal. If you choose this option, then the user is only allowed to enter decimal data.
• List. If you choose this option, then the user is only allowed to enter the data on the list. The list can be derived from a cell reference or you enter directly into the Data Validation dialog box.
• Date. If you choose this option, then the user is only allowed to enter the data date.
• Time. If you choose this option, then the user is only allowed to enter time data.
• Text length. If you choose this option, then the user is only allowed to enter a long text data with certain characters.
• Custom. If you choose this option, then the user is only allowed to enter the data set using the formula.

4. For choice but List and Custom, you can make arrangements on the Data Options box:

• Between. If you choose this option, then the user is only allowed to enter data with a minimum value to the maximum value that you specify.
• Not Between. If you choose this option, then the user is not allowed to enter data with a minimum value to the maximum value that you specify.
• Equal to. If you choose opasi, the user is only allowed to enter data with the value you specify.
• Not equal to. If you choose this option, then the user is not allowed to enter data with the value you specify.
• Greater than. If you choose this option, then the user is only allowed to enter data with a value greater than the value you specify.
• Less than. If you choose this option, then the user is only allowed to enter data with a value less than the value you specify.
• Greater than or equal to. If you choose this option, then the user is only allowed to enter data with a value greater than or equal to the value you specify.
• Less than or equal to. If you choose this option, then the user is only allowed to enter data with values ​​less than or equal to the value you specify.

5. In this example select Whole number on the box Allow option: Select box option equal to the data. Enter a value of 10 in the text box Value: With these settings, the user is only allowed to enter numeric data with a value of 10.

6. To test the data type in cell A1 with a value other than 10, eg 11. Warning message box will appear as shown below.

Values ​​used in setting the Validation of data can also be derived from the reference cell. With these settings, the validation will always adjust the value contained in the reference cell is used.

1. For example, we will use cell B1 as a reference cell in the Data Validation. Type 10 in cell B1.

2. Block range A1: A5. Select the Data tab> Data Validation> Data Validation. Will Data Validation dialog box appears.

3. Select the Settings tab and then select Whole number on the box Allow option: In the Data option: select equal to. Type = B1 Minimum text box: as in the picture below.

Thus a brief explanation from me about How to Setup Data Validation in Microsoft Excel, may be useful for you all.