Cell validation

Cell validation creates a dropdown list specifying the only permitted values for a given cell.

(See also a sample demonstrating how this all works.)

To set it up cell validation

  1. Select Data, Validation.

    Specify a cell range containing the list of permitted values.

  2. Click OK.

Comments