Contains paid promotion

Advertisement

So you can use your Excel spreadsheets
paste 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.

Excel in Word einfügen

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

Advertisement
SanDisk Ultra 64GB (SDSQUAR-064G-GN6MA) microSDXC Speicherkarte + Adapter bis zu 100 MB/Sek, Class 10, U1, A1,Grau, Rot
SanDisk Ultra 64GB (SDSQUAR-064G-GN6MA) microSDXC ...*
by SanDisk

Kapazität: 64 GB, Flash Card Typ: MicroSDXC, Flash-Memory-K...

List Price: € 30.99 You Save: € 11.99 (39%) Prime Price: € 19.00 zum Angebot*
Price incl. VAT., Excl. Shipping
*Zuletzt aktualisiert am 17. August 2018 um 12:52 . Preise können sich geändert haben. Alle Angaben ohne Gewähr.

So you can use your Excel spreadsheets paste 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.

Excel in Word einfügen

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

Advertisement
SanDisk Ultra 64GB (SDSQUAR-064G-GN6MA) microSDXC Speicherkarte + Adapter bis zu 100 MB/Sek, Class 10, U1, A1,Grau, Rot
SanDisk Ultra 64GB (SDSQUAR-064G-GN6MA) microSDXC ...*
by SanDisk

Kapazität: 64 GB, Flash Card Typ: MicroSDXC, Flash-Memory-K...

List Price: € 30.99 You Save: € 11.99 (39%) Prime Price: € 19.00 zum Angebot*
Price incl. VAT., Excl. Shipping
*Zuletzt aktualisiert am 17. August 2018 um 12:52 . Preise können sich geändert haben. Alle Angaben ohne Gewähr.

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 position 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)

Position cursor in Word
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 position 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:

Position cursor in Word
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:

  • Registerkarte “Insert tab”
  • In the ribbon “Text” on “Object” Sub-item again “Object
  • In the window that opens, click on “Create from file
  • With the item “Browse” the desired Excel spreadsheet on your drive
    select by double-click

See picture (click to enlarge)

Select file to insert
Advertisement

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

  • Registerkarte “Insert tab”
  • In the ribbon “Text” on “Object” Sub-item again “Object
  • In the window that opens, click on “Create from file
  • With the item “Browse” the desired Excel spreadsheet on your drive
    select by double-click

See picture:

Select file to insert
Advertisement

3. Edit Excel spreadsheet in Word.

3. Edit Excel spreadsheet in Word.

After we have inserted our table in the Word document, this will cause the text components in the Word document to get tangled up, depending on their size.

Why is it better to place the table 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.

Advertisement

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

See picture (click to enlarge)

Adjust Excel table size
Edit Excel spreadsheet in Word

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

After we have inserted our table in the Word document, this will cause the text components in the Word document to get tangled up, depending on their size.

Why is it better to place the table 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.

Advertisement

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

See picture:

Adjust Excel table size
Edit Excel spreadsheet in Word

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 possibility to insert 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 to resize it, and edit it under the workspace of Excel.

As soon as you leave the table area, for example, in your Word document to continue working, the inserted table is displayed as a picture.

See picture (click to enlarge)

Insert new Excel spreadsheet in Word
Advertisement
#1
SanDisk Ultra 64GB USB-Flash-Laufwerk USB 3.0 bis zu 100MB/Sek
SanDisk Ultra 64GB USB-Flash-Laufwerk USB 3.0 bis ...*
by SanDisk

USB 3.0 DRIVE, SANDISK,ULTRA CRUZER,64GB--- Memory Capacity ...

List Price: € 26.99 You Save: € 11.00 (41%) Prime Price: € 15.99 zum Angebot*
Price incl. VAT., Excl. Shipping
*Zuletzt aktualisiert am 17. August 2018 um 12:52 . Preise können sich geändert haben. Alle Angaben ohne Gewähr.

Of course you also have the possibility to insert 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 to resize it, and edit it under the workspace of Excel.

As soon as you leave the table area, for example, in your Word document to continue working, the inserted table is displayed as a picture.

See picture:

Insert new Excel spreadsheet in Word
Advertisement
#1
SanDisk Ultra 64GB USB-Flash-Laufwerk USB 3.0 bis zu 100MB/Sek
SanDisk Ultra 64GB USB-Flash-Laufwerk USB 3.0 bis ...*
by SanDisk

USB 3.0 DRIVE, SANDISK,ULTRA CRUZER,64GB--- Memory Capacity ...

List Price: € 26.99 You Save: € 11.00 (41%) Prime Price: € 15.99 zum Angebot*
Price incl. VAT., Excl. Shipping
*Zuletzt aktualisiert am 17. August 2018 um 12:52 . Preise können sich geändert haben. 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 therefore 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)

Link PowerPoint to Word
Advertisement
Print Friendly, PDF & Email

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 therefore 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:

Link PowerPoint to Word
Advertisement
Print Friendly, PDF & Email
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

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:

Advertisement
#1
APEMAN 4K Action Cam 20MP WIFI Wasserdichte Unterwasser Action Kamera 40M Digitale Videokamera mit 170 ° Weitwinkelobjektiv Eis Sony Sensor, Zwei verbesserten Batterien, Transportskoffer und 24 Multiples
APEMAN 4K Action Cam 20MP WIFI Wasserdichte Unterw...*
by Apeman

Das ist unser Leben,verpasse nie wieder einen wunderbaren Mo...

List Price: € 109.99 You Save: € 20.00 (18%) Prime Price: € 89.99 zum Angebot*
Price incl. VAT., Excl. Shipping
*Zuletzt aktualisiert am 17. August 2018 um 15:32 . Preise können sich geändert haben. Alle Angaben ohne Gewähr.

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:

Advertisement
#1
APEMAN 4K Action Cam 20MP WIFI Wasserdichte Unterwasser Action Kamera 40M Digitale Videokamera mit 170 ° Weitwinkelobjektiv Eis Sony Sensor, Zwei verbesserten Batterien, Transportskoffer und 24 Multiples
APEMAN 4K Action Cam 20MP WIFI Wasserdichte Unterw...*
by Apeman

Das ist unser Leben,verpasse nie wieder einen wunderbaren Mo...

List Price: € 109.99 You Save: € 20.00 (18%) Prime Price: € 89.99 zum Angebot*
Price incl. VAT., Excl. Shipping
*Zuletzt aktualisiert am 17. August 2018 um 15:32 . Preise können sich geändert haben. Alle Angaben ohne Gewähr.
2018-08-09T13:50:32+00:00By |Categories: Excel 2016, Word 2016|
In order to optimize our website for you and to be able to continuously improve it, we use cookies. By continuing to use the website, you agree to the use of cookies. Ok