Results 1 to 4 of 4
  1. #1
    Graeme Cannell
    Guest

    Copying Excel data into Word Tables

    We have been importing Excel data up to now into Tables in Word Perfect using an import command and specifying the cells to be copied into a pre formatted Table. The Table format was preserved and it was very quick. We have changed to Word and set up similar Tables however there does not appear to be an analogous way to do this. Linking and embedding would be time consuming as there are a large number of Tables. Does anyone know a way to transfer numerical data across (copy and paste does results in all data being placed in a single cell)?

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    New Zealand
    Posts
    295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copying Excel data into Word Tables

    Graeme, are you able to format the cells in excel the same as they are in Word??? If yes you can then copy and paste, but not into a table - just into a blank spot. The formatting from Excel will remain. <img src=/S/lightbulb.gif border=0 alt=lightbulb width=15 height=15>

  3. #3
    Super Moderator
    Join Date
    Dec 2000
    Location
    New York, NY
    Posts
    2,970
    Thanks
    3
    Thanked 29 Times in 27 Posts

    Re: Copying Excel data into Word Tables

    You should be able to paste the Excel data into a Word table, without it all going into one cell: create a Word table that has the same number of columns and rows corresponding to the data in Excel.
    Then select the rows and columns of the Word table, but take care not to select the end of row markers. When you Paste, the Excel data should go into separate cells (I'm trying this on Word 2000 right now, but this should work similarly in Word 97).

  4. #4
    Graeme Cannell
    Guest

    Re: Copying Excel data into Word Tables

    Thanks for the advice. Problem solved!

Posting Permissions

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