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

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen
Keine Bearbeitungszusammenfassung
Keine Bearbeitungszusammenfassung
 
Zeile 3: Zeile 3:




<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;">Die Erklärung der einzelnen Schritte im Detail</div>
<p align="left">This is how you can assign ranges to a table in Excel:<br><br>
<div class="mw-collapsible-content">
</p><p align="left">
</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">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> 
  <p align="left"><b>Assign a line type:</b>
  </p><li> <p align="left">So that you can assign a line type, you have to select the corresponding line or a cell from this line.</p></li>
  <li> <p align="left">In the &ldquo;*Layout&rdquo; menu ribbon, in the &ldquo;Formatting&rdquo; group you can use the &ldquo;Line types&rdquo; function to assign the various line types &ndash; such as &ldquo;Single table header&rdquo; for the table header.</p></li>
<p align="left"><b>Assign column highlighting:</b>
  </p><li> <p align="left">To use one of the predefined column highlighting options predefined by firesys, select the column you want to highlight.</p></li>
  <li> <p align="left">In the &ldquo;*Layout&rdquo; menu ribbon, in the &ldquo;Formatting&rdquo; group, click on the &ldquo;Highlight&rdquo; menu and select a highlight from the drop-down menu.</p></li>  


<p align="left"> This is how you can assign ranges to a table in Excel: <br>


<ol>
<li> <p align="left"> To be able to insert a table in Word, it needs an assigned name or print area. To do this, select the complete range of the table in your Excel document. </li>
<li> <p align="left"> Click on the "Print Area" button in the "*Design" ribbon in the "Areas" group to set the previously defined selection as the print area.
<br> &rarr; The print area is set, the table can now be used in Word (see ''[[Der firesys-Videobereich#Eine Tabelle aus einer Datei einfügen|Insert a table from a file]]'').</li>
<br> 
</ol>
<p align="left"> To assign a line type, proceed as follows: <br>
<ol>
<li> <p align="left"> Select the corresponding row or a cell from this row that you want to assign. </li>
<li> <p align="left"> Click on "Line types" in the "Formatting" group in the "*Design" ribbon.
<br> &rarr; A menu opens with various options. </li>


<li> <p align="left"> Select the line type you want to assign - e.g. "Table header single" for the table header line.
<br> &rarr; The line type is assigned. </li>
<br> 
</ol>
<p align="left"> To assign a column highlight, proceed as follows:
<br>
<ol>
<li> <p align="left"> Highlight the column to be highlighted. </li>
<li> <p align="left"> Klicken Sie im Menüband „*Gestaltung“ in der Gruppe „Formatierung“ auf das Menü „Highlight“ und wählen Sie ein Highlight aus dem Dropdown-Menü aus.
<br> &rarr; Das Highlight wird zugewiesen. </li>
</ol>
</ol>
</p>
</center>  
</center>  
 
</div>
</div></div>
</div>

Aktuelle Version vom 21. September 2023, 11:30 Uhr


Die Erklärung der einzelnen Schritte im Detail

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

  1. To be able to insert a table in Word, it needs an assigned name or print area. To do this, select the complete range of the table in your Excel document.

  2. Click on the "Print Area" button in the "*Design" ribbon in the "Areas" group to set the previously defined selection as the print area.
    → The print area is set, the table can now be used in Word (see Insert a table from a file).


To assign a line type, proceed as follows:

  1. Select the corresponding row or a cell from this row that you want to assign.

  2. Click on "Line types" in the "Formatting" group in the "*Design" ribbon.
    → A menu opens with various options.

  3. Select the line type you want to assign - e.g. "Table header single" for the table header line.
    → The line type is assigned.


To assign a column highlight, proceed as follows:

  1. Highlight the column to be highlighted.

  2. Klicken Sie im Menüband „*Gestaltung“ in der Gruppe „Formatierung“ auf das Menü „Highlight“ und wählen Sie ein Highlight aus dem Dropdown-Menü aus.
    → Das Highlight wird zugewiesen.