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 Sex 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

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 Sex 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