Vorlage:Video-Autovalidierung erstellen-English: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
| Zeile 2: | Zeile 2: | ||
<center><div class="toccolours mw-collapsible mw-collapsed" style="width:800px; overflow:auto> | <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 style="font-weight:bolder;line-height:1.8;">A detailed explanation of the individual steps</div> | ||
<div class="mw-collapsible-content"> | <div class="mw-collapsible-content"> | ||
| Zeile 10: | Zeile 11: | ||
<li> <p align="left">To do this, open the Excel workbook in which you want to create an autovalidation.</li> | <li> <p align="left">To do this, open the Excel workbook in which you want to create an autovalidation.</li> | ||
<li> <p align="left">Select the desired cell.</li> | <li> <p align="left">Select the desired cell.</li> | ||
<li> <p align="left">Click the "Create" button in the "Validation" group in the "*Content" ribbon | <li> <p align="left">Click the "Create" button in the "Validation" group in the "*Content" ribbon. | ||
<br> → A dialog opens</li> | |||
<li> <p align="left">Select "Autovalidation" in the dialog. | |||
<br> → A dialog opens in which you can create an autovalidation and configure it according to your requirements.</li> | |||
<li> <p align="left">Make your adjustments. | |||
<br> → Finally, you can inform yourself about all your validations on the validation sheet.</li> | |||
</ol> | </ol> | ||
</p> | </p> | ||
| Zeile 19: | Zeile 23: | ||
</center> | </center> | ||
</div></div> | </div> | ||
</div> | |||
Version vom 7. August 2023, 13:47 Uhr
A detailed explanation of the individual steps
To create an Auto Validation:
-
To do this, open the Excel workbook in which you want to create an autovalidation.
-
Select the desired cell.
-
Click the "Create" button in the "Validation" group in the "*Content" ribbon.
→ A dialog opens -
Select "Autovalidation" in the dialog.
→ A dialog opens in which you can create an autovalidation and configure it according to your requirements. -
Make your adjustments.
→ Finally, you can inform yourself about all your validations on the validation sheet.