Vorlage:Video-Validierung erstellen-English: Unterschied zwischen den Versionen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
| Zeile 1: | Zeile 1: | ||
[[Datei:Firesys Validierungen-erstellen.webm|808px|center|border]] | |||
<center> | |||
<div class="toccolours mw-collapsible mw-collapsed" style="width:800px; overflow:auto> | |||
<div style="font-weight:bolder;line-height:1.8;">A detailed explanation of the individual steps</div> | |||
<div class="mw-collapsible-content"> | |||
<p align="left">This is how you insert a new validation in Excel: <br><br> | |||
<ol> | |||
<li> <p align="left">Click on the “Create validation” button in the “*Validation” menu ribbon in the “Validation and consistency” group | |||
<br> → A selection dialog opens, displaying the various validation types. </li> | |||
<li> <p align="left"> Select the “Single validation” function here. | |||
<br> → Your Excel worksheet is extended with the validation work area.</li> | |||
<li> <p align="left">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”.</p></li> | |||
<li> <p align="left">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”.</p></li> | |||
<li> <p align="left">Click “OK” to confirm the prompt. | |||
<br> → An information dialog confirms that the validation was created.</li> | |||
<li> <p align="left">You can then use the “Go to validation worksheet” function to open the validation worksheet. | |||
<br> → your validation is displayed.</li> | |||
</ol> | </ol> | ||
</center> | </center> | ||
</div> | |||
</div></div> | </div> | ||
Aktuelle Version vom 20. September 2023, 15:04 Uhr
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.
→ your validation is displayed.