Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Mar 2002
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Format Excel data (Word 2000)

    This shouldn't be as hard as it seems...

    I'm copying certain cells from an Excel 2000 spreadsheet and using paste special into a Word 2000 document. I'd like the cell's information to come in the same format as the Word document's paragraph. Instead, no matter how I paste the link (unformatted text, RTF, etc.), it seems to have a mind of its own, including changing fonts in the middle of a text string!

    Help please

  2. #2
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Format Excel data (Word 2000)

    I hope someone can help you with this; all I can say is that Office XP has the Copy/Paste smart tag that lets you pick the format to paste. Very nice feature.
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  3. #3
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Pune
    Posts
    310
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Format Excel data (Word 2000)

    If you block mark only the contents of a cell rather than the entire cell, then pasting it as unformatted text into Word allows the text to take the Word Style formatting.

    I am not sure how to do it in Office 2000 with multiple cell selections.

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Format Excel data (Word 2000)

    If I paste excel data into word as unformatted text, it takes on whatever the font and paragraph properties are at the insertion point.

    However if I paste into a word table, the Normal paragraph format applies.

    If you are pasting into a table try pasting to to a paragraph, and then convert text to table.

    Andrew C

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •