Insert Excel spreadsheets into Word Documents
Insert Excel spreadsheets into Word Documents
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
Popular Posts:
Stop procrastinating: How distraction blockers can help you regain focus
Constant digital distractions kill your productivity. Distraction blockers like Forest or Freedom help you regain focus. They specifically block distractions on your PC and mobile phone and use techniques like the Pomodoro Technique. This helps you stop procrastinating.
Wer ist wo? Microsoft Teams schafft Klarheit im Hybrid-Büro
Die neue Arbeitsstandort-Funktion in Microsoft Teams zeigt, wer im Büro oder remote arbeitet. Verbessern Sie Ihre Meeting-Planung in Outlook und die Team-Koordination. Wir erklären die Vorteile, die Admin-Steuerung und die tiefe Anbindung an Microsoft Viva.
Excel Tutorial: How to quickly and safely remove duplicates
Duplicate entries in your Excel lists? This distorts your data. Our tutorial shows you, using a practical example, how to clean up your data in seconds with the "Remove Duplicates" function – whether you want to delete identical rows or just values in a column.
Dynamic ranges in Excel: OFFSET function
The OFFSET function in Excel creates a flexible reference. Instead of fixing =SUM(B5:B7), the function finds the range itself, e.g., for the "last 3 months". Ideal for dynamic charts or dashboards that grow automatically.
Mastering the INDIRECT function in Excel
The INDIRECT function in Excel converts text into a real reference. Instead of manually typing =January!E10, use =INDIRECT(A2 & "!E10"), where A2 contains 'January'. This allows you to easily create dynamic summaries for multiple worksheets.
From assistant to agent: Microsoft’s Copilot
Copilot is growing up: Microsoft's AI is no longer an assistant, but a proactive agent. With "Vision," it sees your Windows desktop; in M365, it analyzes data as a "Researcher"; and in GitHub, it autonomously corrects code. The biggest update yet.
Offers 2024: Word & Excel Templates
Popular Posts:
Stop procrastinating: How distraction blockers can help you regain focus
Constant digital distractions kill your productivity. Distraction blockers like Forest or Freedom help you regain focus. They specifically block distractions on your PC and mobile phone and use techniques like the Pomodoro Technique. This helps you stop procrastinating.
Wer ist wo? Microsoft Teams schafft Klarheit im Hybrid-Büro
Die neue Arbeitsstandort-Funktion in Microsoft Teams zeigt, wer im Büro oder remote arbeitet. Verbessern Sie Ihre Meeting-Planung in Outlook und die Team-Koordination. Wir erklären die Vorteile, die Admin-Steuerung und die tiefe Anbindung an Microsoft Viva.
Excel Tutorial: How to quickly and safely remove duplicates
Duplicate entries in your Excel lists? This distorts your data. Our tutorial shows you, using a practical example, how to clean up your data in seconds with the "Remove Duplicates" function – whether you want to delete identical rows or just values in a column.
Dynamic ranges in Excel: OFFSET function
The OFFSET function in Excel creates a flexible reference. Instead of fixing =SUM(B5:B7), the function finds the range itself, e.g., for the "last 3 months". Ideal for dynamic charts or dashboards that grow automatically.
Mastering the INDIRECT function in Excel
The INDIRECT function in Excel converts text into a real reference. Instead of manually typing =January!E10, use =INDIRECT(A2 & "!E10"), where A2 contains 'January'. This allows you to easily create dynamic summaries for multiple worksheets.
From assistant to agent: Microsoft’s Copilot
Copilot is growing up: Microsoft's AI is no longer an assistant, but a proactive agent. With "Vision," it sees your Windows desktop; in M365, it analyzes data as a "Researcher"; and in GitHub, it autonomously corrects code. The biggest update yet.
Offers 2024: Word & Excel Templates
