Adding Data Validation to a Cell / Settings Tab

In this topic, you add Data Validation to a cell.


  1. Select the cell you want to validate.

    Step 1
  2. Click the Data tab.

    Step 2
  3. In the Data Tools Group, click the Data Validation drop down menu.

    Step 3
  4. Select Data Validation.

    Step 4
  5. Settings Tab:


    On the Settings Tab, under Allow, select the type of criteria you want to allow in the cell.

    Step 5
  6. In this example, click Whole number

    Step 6
  7. Click in the Minimum: field.

    Step 7
  8. Enter a Minimum number.  In this example,

    enter 0 (zero).

    Step 8
  9. Click in the Maximum: field.

    Step 9
  10. Enter a Maximum number.   In this example, enter 9 (nine).

    Step 10
  11. Click the OK button.

    Step 11

After completing this topic, you are able to add data validation to a cell.