Table width

[sore]

Is there any option to make the table of contents larger than 256 cells in width?

I'v heard from someone,that you should make an inverse table (i.e fill in the rows as coumns) and then there's some kind of function that inverses the table...sounds very strange to me...

Would love to get some feedback on that issue.

Thanks.

[Raiby]

Is there any option to make the table of contents larger than 256 cells in width?

I'v heard from someone,that you should make an inverse table (i.e fill in the rows as coumns) and then there's some kind of function that inverses the table...sounds very strange to me...

Would love to get some feedback on that issue.

Thanks.

Hi sore

Copy/PasteSpecial/Check Transpose

[sore]

Hi sore

Copy/PasteSpecial/Check Transpose

Thanks for quick reply!
I'v tried that before,it works pretty well when all the contents are inside 256 columns margin.
But if I have a really long table(800-900) rows,and I want to transpose it, it wont let me do so.
Im required to pick the "correct" dimentions for the table, and im guessing its because of the large row count,which cannot be transposed into the same column count(there are 256 MAX).

So I was wondering if there's maybe some addon or exotic solution for this problem.

Thanks again.

[Raiby]

Thanks for quick reply!
I'v tried that before,it works pretty well when all the contents are inside 256 columns margin.
But if I have a really long table(800-900) rows,and I want to transpose it, it wont let me do so.
Im required to pick the "correct" dimentions for the table, and im guessing its because of the large row count,which cannot be transposed into the same column count(there are 256 MAX).

So I was wondering if there's maybe some addon or exotic solution for this problem.

Thanks again.

Sorry, i don't see the solution.I wonder if it's possible: maybe with excel 2007 but i don't know this version.Do you want to print your data?If i understand, you want to reorganize your table.