Vorlage:Video-Validierung erstellen-English

Aus firesys Hilfe
Version vom 2. Januar 2020, 13:12 Uhr von O.wendt (Diskussion | Beiträge) (Die Seite wurde neu angelegt: „ 808px|center|border <center><div class="toccolours mw-collapsible mw-collapsed" style…“)
(Unterschied) ← Nächstältere Version | Aktuelle Version (Unterschied) | Nächstjüngere Version → (Unterschied)
Zur Navigation springen Zur Suche springen


A detailed explanation of the individual steps

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.