Vorlage:Video-Tabelle aus Datei einfügen-English: Unterschied zwischen den Versionen
(Die Seite wurde neu angelegt: „ 808px|center|border <center><div class="toccolours mw-collapsible mw-collapsed" style="width:800px; ove…“) |
Keine Bearbeitungszusammenfassung |
||
Zeile 9: | Zeile 9: | ||
</p><p align="left"> | </p><p align="left"> | ||
</p><ul> | </p><ul> | ||
So that a table can be inserted, a table must have been formatted properly beforehand. You can find information about this | So that a table can be inserted, a table must have been formatted properly beforehand. You can find information about this [[Tabelle-in-Excel-vorbereiten|here]]</a>.<br><br> | ||
<li> <p align="left">On the “*Content” tab in the “Excel Data” group on the “Insert” menu and select “From file” from the “From file...” area.</p></li> | <li> <p align="left">On the “*Content” tab in the “Excel Data” group on the “Insert” menu and select “From file” from the “From file...” area.</p></li> | ||
<li> <p align="left">The following dialog selection shows the Excel files that are already linked and open. | <li> <p align="left">The following dialog selection shows the Excel files that are already linked and open. |
Version vom 2. Januar 2020, 12:14 Uhr
This is how you insert a table in Excel into Word with firesys:
-
On the “*Content” tab in the “Excel Data” group on the “Insert” menu and select “From file” from the “From file...” area.
-
The following dialog selection shows the Excel files that are already linked and open.
-
Files that are currently open on your desktop are displayed as
-
Files that you have already used to import objects into your Word document are displayed as
-
You can add documents by clicking the “Additional files” button or dragging the files directly to the corresponding button.
-
Select the Excel file from which the data is to be inserted (“Data source”).
-
A selection dialog opens. Select here the worksheet from which you want to insert your data.
-
Then select the range in the worksheet that you want to insert in Word. You can search both lists when they are expanded.
-
You can also select “Format manually” to prevent your tables being automatically adapted and formatted during insertion and updating Confirm the dialog with “OK”.
-
The table is inserted with the saved preset layout.
So that a table can be inserted, a table must have been formatted properly beforehand. You can find information about this here</a>.