locked
How to convert MS Office 2010 one row data to MS Word 2010 in one column in to table.? RRS feed

  • Question

  • Hi,

    I want to convert each row i.e in excel sheet  to MS office table in one column .

    e.g in excel sheet I have the below data.

    Name DOB               Class

    Rits    01-01-1988    MCA

    and in word I want that should be display as

    Name    Rits

    DOB      01-01-1988

    Class     MCA

    in a table.

    Please reply as it is an urgent.

    Thanks & Regards

    Sunday, April 21, 2013 2:36 AM

Answers

  • EXCEL & WORD 2007

    Take the following actions:-

    1. Highlight the first 6 cells in your above data then do a:-

    CTRL-C

     - to copy those cells.

    2. Click in another part of the EXCEL Worksheet then:-

    Home tab

    Clipboard group

    Click on the drop down arrow beneath:-

    Paste

     - then click:-

    Transpose

    The data is now the way you want it in EXCEL.

    3. Highlight the transposed data then:-

    CTRL-C

     - to copy it.

    4. Click in the WORD document then:-

    CTRL-V

     - to paste.

    5. In WORD highlight the copied table then:-

    TableTools

    Design contextual tab

    Click on the drop down arrow to the right of:-

    Borders

     - then click on:-

    All Borders

    You should now have what you want.

    If my comments have assisted please Vote As Helpful.

    Thanks.

    • Marked as answer by Max Meng Wednesday, April 24, 2013 9:42 AM
    Sunday, April 21, 2013 5:03 AM

All replies

  • EXCEL & WORD 2007

    Take the following actions:-

    1. Highlight the first 6 cells in your above data then do a:-

    CTRL-C

     - to copy those cells.

    2. Click in another part of the EXCEL Worksheet then:-

    Home tab

    Clipboard group

    Click on the drop down arrow beneath:-

    Paste

     - then click:-

    Transpose

    The data is now the way you want it in EXCEL.

    3. Highlight the transposed data then:-

    CTRL-C

     - to copy it.

    4. Click in the WORD document then:-

    CTRL-V

     - to paste.

    5. In WORD highlight the copied table then:-

    TableTools

    Design contextual tab

    Click on the drop down arrow to the right of:-

    Borders

     - then click on:-

    All Borders

    You should now have what you want.

    If my comments have assisted please Vote As Helpful.

    Thanks.

    • Marked as answer by Max Meng Wednesday, April 24, 2013 9:42 AM
    Sunday, April 21, 2013 5:03 AM
  • Add a screenshot


    Max Meng
    TechNet Community Support

    Wednesday, April 24, 2013 9:42 AM