Simple question on cutting and pasting into Word from Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello

I have encountered a problem with Word which has puzzled me.

Quite often I create a table or chart in excel and then copy and paste in to
Word. I use <copy><paste special><Microsoft Excel Chart Object> or <Microsoft
Excel Worksheet Object>.

When I use Excel 97 to paste into Word 97 then I cna do this no problem.
However, if i use 2000, the object doen't appear correctly in Word. Often i
can just see the bottom of the object and it resists resizing or dragging so
that it canbe viewed.

Is there something I am missing with later versions of Word / Excel that is
causing the problem?

I'd appreciate any help on this matter.

Regards


Alex
 
Hi Alex

If you can just see the bottom of the object, it sounds like you have pasted
the chart into a paragraph which has line spacing set to an exact
measurement. If Word thinks this paragraph is supposed to be, say, 12pt
high, then it will keep it 12pt high, even though you have a page-high chart
in it. So, make sure that the paragraph into which you paste has line
spacing set to Single.

Alternatively, try pasting using Edit > Paste Special > Picture (Enhanced
Metafile).

Hope this helps.

Shauna Kelly. Microsoft MVP.
http://www.shaunakelly.com/word
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem linking excel charts in word 1
How do I copy and paste an entire 4 page Word Doc into Excel? 3
Inserting excel spreadsheet into word - problems 3
Word 2003 - Cut and Paste or Copy and Paste is very slow 1
Word 2007 Import Excel spreadsheet from Workbook 1
Linked Excel chart object question 1
Linking Excel File with Word 4
Copy paste, link problem 1

Back
Top