+ Reply to Thread
Results 1 to 2 of 2

Convert one row and 50 columns of info to a single printable page

  1. #1
    d5657
    Guest

    Convert one row and 50 columns of info to a single printable page

    I need to take a row of my Excel data which has about 50 columns and move it
    easily to be viewed on a single sheet/table/Word doc etc. I also need the
    column title for each item in the row. For instance:

    Name Age *** Phone Book ........50....... Store Chairs Grade
    Fred 7 m 325 Ab 3 19 B

    I need this long list of column data to be turned into a single page of data
    with the associated header. It will always be the header row and a single
    data row.

    Thank you
    Don

  2. #2
    nick.pattison
    Guest

    RE: Convert one row and 50 columns of info to a single printable page

    you could create a new sheet and use very simple formulas to recreate the
    header row plus the row of data next to each other and then copy and paste
    into Word or whatever from the new sheet (for Word try paste special...
    picture)

    "d5657" wrote:

    > I need to take a row of my Excel data which has about 50 columns and move it
    > easily to be viewed on a single sheet/table/Word doc etc. I also need the
    > column title for each item in the row. For instance:
    >
    > Name Age *** Phone Book ........50....... Store Chairs Grade
    > Fred 7 m 325 Ab 3 19 B
    >
    > I need this long list of column data to be turned into a single page of data
    > with the associated header. It will always be the header row and a single
    > data row.
    >
    > Thank you
    > Don


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1