Der Blog für digitale Kompetenz

Der Blog für digitale Kompetenz

Insert Excel spreadsheets into Word Documents

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 spreadsheets into Word Documents

Topic Overview

Anzeige

Insert Excel spreadsheets into Word Documents

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 spreadsheets into Word Documents

Topic Overview

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
Advertisement

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

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
Advertisement

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

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
cshow
Ads

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
cshow
Ads

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.

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.

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
Kauf auch du bei der Nummer 1!
Anzeige
cshow
Anzeige

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
Kauf auch du bei der Nummer 1!
Anzeige
cshow
Anzeige

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
Blogverzeichnis Bloggerei.de
cshow
Ads

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
cshow
Ads
Blogverzeichnis Bloggerei.de

Search for:

About the Author:

Michael W. SuhrDipl. Betriebswirt | Webdesign- und Beratung | Office Training
After 20 years in logistics, I turned my hobby, which has accompanied me since the mid-1980s, into a profession, and have been working as a freelancer in web design, web consulting and Microsoft Office since the beginning of 2015. On the side, I write articles for more digital competence in my blog as far as time allows.

Search by category:

Search for:

About the Author:

Michael W. SuhrDipl. Betriebswirt | Webdesign- und Beratung | Office Training
After 20 years in logistics, I turned my hobby, which has accompanied me since the mid-1980s, into a profession, and have been working as a freelancer in web design, web consulting and Microsoft Office since the beginning of 2015. On the side, I write articles for more digital competence in my blog as far as time allows.

Search by category:

Popular Posts:

102, 2024

Integrate and use ChatGPT in Excel – is that possible?

February 1st, 2024|Categories: Artificial intelligence, ChatGPT, Microsoft Excel, Microsoft Office, Shorts & Tutorials|Tags: , , , |

ChatGPT is more than just a simple chatbot. Learn how it can revolutionize how you work with Excel by translating formulas, creating VBA macros, and even promising future integration with Office.

2008, 2023

Internet Addiction – A serious look at a growing problem

August 20th, 2023|Categories: Google, Homeoffice, Shorts & Tutorials|Tags: , , |

Internet addiction is just as serious an illness as alcohol or drug addiction. Just that this is a mental illness. In this article we want to go into the phenomenon in more detail and provide assistance.

607, 2023

Main keyboard shortcuts in Windows 10/11

July 6th, 2023|Categories: Homeoffice, Microsoft Office, Shorts & Tutorials, Windows 10/11/12|Tags: |

Entdecken Sie die wichtigsten Shortcuts in Windows 11, um Ihre Produktivität zu steigern. Von allgemeinen Befehlen bis hin zu spezifischen Fenster-Management- und System-Shortcuts, lernen Sie, wie Sie mit diesen Tastenkombinationen effizienter arbeiten können.

107, 2023

Encrypt USB stick – These options are available

July 1st, 2023|Categories: Shorts & Tutorials, Data Protection, Hardware, Homeoffice, Mac OS, Windows 10/11/12|Tags: , , |

Protecting sensitive data is essential. Encrypting USB sticks provides an extra layer of security. Whether it's built-in software, operating system features, third-party software, or hardware encryption, there are numerous options.

Offers 2024: Word & Excel Templates

Special Offers 2024: Word Design CV-Templates

Monthly Technique Bestsellers:

Bestseller 2022-2023 WLAN-Heizkoerperthermostate

SmartHome | Energy & Security

SmartHome | Energy & Security

Bestseller 2022-2023 WLAN-Heizkoerperthermostate
Bestseller 2022-2023 Notebooks

PC & Accessoires

PC & Accessoires

Bestseller 2022-2023 Notebooks
Bestseller 2022-2023 Smartphones

Smartphone & Accessoires

Smartphone & Accessoires

Bestseller 2022-2023 Smartphones

Popular Posts:

102, 2024

Integrate and use ChatGPT in Excel – is that possible?

February 1st, 2024|Categories: Artificial intelligence, ChatGPT, Microsoft Excel, Microsoft Office, Shorts & Tutorials|Tags: , , , |

ChatGPT is more than just a simple chatbot. Learn how it can revolutionize how you work with Excel by translating formulas, creating VBA macros, and even promising future integration with Office.

2008, 2023

Internet Addiction – A serious look at a growing problem

August 20th, 2023|Categories: Google, Homeoffice, Shorts & Tutorials|Tags: , , |

Internet addiction is just as serious an illness as alcohol or drug addiction. Just that this is a mental illness. In this article we want to go into the phenomenon in more detail and provide assistance.

607, 2023

Main keyboard shortcuts in Windows 10/11

July 6th, 2023|Categories: Homeoffice, Microsoft Office, Shorts & Tutorials, Windows 10/11/12|Tags: |

Entdecken Sie die wichtigsten Shortcuts in Windows 11, um Ihre Produktivität zu steigern. Von allgemeinen Befehlen bis hin zu spezifischen Fenster-Management- und System-Shortcuts, lernen Sie, wie Sie mit diesen Tastenkombinationen effizienter arbeiten können.

107, 2023

Encrypt USB stick – These options are available

July 1st, 2023|Categories: Shorts & Tutorials, Data Protection, Hardware, Homeoffice, Mac OS, Windows 10/11/12|Tags: , , |

Protecting sensitive data is essential. Encrypting USB sticks provides an extra layer of security. Whether it's built-in software, operating system features, third-party software, or hardware encryption, there are numerous options.

Offers 2024: Word & Excel Templates

Special Offers 2024: Word Design CV-Templates

Monthly Technique Bestsellers:

Bestseller 2022-2023 WLAN-Heizkoerperthermostate

SmartHome | Energy & Security

SmartHome | Energy & Security

Bestseller 2022-2023 WLAN-Heizkoerperthermostate
Bestseller 2022-2023 Notebooks

PC & Accessoires

PC & Accessoires

Bestseller 2022-2023 Notebooks
Bestseller 2022-2023 Smartphones

Smartphone & Accessoires

Smartphone & Accessoires

Bestseller 2022-2023 Smartphones
Ads

Popular Posts:

Search by category:

Autumn Specials:

Anzeige
Go to Top