Vorlage:Video-HervorhebungZahlenverbergen-English: Unterschied zwischen den Versionen

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen
(Die Seite wurde neu angelegt: „center|808px|border <center><div class="toccolours mw-collapsible mw-collapsed" style="width:800px; overflow:a…“)
 
Keine Bearbeitungszusammenfassung
Zeile 7: Zeile 7:
<p align="left">To use the highlighting functions of firesys: <br><br>
<p align="left">To use the highlighting functions of firesys: <br><br>
<p align="left">
<p align="left">
<ul>
<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">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>  
   <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>  
Zeile 18: Zeile 18:
   <li> <p align="left">The selected table is updated and the numbers are replaced by X-characters and a magenta highlighting.</li>  
   <li> <p align="left">The selected table is updated and the numbers are replaced by X-characters and a magenta highlighting.</li>  


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



Version vom 30. Juni 2023, 10:45 Uhr


A detailed explanation of the individual steps

To use the highlighting functions of firesys:

  1. Open an Excel workbook and select the cells you want to highlight on the worksheet.

  2. Click the "Highlighting" button in the "Formatting" group in the "*Design" menu band and select the "Hide numbers (red)" function.

  3. The selected cells are highlighted in red.

  4. Now switch to the corresponding Word document and select the appropriate table.

  5. Click on the button "firesys settings" in the group "firesys" and select the tab "Data from Excel".

  6. 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.

  7. Now you can close the firesys settings.

  8. Click on the "*Contents" tab, in the "Excel Data" group on the "Update*" button.

  9. The selected table is updated and the numbers are replaced by X-characters and a magenta highlighting.