Is there a way to copy from excel to word without format getting changed?
Is there a way to copy from excel to word without the format getting changed (for example if you use a size of 6 in excel, which is not supported for the same font in word)?
Currently I'm doing int this way that I copy in excel, put it into paint and then copy to word, but a more straight forward method would be VERY nice.
Solution 1:
The closest I can find (using Office 2010; I'm not sure if it still works with newer versions) is to right-click your mouse, and under Paste Options:
look for the icon that looks like a clipboard overlaid with a picture of a paintbrush (this should be the left-hand icon in the picture above).
Solution 2:
These instructions are for Office 2010, but work exactly the same in Office 2013.
Make sure to set your Cut, Copy, and Paste settings in Word to keep source formatting for cross-program pasting. These settings are found under 'File > Options > Advanced > Cut, Copy, and Paste'.
After you set these settings, it should allow you to keep formatting of text copied from excel. My example shows me copying a 3x3 grid of text set to Calibri size 6.
Which pastes a wonderfully clean table into your word document in exactly the format you copied it.
Solution 3:
The are at least three options:
- put the material in as a Picture
- put the material in as a Table
- put the material in as an embedded Object
Picture is a good way to preserve format. It is easy to re-size and re-position a Picture.
In Excel, copy As Picture and then paste the Picture into your Word doc.
