Vorlage:Video-Tabelle formatieren-English: Unterschied zwischen den Versionen

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen
Keine Bearbeitungszusammenfassung
Keine Bearbeitungszusammenfassung
Zeile 8: Zeile 8:
<p align="left">This is how you can assign ranges to a table in Excel:<br><br>
<p align="left">This is how you can assign ranges to a table in Excel:<br><br>
</p><p align="left">
</p><p align="left">
</p><ul>
</p><ol>
   <li> <p align="left">So that you can insert a table in Word, the table requires an assigned name or print area. To do this, select the entire range of the table in your Excel document.</p></li>
   <li> <p align="left">So that you can insert a table in Word, the table requires an assigned name or print area. To do this, select the entire range of the table in your Excel document.</p></li>
   <li> <p align="left">In the &ldquo;*Layout&rdquo; menu ribbon, in the &ldquo;Areas&rdquo; group, you can automatically define the print area you require for the previously defined selection by using the &ldquo;Print area&rdquo; function.</p></li>   
   <li> <p align="left">In the &ldquo;*Layout&rdquo; menu ribbon, in the &ldquo;Areas&rdquo; group, you can automatically define the print area you require for the previously defined selection by using the &ldquo;Print area&rdquo; function.</p></li>   
Zeile 20: Zeile 20:




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



Version vom 30. Juni 2023, 09:57 Uhr


A detailed explanation of the individual steps

This is how you can assign ranges to a table in Excel:

  1. So that you can insert a table in Word, the table requires an assigned name or print area. To do this, select the entire range of the table in your Excel document.

  2. In the “*Layout” menu ribbon, in the “Areas” group, you can automatically define the print area you require for the previously defined selection by using the “Print area” function.

  3. Assign a line type:

  4. So that you can assign a line type, you have to select the corresponding line or a cell from this line.

  5. In the “*Layout” menu ribbon, in the “Formatting” group you can use the “Line types” function to assign the various line types – such as “Single table header” for the table header.

  6. Assign column highlighting:

  7. To use one of the predefined column highlighting options predefined by firesys, select the column you want to highlight.

  8. In the “*Layout” menu ribbon, in the “Formatting” group, click on the “Highlight” menu and select a highlight from the drop-down menu.