Select the Create from File tab, then browse to the workbook you wish to embed.Click the Insert tab the destination Word document, then select Object from the Insert Embedded Object dropdown button.

This Excel object can include multiple sheets, filters and many of Excel’s features. Inserting your workbook as an Excel object embeds a mini-version of Excel itself into the middle of your Word document. Hint! If you frequently use a paste option that is not Keep Source Formatting, you can click the Set Default Paste link and change the default settings in the Cut, copy and paste section of Word Options.Ĭopy/Paste brings Excel tables or Worksheet data into the Word document by changing it to a Word table or text. Data in columns will be separated by a tab, rows will appear as individual paragraphs. Keep Text Only (D) – This will paste the data contained within each cell as individual lines of text in the Word document. The paste will use the original Excel formatting to generate the picture. You will be able to resize and edit the image as you would any other picture, but you will not be able to edit the data. Copy as Picture (C) – This will paste the data range as a Word image object. Use this to make your fonts and colors consistent in the destination without having to edit in Excel beforehand. Use Destination Styles (B) – This will paste the data into Word as a table and adapt the display elements into the same formatting as the Word document. To change the paste option, click the Ctrl dropdown option in the bottom right corner of your new table after pasting and select a new option.As you can see, you may need to clean up your table after the paste to make it look correct in the new document. This preserves any formatting you have done in Excel and pastes the data into Word as a table using that same formatting. The default paste will use the Keep Source Formatting (A) paste option.In the destination Word document, place the cursor where you want the data, then hit CTRL-V.In the source Excel spreadsheet, select the data you want to copy then hit CTRL-C.

The simplest way to display Excel data in a Word document is to use Copy/Paste. Images were taken using Excel 2013 on Windows 7. This feature applies to Excel/Word 2010 and later versions. You will need a blank Word document open. To follow using our example, download ExportWorksheetsToWord.xlsx. REGISTER NOW Find out the Variety of Options to Transfer Data

Word to excel converter download free