Skip to content

How To Blog

  • How to Download YouTube Videos to iPhone How-To
  • How to Create and Use a Password Reset Disk in Windows 10 How-To
  • Fix “Host Process Rundll32 has stopped working” How-To
  • The five best download managers for Chrome and Firefox 2020 How-To
  • 5 Cool Websites to Find Good Movies and TV Shows on Netflix How-To
  • How To Swipe With Friends on Tinder How-To
  • Best small calculator pocket 2020

    Best small calculator pocket 2020

  • How to Remove Silence From mp3 Automatically How-To

Insert an Excel Worksheet into a Word Doc

Posted on October 6, 2020 By blog_786 No Comments on Insert an Excel Worksheet into a Word Doc

Have you ever had to insert an Excel sheet into a Word document and link them so that when the main Excel sheet is refreshed, the values ??in the Word document will automatically update too?

Well, there are actually several ways to insert an Excel spreadsheet into Word: linking, embedding and creating a new one. Regardless of whether you embed or link, the inserted Excel spreadsheet will not update automatically unless you specifically create a link between the two files.

However, once linked, the data in the embedded or linked spreadsheet will be refreshed when changes are detected in the original Excel spreadsheet.

Apart from pasting an existing Excel spreadsheet, you can also insert a new Excel object in Word, which basically launches Excel inside Word itself.

In this article, I’ll show you how to do it using all three methods and explain what you need to do to create a link.

Copy and paste method

Let’s start with the first method, which is a simple copy and paste from Excel to Word. Note that with this method, you have the option to include only a portion of the Excel spreadsheet in the Word document. The second method for inserting an object will place the entire spreadsheet in the Word file.

Step 1. Select the area in the Excel spreadsheet that you want to include in Word, and then press Ctrl + C to copy the content.

Step 2: Now go to your Word document and press Ctrl + V to paste the content into the Word file. To link, you must click the Paste Options button in the lower right corner and select either Match Target Table Style and Link to Excel or Keep Source Formatting and Link to Excel.

In newer versions of Word, you will see several icons. You can hover over them and you will see the same two options as mentioned above.

Insert an Excel Worksheet into a Word Doc

Step 3. That’s it, now your spreadsheet will be linked to the original Excel file. Every time you refresh the Excel file and reopen Word, Word asks you if you want to update the document with new data from the linked files.

Insert an Excel Worksheet into a Word Doc

Step 4: Click Yes and your table will display the new values. If both files are open at the same time, you will see the changes in real time.

Obviously, there is some pretty complex mechanism that makes all this work work, but thankfully you don’t need to worry about it. It just works! Note that if you just copy and paste and do not select one of the linking options, you will simply have a separate Excel object pasted in and will not update when you make changes to the original Excel file.

Also, using this method, you cannot edit Excel data in Word and display it back to Excel spreadsheet. This only works one way. If you make changes to the data in Word and save the file, you get the same message above asking if you want to update the file from linked files when you open the file again.

If you click Yes, it will just reload the latest values ??from the Excel spreadsheet and overwrite any values ??you might have changed. If you want to edit the original Excel spreadsheet, you can do so from Word by right-clicking on the data, choosing Linked Sheet Object, and then clicking Edit Link.

Insert an Excel Worksheet into a Word Doc

This is useful if the Word document was created by someone else and you don’t know where the original Excel file is.

Enter the object method

The second way to link an Excel spreadsheet to Word is by using the Insert menu.

Step 1. In Word, click the Insert tab, click the Object drop-down list, and select Object.

Insert an Excel Worksheet into a Word Doc

Step 2: Click the Create from File tab and click the Browse button to select the file.

Insert an Excel Worksheet into a Word Doc

Step 3: After selecting the file, you will see two checkboxes on the right. If you want to link an Excel spreadsheet, you need to check the “Link to file” checkbox. If you want to insert a spreadsheet so that it is not linked to the original file, leave this check box empty.

Insert an Excel Worksheet into a Word Doc

As mentioned earlier, using the Insert Object method in Word will download the entire contents of the Excel spreadsheet, not just a portion.

Note that if you double-click the Excel object (if linked), it will simply open the original Excel file in Excel itself.

Insert table method

Finally, you can insert a fully editable Excel spreadsheet into Word by going to the Insert tab, clicking Table, and then clicking Excel Table at the bottom.

Insert an Excel Worksheet into a Word Doc

This method is only useful if you want to create a new Excel spreadsheet from scratch and plan to make changes to the spreadsheet from within Word itself. However, what is cool about this method is that it inserts a floating table and loads all Excel menus also inside Word, so that you can insert formulas, etc., as if you were in Excel itself.

Insert an Excel Worksheet into a Word Doc

You can add sheets, create filters, format cells, and do everything just like in regular Excel. It’s a quick and easy way to insert some data into a Word document that can be formatted correctly with Excel, instead of relying on Word tables, which are really hard to make beautiful.

So, these are different ways to transfer an Excel spreadsheet to Word and link or unlink them, depending on your needs. If you have any questions, do not hesitate to comment. Enjoy!

–

MS Office Tips

Post navigation

Previous Post: 3 Ways to Change Bitrate on MP3 Files
Next Post: What Happened to Aero Flip 3D in Windows 8 & 10?

Related Posts

  • How to Master The Slide Master in Microsoft PowerPoint MS Office Tips
  • How to Separate First and Last Names in Excel MS Office Tips
  • Polling in microsoft teams meeting MS Office Tips
  • Use Excel to Figure Out an Effective Interest Rate from a Nominal Interest Rate MS Office Tips
  • The 7 Best Microsoft Word Add-Ins MS Office Tips
  • How to Subtract Dates in Excel MS Office Tips

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Archives

  • May 2023
  • April 2023
  • November 2022
  • September 2022
  • August 2022
  • July 2022
  • June 2022
  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • December 2021
  • November 2021
  • October 2021
  • September 2021
  • August 2021
  • July 2021
  • March 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • March 2020
  • December 2019
  • July 2019
  • May 2019
  • April 2019
  • January 2019
  • December 2018
  • November 2018
  • October 2018
  • September 2018
  • August 2018

Categories

  • Amazon Web Services
  • Apple Watch
  • Computer Tips
  • Cool Websites
  • Free Software Downloads
  • Gadgets
  • Gaming
  • General Software
  • Google Software/Tips
  • Hardware
  • Help Desk
  • How-To
  • iOS
  • iPad
  • iPhone
  • Linux
  • Linux Tips
  • macOS
  • MS Office Tips
  • Networking
  • Office Tips
  • OS X
  • Product Reviews
  • Reviews
  • Safari
  • Smart Home
  • Smartphones
  • Software Reviews
  • technology
  • text
  • Tools Review
  • Troubleshooting
  • Tutorials
  • Uncategorized
  • Urdu Books PDF
  • Web Site Tips
  • Windows
  • Windows 10
  • Windows 7
  • Wordpress

Recent Posts

  • How to transfer Steam game to another drive
  • How to fix google backup and sync not signed
  • Top Best Guitar Apps for Android 2021
  • 5 Best Professional Photo Recovery Software for Android 2021
  • how to crosspost on reddit 2021

Recent Comments

  1. How to Minimize a Windows Program to the System Tray 2023 - How To Blog on How to Fix System Tray or Icons Missing in Windows 10
  2. How can I unlock my Macbook using Apple Watch - How To Blog on How to Install Chrome OS on Macbook or iMac
  3. 4k hdmi switch with optical out - How To Blog on Is A Gaming PC Really More Expensive Than A Console?
  4. online video maker with music and pictures 2023 - How To Blog on 6 Video Editing Tips For Beginners
  5. 5 New Ways to Clean Electronics Safely - How To Blog on How to Clean Your Computer Properly, Inside and Out
  • How to Enable Cookies in Internet Explorer

    How to Enable Cookies in Internet Explorer

  • How to Only See Videos From YouTube Channels You Have Subscribed To How-To
  • How to show hidden files on Mac OS OS X
  • How To Fix Discord Opening Error 11 Tips Computer Tips
  • 4 best WiFi boosters to expand your wireless network Product Reviews
  • Best Retro Gaming Consoles of 2022 Gaming
  • Switching From Android To iPhone – What You Need To Know Tutorials
  • Best ti-34 multiview scientific calculator 2020

    Best ti-34 multiview scientific calculator 2020

Copyright © 2023 How To Blog.

Powered by PressBook News WordPress theme

Go to mobile version