Pasting Excel cells as "Picture (Enhanced Metafile)"



  • 1. I accidently hit something and suddenly the computer was reading .
    please tell me how I got my word document to suddenly be read out loud by the computer. Thanks
  • 2. How do I do this?
    I am looking for information on how to do something but I don't know what it is called. Here is what I am trying to do: I am making a template for a proposal. In this template the Client's name appears approximately 30 times. How can I set up the template so all the salesperson has to do is type the Client's name in one area and then everywhere else in the template, the Client's name should appear, it would automatically fill it in. Any input would be greatly appreciated! Kim
  • 3. add in a red-line feature to Word, which is the opposite to strik.
    It would be nice to have a red-line feature in Word. I correct a large number of documents and have to show the deletions and changes. The strike-out feature is available for deletions, but there is no equivalent for showing the modifications (red-line). I could always paint the changes, but this is a feature which does not print correctly in a text environment.
  • 4. Why
    Hello from Steved <[a-zA-Z]{16,}> using wildcard Using the above to count 15 Characters. Replace the below from Constantley Latness to Constantley Lat = 15 Characters What Have I got wrong Please. Thanks in Advance.
  • 5. How do I set the tab button in a word document to only move from .
    In Microsoft Word 2003, I have a created document. There are blanks that need to be completed. I would like to be able to tab from one space to the next without disturbing the format of the document. Whe pushed, the tab button should only move from on blank space to the other.

Pasting Excel cells as "Picture (Enhanced Metafile)"

Postby U2Ft » Mon, 25 Jul 2005 20:28:01 GMT


I need to paste cells from Excel into Word  as "Picture (Enhanced Metafile)" 
(I need to do this over 100 times).  Every time I do this, the resulting 
picture's top left corner ends up violating the top left margin of the Word 
document (even though my cursor was located at the top left corner of the 
page when I did the pasting).  I then have to both move and resize this 
picture.  Is there any way to either

a)  automatically resize the picture so it has the largest possible size 
without violating any of the page margins (and not being distorted)


b)  if (a) above is not possible, at least move the picture so that its top 
left corner is at the top left corner (as defined by the margins set for the 
page) of the page?

Thank you for your help! 

Re: Pasting Excel cells as "Picture (Enhanced Metafile)"

Postby Suzanne S. Barnhill » Mon, 25 Jul 2005 23:40:52 GMT

It sounds as if you want your pictures to be In Line With Text. Although
Word 2002 and 2003 allow you to select the default wrapping for inserted and
pasted graphics, this setting doesn't apply to Paste Special, which still
pastes with (IIRC) Square wrapping. But changing the wrapping to In Line
With Text should put the graphic back where you want it.

Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site:  http://www.**--****.com/ 
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.


RE: Pasting Excel cells as "Picture (Enhanced Metafile)"

Postby SmltIFBhbGlr » Tue, 26 Jul 2005 00:14:01 GMT

Hello Sam,

You might have a corrupted that is not honoring the page margins. 
Try renaming your (rename to avoid losing customization made to, open a new copy of word (this will create a new and 
attempt your copy and paste again. If this does not work, try pasting into 
pre-sized text boxes.


Never at a loss for Word

RE: Pasting Excel cells as "Picture (Enhanced Metafile)"

Postby Um95IFNwcnVuZ2Vy » Wed, 28 Nov 2007 00:14:01 GMT


I frequently paste content from other applications into Word documents, 
including Excel cells, and have found creating a one-cell table works best as 
a container for paste special, picture (enhanced metafile).  If the image is 
too big for the margins, the boundaries of the cell restrain the image and 
Word automatically resizes the image.


Similar Threads:

1.Editing a Table Pasted from Excel into Word as a Picture (Enhanced Metafile)


I am copying a section of an Excel Spreadsheet, and then pasting into
word using Paste Special -> Picture (Enhanced Metafile)

When I right click on the object in word, one of the menu choices is
"Edit Picture" This will allow me to change text in the picture, which
seems to be included through the use of text boxes.  I make a minor
change that is required, but then I cannot seem to revert the image or
picture back to its previous form, which seems to be as a normal
picture file that has been inserted.  The only way I can figure out
how to do this is by using the undo command, but I loose my text
chance.  If the picture stays in the new, editable format, whenever I
click into it, all of the text is becomes highlighted, which really
slows down my ability to continue work on the rest of the document.
The new format seems to be seen by word as a Drawing Canvas.

Does anyone know how I can make a text change, and then get Word to
see the image as an inserted picture file again as opposed to this
drawing canvas?


2.Pasting Excel Graphs (charts/enhanced metafile pictures) into Word

I am looking for a similar solution posted by Donahue, 
8/20/04, 7:07 am.

I have pasted excel charts and enhanced metafile pictures 
in a word document, sent this to a colleague who has Word 
2001 for the Mac, and she is unable to view these files.  
She sees a big (red?) X.

Size/memory is not an issue here.

Any help here?

3.Font colours disappear when pasting to Powerpoint as Metafile/Enhanced metafile

When using copy/paste special to take a range from Excel 2002 to Powerpoint
2002 all is fine on my PCs - i.e. all formats are kept as expected.

However, my client has 2 of his own machines and 2 of his clients that lose
the font colour only - all text is black (background colours etc are fine).
Colour is retained in HTML and Bitmap formats but not Metafile or Enahnced

Anyone else had this problem?  If so, any solutions please.

4.Paste Special , Paste link as Picture (enhanced metafile)


One of my colleague wants to paste excel table  in word.

He select the cell and use paste special in Word , paste link and would like 
to  paste as Picture(Enhanced Metafile).

But Picture(Enhanced Metafile option is missing in word.  He only gets 
Graphic (windows metafile)

We are using Office 2003. He told this option was avalaible in Office XP 2002.

Any idea, how to get this option in Word 2003?


5.Paste Special: Metafile vs Enhanced Metafile

What's the difference between Picture (Windows Metafile) and Picture 
(Enhanced Metafile) in the Paste Special options? Is there a good rule as to 
when to use one over the other?

At a quick look for pasting Excel sheets, they seem the same, but I'd guess 
that's just because Excel sheets don't have any fancy graphics, gradients, 
etc. But that's just my guess. Perhaps Windows Metafile is fine for basic 
shapes and Enhanced Metafile is better for advanced vector images?


6. Inserting "Picture (Enhanced Metafile)" onto 1-cell table

7. Paste Special, picture (enhanced metafile) Problem in Word 2003

8. Macro for Paste Special - Picture (Enhanced Metafile)

Return to MS WORD


Who is online

Users browsing this forum: No registered users and 50 guest