Results 1 to 7 of 7
  1. #1
    New Lounger
    Join Date
    Jun 2001
    Location
    Virginia, USA
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Convert Excel to Word Table (2000)

    All I want to do is copy a range of, say, 10 contiguous columns and 10 contiguous rows in an Excel spreadsheet and turn them into a WORD table such that I can manipulate the WORD table's cells (e.g., bold, change font, etc) and the table lines do not run off the page. How do I do this? This should not be very difficult, but it seems to be.

    I have tried copying and Pasting Special (Excel Object, RTF, etc) to no avail. Also, I have tried to copy and paste regular into WORD, then turned on Grid Lines, but the rows go off the page and then I tried to shrink the size of table and column widths to no avail and then I tried to draw a line (select Draw Table and choose line) to create an artificial right border.
    Thanks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Convert Excel to Word Table (2000)

    It works best if you reduce the width of the table in Excel, before copying it.

    In order to convert into a Word table, you should either paste directly, or use Edit | Paste Special with the formatted text (RTF) option. If you adjusted the width of the table in Excel, only minor adjustments should be needed in Word.

  3. #3
    4 Star Lounger
    Join Date
    Nov 2002
    Location
    London, Gtr London, England
    Posts
    496
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Re: Convert Excel to Word Table (2000)

    Dear Signe,

    A simple way to do this is to do a simple copy & paste (don't copy as aan excel spreadsheet) jsut use starightforward menu/keyboard copy & paste, the table may well be larger than the page but ignore this. Then do this:
    1. select the whole table using Table, Select, Table
    2. use Table, Table properties, Table and set the table width to something that fits your page by checking preferred width and specifying a size - will depend on orientation and margins, but do something that will definitely fit.
    3. now make surethat auto fit isn't on by, in the same dialogue, selecting options and unchecking automatically resize...
    4. now you can play with the width and hieghts

    If you dodn't want to manipulate the tabele you could copy as a picture and resize.


    good luck............ liz

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Spokane, Washington, USA
    Posts
    332
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Convert Excel to Word Table (2000)

    Another quick & dirty way to deal with a table that is so wide it runs off the page is to change the page orientation to landscape. If the table still runs off the edge, also change the paper size to legal, which in landscape mode gives you 14 inches to work with. I then grab the edges of the cells and drag them to the left, as necessary, until the table fits within the normal page margins. Finally, change the page length and orientation back to normal. From there, you can make any final adjustment to column width necessary. This is usually faster for me than editing the table properites, and I can see what the table looks like as I make the changes.
    Samantha

    Everything in excess! To enjoy the flavor of life, take big bites. Moderation is for monks!
    Robert A. Heinlein - Time Enough for Love

  5. #5
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts

    Re: Convert Excel to Word Table (2000)

    Yet another way of handling a very wide table is to switch from Page Layout view to Normal view, this will let you drag the column borders back into the area defined by the page margins.

    StuartR

  6. #6
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Convert Excel to Word Table (2000)

    And yet another tool in your arsenal is to re-size/re-scale the embedded Excel object in Word, via Format|Object|Size
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  7. #7
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Spokane, Washington, USA
    Posts
    332
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Convert Excel to Word Table (2000)

    > Yet another way of handling a very wide table is to switch from Page Layout view to Normal view ...

    Thanks for the tip, Stuart. I guess I missed that very simple method because I work almost exclusively in print preview mode, only switching to normal view to accomlish tasks such as this, once I discover them.
    Samantha

    Everything in excess! To enjoy the flavor of life, take big bites. Moderation is for monks!
    Robert A. Heinlein - Time Enough for Love

Posting Permissions

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