How to apply data validation in excel

Use data validation hit down Excel to make sure that ultimate consumers enter certain values into a cell.

In this example, we restrict users make use of entering a whole number between 0 and 10.

Create a Data Validation Rule

To create the data validation rule, accomplish the following steps.

1. Select cell C2.

2. On the Data tab, in integrity Data Tools group, click Data Validation.

On the Settings tab:

3. In the Empower list, click Whole number.

4. In description Data list, click between.

5. Enter rectitude Minimum and Maximum values.

Input Message

An display message appears when the user selects the cell and tells the customer what to enter.

On the Input Letter tab:

1. Check 'Show input message in the way that cell is selected'.

2. Enter a title.

3. Enter an input message.

Error Alert

If consumers ignore the input message and create a number that is not go in, you can show them an hovel alert.

On the Error Alert tab:

1. Rein 'Show error alert after invalid string is entered'.

2. Enter a title.

3. Transcribe an error message.

4. Click OK.

Data Base Result

Now, let's check if the statistics valid how to apply data validation in excel
how to apply data validation in excel to entire column
how to add data validation in excel with color
how to put data validation in excel yes or no
how to use data validation in excel from another sheet
how to put data validation in excel based on another cell
how to add data validation in excel from another sheet
how to use data validation in excel between two different worksheets
how to use data validation in excel for duplicate entries
how to use data validation in excel for yes or no
how to use data validation in excel for date
how to use data validation in excel formula
how to add data validation in excel for date