Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Sep 2004
    Location
    Portsmouth, Hampshire, England
    Posts
    200
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Copying Excel data only to Word table (XP 2002 SP3)

    I have a table in Word which is in the format that I require.

    What I want to do is to copy the data from an Excel table to the word table (and have it create any extra rows that it needs to fit, but to retain the word formatting and table size.

    Going from Word to Excel I could just do Paste Special->Values.

    Any ideas how to achieve it the other way round?

    TIA
    Regards
    Paul

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

    Re: Copying Excel data only to Word table (XP 2002 SP3)

    If you have different formatting for different rows, you'd have to copy and paste cell by cell. Otherwise, try this:
    - Create a one-row table with the desired formatting in Word.
    - Copy the table in Excel.
    - Position the insertion point immediately below the table in Word.
    - Paste.
    - Delete the now superfluous first row.

  3. #3
    3 Star Lounger
    Join Date
    Sep 2004
    Location
    Portsmouth, Hampshire, England
    Posts
    200
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copying Excel data only to Word table (XP 2002 SP3)

    I had already tried that (well it was actually a 5 row table that I pasted below). The table and cell widths seemed to be correct, but the formatting was still as it had come from Excel (not too much of a problem), but the real problem with that method was that the table columns were offset from the original ones and I can't sem to line 'em up again.

    Attached is a picture of what I ended up with.
    Attached Images Attached Images

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

    Re: Copying Excel data only to Word table (XP 2002 SP3)

    Strange. Below is a picture of what I get.
    As you can see, the pasted data take on the formatting from the existing Word table.
    I'm using Office XP SP-3 too.
    Attached Images Attached Images
    • File Type: png x.PNG (14.9 KB, 0 views)

  5. #5
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Copying Excel data only to Word table (XP 2002

    I like to create an exactly sufficient number of blank rows in the already formatted table, select those cells, and paste the incoming data without formatting. Word should lay the cell data in exactly the right places. If you try this, note that any mismatch in the source and destination row/column count and shape will lead to problems... (e.g., Word can't pivot when doing this kind of paste).

Posting Permissions

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