Jan 02, · Here's how to embed an Excel worksheet using the simple paste option: Open the Microsoft Excel worksheet, then highlight the data you want to include in the Word document. Copy the data. Press Ctrl+C (on a Mac, press Command+C). Or, right-click the selected data and select Copy. Open the Word. To fit the large table content to the page in Word document when pasting from Excel worksheet, the AutoFit feature of Word can help you, please do as this: 1. Copy and paste the large range of data into Word document, and then select the pasted table, then click Layout > AutoFit > AutoFit Contents / AutoFit Window, see screenshot: 2. And then the large data table will be adjusted to fit to the .
This article explains how to insert an Excel spreadsheet into a Word document. Instructions apply to Microsoft Word and Excel, and as well what does a joule equal Microsoft Here's how to embed an Excel worksheet using the simple paste option:.
Open the Microsoft Excel worksheet, then highlight the data you want to include in the Word document. Copy the data. Or, right-click the selected data and select Copy. Open the Word document and place the cursor where you pasye the worksheet data to appear. Or, go to the Home tab and, in the Clipboard group, select Paste. The data appears in the Word document. Here's how to embed using the Paste Special option:.
Go to the Home tab doucment, in the Clipboard group, select the Paste drop-down arrow, then choose Paste Special. In the Paste Special dialog box, select Paste. Select Microsoft Excel Worksheet Object. Select OK. The Excel data appears in the Word document. The steps to link a worksheet to a Word document are similar to the steps to embed the data.
Go to the Home tab, select the Paste drop-down arrow, then choose Paste Special. In the Paste Special dialog box, select Paste link. Choose How to eat with a lip piercing Excel Worksheet Object. Keep these dpcument in mind after you've linked the data:.
When you link an Excel worksheet to a Word document, every time the worksheet is updated, the changes are reflected in the document. All editing takes place in the worksheet and not in the document. Use this option if you plan to make changes to the worksheet, especially if these changes involve complex calculations.
An embedded worksheet is a flat file. Once it's part of a Word document, it behaves like a piece of that document and can be edited in Word.
There is no connection between the original worksheet and the Word document it's now a part of. Use this option if you plan to make minimal changes to the table data or if the data involves simple calculations. When you embed an Excel worksheet into a Word document, you dcoument either how to seal your record in illinois and paste from Excel to Word or embed using the Paste Special feature.
The copy-and-paste method is faster but some formatting may change and some table functionality may be lost. The Paste Special feature provides more options for how the data will appear. Actively scan device characteristics for identification. Use precise geolocation data. Select personalised content. Create a personalised content profile. Measure ad performance. Select basic ads. Create a personalised ads profile. Select personalised ads.
Apply market research to generate audience insights. Measure sueet performance. Develop and improve products. List of Partners vendors. Rebecca Johnson. Freelance Contributor. Updated on January 02, Ryan Perian. Lifewire Tech Review Board Member. Article reviewed on Oct 06, Tweet Share Email. What to Know When you insert Excel data into Wordyou can either link the Excel worksheet to the document or embed it.
Don't choose the Paste drop-down arrow. Was this page helpful? Thanks for letting us know! Email Address Sign up There was an error. Please try again. You're in! Thanks for signing up. There was an error.
Tell us why! More from Lifewire. How to Copy and Paste on a Chromebook. Your Privacy Rights. To change or withdraw your consent choices for Lifewire. At any time, you can update your settings through the "EU Privacy" link at the bottom of any page. These choices will be signaled globally to our partners and will docujent affect browsing data.
We and our partners process data to: Actively scan device characteristics for identification. I Accept Show Purposes.
Learn how to link Excel to Word and keep the document always updated
Dec 30, · To insert an Excel worksheet as a table in Word: Open a Word document. Place the cursor where you want to insert the Excel worksheet. Go to the Insert tab, then select Table. Jul 18, · Start by opening both the Excel worksheet and the Word document you want to edit at the same time. In Excel, select the cells you want to link or embed. If you would like to link or embed the entire worksheet, click on the box at the juncture of the rows and columns in the top left-hand corner to select the whole sheet. Oct 01, · In Word use Edit> Paste Special as either Picture or PDF (whichever gives the best result). Apply some form of Text Wrap to the picture so it can be rotated & positioned as needed. Use Section Breaks to isolate the page so you can change its orientation to Landscape. The chart doesn't have to be pasted as a picture, but there could be other considerations -- such as placement of .
While this works, there are a number of limitations. One of the most important is that if the original data file ever changes, your Word document will never reflect those changes. If either of those issues matter to you, there are better ways to insert an Excel worksheet into a Word doc.
Also, be sure to check out our YouTube video where we show you the same steps as in the article. The imported Excel cells become a Microsoft Word table.
The second issue is that it only works well for smaller tables of data. This will insert the copied cells into your Word document. If you do want to edit the data, just double-click on the object and it will open the entire original spreadsheet inside Microsoft Excel. Keep in mind this is an entirely new Excel file not the original.
But any edits you make and save in that Excel file will update in your Word document. What is nice about this approach is that none of the original formatting gets changed during the conversion to a Microsoft Word table. The best way to insert an Excel worksheet into a Word doc is by pasting it as a linked embedded object. The procedure to do this is identical to the one above, except in the Paste Special window you want to make sure to select the Paste Link checkbox.
This essentially lets you create a live view from Word into changes someone is actively making in any Excel file. If you wanted to, you could use this feature to create a realtime dashboard in Word to display any important data points that someone may change in an Excel file.
As you can see, there are multiple ways to insert an Excel worksheet into a Word doc. The option you choose really only depends on how you intend to use that data and whether you want to see or use data changes in the original Excel file. How have you imported Excel data into Word before? Have you had any issues when you tried to do so? Share your experience in the comments section below.
Ryan has been writing how-to and other technology-based articles online since Read Ryan's Full Bio. Subscribe to Help Desk Geek and get great guides, tips and tricks on a daily basis! We only send useful stuff! We hate spam too, unsubscribe at any time. Want to impress your friends and family with awesome tech geekery? Do not share my Personal Information.