Vorlage:Video-Validierung erstellen-English
This is how you insert a new validation in Excel:
-
Click on the “Create validation” button in the “*Validation” menu ribbon in the “Validation and consistency” group.
-
A selection dialog opens, displaying the various validation types. Select the “Single validation” function here.
-
Your Excel worksheet is extended with the validation work area.
-
Use the mouse cursor to select the cell for which the validation should be created and in the “Value 1” range, click on “Transfer value from cell”.
-
Now select the cell in your Excel workbook that contains the second value of the validation and in the “Select value 2” range, click on “Transfer value from cell”.
-
Click “OK” to confirm the prompt. An information dialog confirms that the validation was created.
-
You can then use the “Go to validation worksheet” function to open the validation worksheet where your validation is displayed.