Learning to output from Excel to Word (in simple language)

Excel is efficient as long as it organizes numbers or data. However, when you want to convey ideas beyond a table or chart to others, you will definitely get Word or PowerPoint.

 In the following examples, we want to take a look at several different ways you can send or combine spreadsheets in your Word documents.

To follow this tutorial, download the ExportWorksheetsToWord.xlsx file here . Open a blank Word document. This feature is available in Excel / Word 2010 and later. Images were taken using Excel 2013 in Windows 7.

Solution One: Copy / Paste

The easiest way to display Excel data in a Word document is to use Copy / Paste .

1. Open the destination Word document.

2. In the Excel spreadsheet, select the data you want to copy and then click the CTRL and C buttons .

3. Target Word document, place the cursor where you want the data to be let and then hit CTRL and V button.

C: \ Users \ Mr \ Desktop \ ExportWorksheetsToWord01.png

4- Default pasting uses the option ( Keep Source Formatting (A). This preserves the formatting that you did in Excel and pastes the data using the same formatting in Word. As you can see, You may need to clean your table after pasting to make it look right in the new document.

5- To change the paste option, after paste, click on the Ctrl dropdown option in the lower right corner of your new table and select a new option. Other pasting options include:

Use Styles Styles (B) – Sets data into a table in Word and matches display elements with the same Word formatting. Use this method to keep the fonts and colors you set in Excel fixed without having to edit at the destination.

C: \ Users \ Mr \ Desktop \ ExportWorksheetsToWord02.png

(Copy as Picture (C  – This area data as an image in Word stuck and you’ll be able to picture it like any other photo resize and edit, but to be able to edit the data will not be. Paste the template Will use the original Excel layout to produce the image.

Keep Text Only (D – With this, the data in each cell is placed as text lines in the Word document. The data in the columns are separated by a tab, the rows as single paragraphs Appear.

tip! If you regularly use the paste option that is not Keep Source Formatting , you can click on the Set Default Paste link and change the default settings in the Cut , Copy and Paste section in Word Options .

C: \ Users \ Mr \ Desktop \ ExportWorksheetsToWord03.png

Solution 2: Insert the Excel object

Copy / Paste inserts Excel spreadsheets or worksheet data into a Word document by changing it to a spreadsheet or Word text. Inserting your workbook as an Excel object will embed a small version of Excel in your Word document. This Excel object can contain multiple sheets, filters and many Excel features.

1. Click the Insert tab in the destination Word document, then select the Object from the Insert Embedded Object .

C: \ Users \ Mr \ Desktop \ ExportWorksheetsToWord04.png

2. From the File tab , select Create , then select the workbook you want to embed.

3- Choose whether you want the object to be linked or not:

  • If the source Excel spreadsheet changes, a linked object is automatically updated in the destination Word document.
  • The Word document will not update automatically if the source of the linked object changes.

4- Click OK to complete the installation .

If your object is not linked, you can edit the data directly – including formulas – from within Word. Double-click on the table and make the changes you want in Excel. If the object is linked, clicking on the table will open the Excel window.

C: \ Users \ Mr \ Desktop \ ExportWorksheetsToWord05.png

Solution 3: Add an empty Excel spreadsheet

If you want to import your data sheet into Word from scratch, but want the functionality of an Excel spreadsheet, you can embed a blank Excel spreadsheet in Word and work with it just like you want in Excel.

1. Click on the Insert tab , then select Excel Spreadsheet from the Table drop-down menu .

2- Double click on the worksheet. The Excel page appears and you will be able to add your data, enter and filter formulas and graphically display the data as if you were working directly in Excel.

3. To continue editing your Word document, click outside the spreadsheet or hit ESC .

C: \ Users \ Mr \ Desktop \ ExportWorksheetsToWord06.png

Leave a Reply

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