Vorlage:Video-Tabelle formatieren-English: Unterschied zwischen den Versionen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
| (Eine dazwischenliegende Version von einem anderen Benutzer wird nicht angezeigt) | |||
| 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;"> | <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> | ||
<div class="mw-collapsible-content"> | |||
<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> → 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> → 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. | ||
</p> | <br> → 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> → Das Highlight wird zugewiesen. </li> | |||
</ol> | |||
</center> | </center> | ||
</div> | |||
</div></div> | </div> | ||
Aktuelle Version vom 21. September 2023, 11:30 Uhr
This is how you can assign ranges to a table in Excel:
-
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.
-
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:
-
Select the corresponding row or a cell from this row that you want to assign.
-
Click on "Line types" in the "Formatting" group in the "*Design" ribbon.
→ A menu opens with various options. -
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:
-
Highlight the column to be highlighted.
-
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.