The size of the embedded object might not fit correctly to your Word doc’s margins. This will insert the copied cells into your Word doc. Under the Home tab, click on the dropdown of the Paste button (in the Clipboard group).Place your cursor where you want to insert the Excel table.To embed an Excel file into a Word file, follow the steps below: This means that you can open the embedded Excel file from Word itself and make changes in it. Moreover, you get to alter the embedded object using the original program.
This is made possible by the Windows OLE technology (Object Linking and Embedding).Įmbedding the object, rather than just pasting it, ensures that the object retains its original format. Inserting an Excel File into Word as an Embedded ObjectĪn alternative way to insert an Excel file into Word is by inserting it as an embedded object.Īn embedded object is an object that is created with one application and then embedded into a document that is created by another application.įor example when you embed an object or file created in Excel into a document created in Microsoft Word. If you want to take advantage of Excel formulas inside Word, then the next two methods might work better for you. So you cannot use Excel formulas in the table once it is pasted to Word
This method, though easy, does not offer much in terms of flexibility. Moreover, any changes you make to the original Excel file will not automatically get reflected in your pasted table, unless you paste it again. However, the changes you make to the pasted table do not get reflected in the original Excel file. You can press the tab key to navigate through the table, you can edit the contents, you can delete rows and columns, or insert new rows and columns. This works the same way as a regular Word table. Once you’ve pasted the data into Word, you get a table with the data that you copied. Place your cursor where you want to insert the Excel table.Open the Word file where you want to insert this data.Press CTRL+C to copy (or right-click on the selection and then click on Copy).
Select the part of the Excel file that you want to insert into your Word file.The method simply involves the following steps: In fact, you have probably already used this technique plenty of times. It’s just like copy-pasting data from one sheet in Excel into another. This first copy-paste method is the easiest. Inserting an Excel File into Word by Simple Copy-Pasting Inserting an Excel File into Word as a Linked Object.Inserting an Excel File into Word as an Embedded Object.