Conditions for “Data Validation “

We use the “Data Validation” command if we want to be sure that users of the “Worksheet” enter correct information into a cell.

In order to apply “Data validation”, we first select the cell or “Range” (1) which we intend to use for “Data validation”.

Then we choose the “Data” tab in the “Ribbon” and click the “Data Validation” button.

In the “Data Validation” dialog which appears, the “Settings” tab (2) is selected.

By default, under the “Validation Criteria” , the “Allow” box shows “Any value”.

Click the downward pointing arrow (3) next to this box. This opens a list of different validation options. These options use comparison operators to check data that is entered.

In this example I selected the “Range” to be only in the values between 0 and 10. So I chose “Whole number” from the list.

In the “Data:” (4), I choose the option “between”.
In the “Minimum” (5), I give the value 0.
In the “Maximum” (6), the value 10.

At the top right we find a checkbox: “Ignore blank” (7).
When this is checked, it will let us ignore blank cells.

And at the bottom we have the checkbox “Apply these changes …” (8).
When this is checked, “Excel” will change the “Data validation” for all the cells to change using the “Data validation”.

Click OK when all settings are complete.

Click OK when all settings are complete.

If that is not the case, suppose you give 12 , “Excel” will warn us that this is impossible.

Clicking on the “Retry” button will give us another chance to add data

Clicking the “Cancel” button will delete the input, but the cell will remain selected.

Clicking the “Help” button opens Microsoft’s “Excel Help”.

 

We can also tell users what the choices are.
We see this in the next lesson.

Featured Courses

• Downloading iPad Apps
• Lesson 1: Introduction to Publisher
• Lesson 65: File Formats