Adding a big matrix in Word 2013

Discussion in 'Word' started by Kripesh Thekkayil, Apr 25, 2018.

  1. Kripesh Thekkayil

    Kripesh Thekkayil

    Joined:
    Apr 25, 2018
    Messages:
    3
    Likes Received:
    0
    Hi,

    I've an Excel file in which there is a huge matrix (close to 70 rows and 25 columns, mostly Y/N). I need to add this to a Word document. Since this is a living file, inserting as attachment is not an option. Normal copy/paste or creation of table is also out of the question since it looks untidy and is difficult to comprehend.

    I was thinking about this solution. Create a table with three or four important columns with corresponding entries. And, create two drop-down lists in the next column for each row, one with the remaining column title entries, and the other with the corresponding value (Y/N, other values). How can this be done?

    I can create a list and populate with the column titles (first list). How can I create another list by its side, where when in a specific row a specific title from the first list is created, corresponding row value should appear in the second list?
     
    Kripesh Thekkayil, Apr 25, 2018
    #1
    1. Advertisements

  2. Kripesh Thekkayil

    macropod Microsoft MVP

    Joined:
    Mar 2, 2012
    Messages:
    353
    Likes Received:
    32
    You could, of course, copy the Excel range, then paste it into Word using 'Paste Special' with the 'Paste Link' option and the paste format of your choice. That way, the Word table will automatically update to reflect any changes in the Excel data. If you name the Excel range before doing the copy/paste, you will then be able to expand/contract the range in Excel and have Word automatically adjust it's output to match.
     
    macropod, Apr 26, 2018
    #2
    1. Advertisements

  3. Kripesh Thekkayil

    Kripesh Thekkayil

    Joined:
    Apr 25, 2018
    Messages:
    3
    Likes Received:
    0
    Sounds enticing, @macropod
    However, the reason why I don't want the complete Excel table in Word is because of the size of the table. It's huge and Word cannot adjust the margins without making the cells looks really tiny and rendering the content incomprehensible.
     
    Kripesh Thekkayil, Apr 26, 2018
    #3
  4. Kripesh Thekkayil

    macropod Microsoft MVP

    Joined:
    Mar 2, 2012
    Messages:
    353
    Likes Received:
    32
    So insert only as much as you need! And you did say "I need to add this to a Word document"...
     
    macropod, Apr 26, 2018
    #4
  5. Kripesh Thekkayil

    Kripesh Thekkayil

    Joined:
    Apr 25, 2018
    Messages:
    3
    Likes Received:
    0
    Yeah, that was why I wanted to display only three or four columns in the Word document, and make the others (almost 20) visible only on clicking something, or choosing something. Is there an alternative?
     
    Kripesh Thekkayil, Apr 26, 2018
    #5
  6. Kripesh Thekkayil

    macropod Microsoft MVP

    Joined:
    Mar 2, 2012
    Messages:
    353
    Likes Received:
    32
    You could, of course, insert different ranges of the Excel data (e.g. in 5-column blocks) as separate tables via the copy/paste technique I described...
     
    macropod, Apr 27, 2018
    #6
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.