Vorlage:Video-Arbeitsblatt automatisieren mit Optionen-English: Unterschied zwischen den Versionen
(Die Seite wurde neu angelegt: „border|center|810px <center><div class="toccolours mw-collapsible mw-collapsed" style="width:800px; o…“) |
Keine Bearbeitungszusammenfassung |
||
| (Eine dazwischenliegende Version von einem anderen Benutzer wird nicht angezeigt) | |||
| Zeile 2: | Zeile 2: | ||
<center><div class="toccolours mw-collapsible mw-collapsed" style="width:800px; overflow:auto> | <center> | ||
<div style="font-weight:bolder;line-height:1.8;">A detailed explanation of the individual steps</div> | <div class="toccolours mw-collapsible mw-collapsed" style="width:800px; overflow:auto> | ||
<div class="mw-collapsible-content"> | <div style="font-weight:bolder;line-height:1.8;">A detailed explanation of the individual steps</div> | ||
<p align="left">How to use the options in the automated worksheet:<br><br> | <div class="mw-collapsible-content"> | ||
< | <p align="left">How to use the options in the automated worksheet: | ||
<br><br> | |||
<ol> | |||
<li> <p align="left">Open the workbook with the automated worksheet in which you want to insert values.</li> | |||
</ | <li> <p align="left">Click the <b>"Insert"</b> button in the <b>"*Contents"</b> menu in the <b>"Master values"</b> group. | ||
</ | <br> → A selection dialog opens</li> | ||
<li> <p align="left"> select <b>"Automate worksheet"</b>.</li> | |||
<li> <p align="left">While the master value cell to be filled is selected, search in the task pane under <b>"Values"</b> for the account to be inserted. The middle button under <b>"Actions"</b> transfers the corresponding values including the name to the corresponding row.</li> | |||
<li> <p align="left">Now select the cell in which an inverted value should be inserted.</li> | |||
<li> <p align="left">After selecting the correct account, click on <b>#invert</b> under <b>"Options"</b> and select the left button under <b>"Actions"</b> to transfer the values without text. Here the signs were reversed.</li> | |||
<li> <p align="left">Next, select the cell with the average value in which an absolute value is to be inserted.</li> | |||
<li> <p align="left">After selecting the desired account, click on <b>#absolute</b> under <b>"Options"</b> and select the left button under <b>"Actions"</b> to transfer the values without text. Here the signs were ignored.</li> | |||
</ol> | |||
</center> | </center> | ||
</div> | |||
</div></div> | </div> | ||
Aktuelle Version vom 8. August 2023, 08:43 Uhr
How to use the options in the automated worksheet:
-
Open the workbook with the automated worksheet in which you want to insert values.
-
Click the "Insert" button in the "*Contents" menu in the "Master values" group.
→ A selection dialog opens -
select "Automate worksheet".
-
While the master value cell to be filled is selected, search in the task pane under "Values" for the account to be inserted. The middle button under "Actions" transfers the corresponding values including the name to the corresponding row.
-
Now select the cell in which an inverted value should be inserted.
-
After selecting the correct account, click on #invert under "Options" and select the left button under "Actions" to transfer the values without text. Here the signs were reversed.
-
Next, select the cell with the average value in which an absolute value is to be inserted.
-
After selecting the desired account, click on #absolute under "Options" and select the left button under "Actions" to transfer the values without text. Here the signs were ignored.