Vorlage:Video-HervorhebungZahlenverbergen-English: Unterschied zwischen den Versionen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
| 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">To use the highlighting functions of firesys: <br><br> | <div class="mw-collapsible-content"> | ||
<p align="left">To use the highlighting functions of firesys: <br><br> | |||
<ol> | <ol> | ||
<li> <p align="left">Open an Excel workbook and select the cells you want to highlight on the worksheet.</li> | |||
<li> <p align="left">Click the "Highlighting" button in the "Formatting" group in the "*Design" menu band and select the "Hide numbers (red)" function.</li> | |||
<br> → The selected cells are highlighted in red.</li> | |||
<li> <p align="left">Now switch to the corresponding Word document and select the appropriate table.</li> | |||
<li> <p align="left">Click on the button "firesys settings" in the group "firesys" and select the tab "Data from Excel".</li> | |||
<li> <p align="left">In the "Hide numbers" group, you can activate the function "Hide Excel cells with a red background during import" and then specify the number of X-characters to replace the numbers.</li> | |||
<li> <p align="left">Now you can close the firesys settings.</li> | |||
<li> <p align="left">Click on the "*Contents" tab, in the "Excel Data" group on the "Update*" button. | |||
<br> → The selected table is updated and the numbers are replaced by X-characters and a magenta highlighting.</li> | |||
</ol> | </ol> | ||
</center> | </center> | ||
</div> | |||
</div></div> | </div> | ||
Aktuelle Version vom 8. August 2023, 14:23 Uhr
To use the highlighting functions of firesys:
-
Open an Excel workbook and select the cells you want to highlight on the worksheet.
-
Click the "Highlighting" button in the "Formatting" group in the "*Design" menu band and select the "Hide numbers (red)" function.
-
Now switch to the corresponding Word document and select the appropriate table.
-
Click on the button "firesys settings" in the group "firesys" and select the tab "Data from Excel".
-
In the "Hide numbers" group, you can activate the function "Hide Excel cells with a red background during import" and then specify the number of X-characters to replace the numbers.
-
Now you can close the firesys settings.
-
Click on the "*Contents" tab, in the "Excel Data" group on the "Update*" button.
→ The selected table is updated and the numbers are replaced by X-characters and a magenta highlighting.
→ The selected cells are highlighted in red.