Vorlage:Video-Validierung erstellen-English: Unterschied zwischen den Versionen

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen
Keine Bearbeitungszusammenfassung
Keine Bearbeitungszusammenfassung
Zeile 7: Zeile 7:
<div class="mw-collapsible-content">
<div class="mw-collapsible-content">
<p align="left">This is how you insert a new validation in Excel: <br><br>
<p align="left">This is how you insert a new validation in Excel: <br><br>
</p><ul>
</p><ol>
   <li> <p align="left">Click on the &ldquo;Create validation&rdquo; button in the &ldquo;*Validation&rdquo; menu ribbon in the &ldquo;Validation and consistency&rdquo; group.</p></li>  
   <li> <p align="left">Click on the &ldquo;Create validation&rdquo; button in the &ldquo;*Validation&rdquo; menu ribbon in the &ldquo;Validation and consistency&rdquo; group.</p></li>  
   <li> <p align="left">A selection dialog opens, displaying the various validation types. Select the &ldquo;Single validation&rdquo; function here.</p></li>  
   <li> <p align="left">A selection dialog opens, displaying the various validation types. Select the &ldquo;Single validation&rdquo; function here.</p></li>  
Zeile 16: Zeile 16:
   <li> <p align="left">You can then use the &ldquo;Go to validation worksheet&rdquo; function to open the validation worksheet where your validation is displayed.</p></li>  
   <li> <p align="left">You can then use the &ldquo;Go to validation worksheet&rdquo; function to open the validation worksheet where your validation is displayed.</p></li>  


</ul>
</ol>
</p>
</p>



Version vom 30. Juni 2023, 11:12 Uhr


A detailed explanation of the individual steps

This is how you insert a new validation in Excel:

  1. Click on the “Create validation” button in the “*Validation” menu ribbon in the “Validation and consistency” group.

  2. A selection dialog opens, displaying the various validation types. Select the “Single validation” function here.

  3. Your Excel worksheet is extended with the validation work area.

  4. 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”.

  5. 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”.

  6. Click “OK” to confirm the prompt. An information dialog confirms that the validation was created.

  7. You can then use the “Go to validation worksheet” function to open the validation worksheet where your validation is displayed.