Insert a table from a file: Unterschied zwischen den Versionen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
(3 dazwischenliegende Versionen von einem anderen Benutzer werden nicht angezeigt) | |||
Zeile 1: | Zeile 1: | ||
Use this function to insert a table from an Excel file as a linked firesys table object in Word as follows. | Use this function to insert a table from an Excel file as a linked firesys table object in Word as follows. | ||
{{Vorlage:Video-Tabelle aus Datei einfügen}} | {{Vorlage:Video-Tabelle aus Datei einfügen-English}} | ||
== See also == | == See also == | ||
[[Datei:Navigation_hoch.svg|link=]] [[ | [[Datei:Navigation_hoch.svg|link=]] [[Insert_Excel_contents| An overview of inserting Excel contents]] <br> | ||
[[Datei:Navigation_rechts.svg|link=]] [[ | [[Datei:Navigation_rechts.svg|link=]] [[Insert_table_directly_from_the_selected_Excel_range|Insert a table directly from the selected Excel range]] <br> | ||
[[Datei:Navigation_rechts.svg|link=]] [[ | [[Datei:Navigation_rechts.svg|link=]] [[Insert_data_in_text_from_file|Insert data in text from a file]] <br> | ||
[[Datei:Navigation_rechts.svg|link=]] [[ | [[Datei:Navigation_rechts.svg|link=]] [[Insert_data_in_text_directly_from_the_selected_Excel_cell|Insert data in text directly from the selected Excel cell]] <br> | ||
[[Datei:Navigation_rechts.svg|link=]] [[ | [[Datei:Navigation_rechts.svg|link=]] [[Insert_data_in_text_directly_from_the_selected_Excel_cell_with_options|Insert data in text directly from the selected Excel cell with options]] <br> | ||
{{MoreContent}} | {{MoreContent}} | ||
[[Kategorie:English-Word Excelinhalte-Excel-Daten-einfügen]] | [[Kategorie:English-Word Excelinhalte-Excel-Daten-einfügen]] |
Aktuelle Version vom 7. August 2020, 13:59 Uhr
Use this function to insert a table from an Excel file as a linked firesys table object in Word as follows.
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.
See also
An overview of inserting Excel contents
Insert a table directly from the selected Excel range
Insert data in text from a file
Insert data in text directly from the selected Excel cell
Insert data in text directly from the selected Excel cell with options