Copying and Pasting Excel Tables into Word

  • Thread starter Thread starter Suzan
  • Start date Start date
S

Suzan

We do our financials in Word, and copy and paste special as enhanced
metafiles the tables that we do in Excel. This works perfectly in Word 2003.
In 2007 however, when we past the table and print it, the table looks
different (letter spacing funny, not smooth). I have tried printing to five
different printers and it still happens.
 
I'd suggest a slightly different approach. If you insist on using enhanced
metafiles, try the following:

1. Select the range that you want to copy.
2. Instead of Copy, select the dropdown under Paste>As Picture>Copy as
Picture.
3. In the ensuing dialog box, under Appearance select As shown when printed.
4. Then paste special as you normally would, selecting enhanced metafile as
the type.
 
Back
Top