EXPORTING TO WORD

Export to word 

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

 

 

1. Open the destination Word document.
2. In the source Excel spreadsheet, select the data you want to copy then hit CTRL-C.
3. In the destination Word document, place the cursor where you want the data, then hit CTRL-V.

4. The default paste will use the Keep Source Formatting (A) paste option. This preserves any formatting you have done in Excel and pastes the data into Word as a table using that same formatting. As you can see, you may need to clean up your table after the paste to make it look correct in the new document.
5. 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. Other Paste options include: 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. Use this to make your fonts and colors consistent in the destination without having to edit in Excel beforehand.
   
   Copy as Picture (C) – This will paste the data range as a Word image object. 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. The paste will use the original Excel formatting to generate the picture.