Contains paid Promotion

Advertisement
Advertisement

Insert Excel spreadsheets in Word

Of course, having the ability to create simple tables in a Word document is not new to you.

However, there is also the option to insert both new and existing Excel spreadsheets in Word for further editing as well as linking.

Read in our article how to easily connect Excel to Word.

Insert Excel in Word
Anzeige
Anzeige

Insert Excel spreadsheets in Word

Of course, having the ability to create simple tables in a Word document is not new to you.

However, there is also the option to insert both new and existing Excel spreadsheets in Word for further editing as well as linking.

Read in our article how to easily connect Excel to Word.

Insert Excel in Word
Anzeige
Anzeige

1. Insert existing table in Word

1. Insert existing table in Word

In order to insert a spreadsheet already existing as an Excel file into a Word document, we must first determine at which point in your Word document the Excel spreadsheet should be inserted.

To do this, place the cursor in the desired position in the document:

See picture (click to enlarge)

Cursor in Word positionieren
Santander BestCredit Ratenkredit 300x250
Anzeige

Note:
Please keep in mind that the text underneath the insertion point may be wrapped on other pages.

Anzeige

In order to insert a spreadsheet already existing as an Excel file into a Word document, we must first determine at which point in your Word document the Excel spreadsheet should be inserted.

To do this, place the cursor in the desired position in the document:

See picture (click to enlarge)

Cursor in Word positionieren
Santander BestCredit Ratenkredit 300x250
Anzeige

Note:
Please keep in mind that the text underneath the insertion point may be wrapped on other pages.

Anzeige

2. Select Excel table to insert

2. Select Excel table to insert

Next, we’ll do the following in your Word document:

  • Insert tab
  • In the ribbon “Text” on “Object” Sub-item again “Object”
  • In the then opening window on “Create from file”
  • With the “Browse” option, select the desired Excel table on your drive by double-clicking

See picture (click to enlarge)

Datei-zum-einfügen-auswählen
300x250_eurowingsclassic
Anzeige

Next, we’ll do the following in your Word document:

  • Insert tab
  • In the ribbon “Text” on “Object” Sub-item again “Object”
  • In the then opening window on “Create from file”
  • With the “Browse” option, select the desired Excel table on your drive by double-clicking

See picture (click to enlarge)

Datei-zum-einfügen-auswählen
300x250_eurowingsclassic
Anzeige

3. Edit Excel spreadsheet in Word

3. Edit Excel spreadsheet in Word

After inserting our spreadsheet into the Word document, depending on the size of the Word document, it will seriously mess up the text components in the Word document.

Why is it better to place the spreadsheet on a separate page in your document and adjust it according to your orientation (portrait or landscape orientation)?

Because we want to show the table so completely, because a user later should not switch to edit mode to display all content.

The inserted table is initially displayed as an embedded image, which we can resize by dragging the corners.

Santander BestCredit Ratenkredit 728x90
Anzeige

To edit, simply right-click on the inserted Excel table in the context menu and select “Worksheet Object” and “Edit”.

See picture (click to enlarge)

Excel Tabelle Größe anpassen
Excel Tabelle in Word bearbeiten

In edit mode we now have the complete working interface of Excel in our Word document.

After inserting our spreadsheet into the Word document, depending on the size of the Word document, it will seriously mess up the text components in the Word document.

Why is it better to place the spreadsheet on a separate page in your document and adjust it according to your orientation (portrait or landscape orientation)?

Because we want to show the table so completely, because a user later should not switch to edit mode to display all content.

The inserted table is initially displayed as an embedded image, which we can resize by dragging the corners.

Santander BestCredit Ratenkredit 728x90
Anzeige

To edit, simply right-click on the inserted Excel table in the context menu and select “Worksheet Object” and “Edit”.

See picture (click to enlarge)

Excel Tabelle Größe anpassen
Excel Tabelle in Word bearbeiten

In edit mode we now have the complete working interface of Excel in our Word document.

4. Insert new Excel spreadsheet in Word

4. Insert new Excel spreadsheet in Word

Of course, you also have the option of inserting a completely new Excel spreadsheet into your Word document.

To do this, simply go to the tab under Word:

  • “Start” on “Paste”
  • And then on “Excel spreadsheet”
  • Again, we can resize the table as you like, and edit it under the Excel desktop.

As soon as you leave the table area, for example, In your Word document, the inserted spreadsheet will look like a picture.

See picture (click to enlarge)

Neue Excel Tabelle in Word einfügen
Anzeige
Fire TV Stick 4K mit Alexa-Sprachfernbedienung + Echo Dot (3. Generation)
Fire TV Stick 4K mit Alexa-Sprachfernbedienung + Echo D...*
von Amazon
  • Dieses Bundle enthält einen Fire TV Stick 4K und ein neues Echo Dot. Verbinden Sie diese, um Ihr Fire TV hands-free mithilfe von Alexa zu steuern - sagen Sie einfach "Alexa, spiel Tom Clancy's Jack Ryan."
  • Fire TV Stick 4K ist der stärkste Streaming-Media-Stick mit einem neuen Wi-Fi-Antennen-Design, das für 4K-Ultra-HD-Streaming optimiert wurde. Genießen Sie ein brillantes Bild und immersiven Klang mit Zugang zu 4K Ultra HD, Dolby Vision, HDR und Dolby Atmos.
Unverb. Preisempf.: € 119,98 Du sparst: € 25,00 (21%) Prime Preis: € 94,98 zum Angebot*
Preis inkl. MwSt., zzgl. Versandkosten
*Preise zuletzt aktualisiert am 15. February 2019 um 15:37 . Alle Angaben ohne Gewähr.

Of course, you also have the option of inserting a completely new Excel spreadsheet into your Word document.

To do this, simply go to the tab under Word:

  • “Start” on “Paste”
  • And then on “Excel spreadsheet”
  • Again, we can resize the table as you like, and edit it under the Excel desktop.

As soon as you leave the table area, for example, In your Word document, the inserted spreadsheet will look like a picture.

See picture (click to enlarge)

Neue Excel Tabelle in Word einfügen
Anzeige
Fire TV Stick 4K mit Alexa-Sprachfernbedienung + Echo Dot (3. Generation)
Fire TV Stick 4K mit Alexa-Sprachfernbedienung + Echo D...*
von Amazon
  • Dieses Bundle enthält einen Fire TV Stick 4K und ein neues Echo Dot. Verbinden Sie diese, um Ihr Fire TV hands-free mithilfe von Alexa zu steuern - sagen Sie einfach "Alexa, spiel Tom Clancy's Jack Ryan."
  • Fire TV Stick 4K ist der stärkste Streaming-Media-Stick mit einem neuen Wi-Fi-Antennen-Design, das für 4K-Ultra-HD-Streaming optimiert wurde. Genießen Sie ein brillantes Bild und immersiven Klang mit Zugang zu 4K Ultra HD, Dolby Vision, HDR und Dolby Atmos.
Unverb. Preisempf.: € 119,98 Du sparst: € 25,00 (21%) Prime Preis: € 94,98 zum Angebot*
Preis inkl. MwSt., zzgl. Versandkosten
*Preise zuletzt aktualisiert am 15. February 2019 um 15:37 . Alle Angaben ohne Gewähr.

5. Link Excel table to Word

5. Link Excel table to Word

In the previous steps, we have an Excel spreadsheet embedded in a Word document.

But if changes are made to the source file, they will not affect the inserted table yet.

The Excel spreadsheet in our Word document is thus static.

This can of course make sense for a snapshot.

To link the table dynamically with the changes in the source file, just activate the “Link” checkbox when inserting the file.

See picture (click to enlarge)

PowerPoint-mit-Word-verknüpfen
Anzeige

In the previous steps, we have an Excel spreadsheet embedded in a Word document.

But if changes are made to the source file, they will not affect the inserted table yet.

The Excel spreadsheet in our Word document is thus static.

This can of course make sense for a snapshot.

To link the table dynamically with the changes in the source file, just activate the “Link” checkbox when inserting the file.

See picture (click to enlarge)

PowerPoint-mit-Word-verknüpfen
Anzeige
Become Guest Writer

We publish your guest contribution free of charge in German and English
incl. backlink to your website and identification of the author

Santander BestCredit Ratenkredit 728x90
Anzeige
Blogverzeichnis Bloggerei.de

About the author:

Michael Suhr
Michael SuhrWebdesigner / Economist
After 20 years in logistics management, I have been working as a freelance web designer and office trainer since the beginning of 2015. Incidentally, I give tips and tricks for more digital skills in my blog as time permits.

Search by category:

Anzeige

About the author:

Michael Suhr
Michael SuhrWebdesigner / Economist
After 20 years in logistics management, I have been working as a freelance web designer and office trainer since the beginning of 2015. Incidentally, I give tips and tricks for more digital skills in my blog as time permits.

Search by category:

Anzeige