Invert layout
 

Not sure how to words this, but bascially, I have an excel doc that I want to
invert, i.e make the data in the rows into columns, and the data in the
columns into rows.. The reason I want to do this is because I have 2-3 rows,
but 20-30 columns. You can't print the doc nicely like that.

Any ideas?

I'd insert a new worksheet.

Then select the original range and edit|copy
then go to A1 of that new worksheet and edit|paste special|transpose
and print the sheet (and delete it???)

Moshe Rosenberg wrote:

Not sure how to words this, but bascially, I have an excel doc that I want to
invert, i.e make the data in the rows into columns, and the data in the
columns into rows.. The reason I want to do this is because I have 2-3 rows,
but 20-30 columns. You can't print the doc nicely like that.

Any ideas?

--

Dave Peterson

Amazing! Thanks!

"Dave Peterson" wrote:

I'd insert a new worksheet.

Then select the original range and edit|copy
then go to A1 of that new worksheet and edit|paste special|transpose
and print the sheet (and delete it???)

Moshe Rosenberg wrote:

Not sure how to words this, but bascially, I have an excel doc that I want to
invert, i.e make the data in the rows into columns, and the data in the
columns into rows.. The reason I want to do this is because I have 2-3 rows,
but 20-30 columns. You can't print the doc nicely like that.

Any ideas?

--

Dave Peterson