Reverse the axis of a sheet

[caramba]

I have big excel document with content isn't for calculating. It's used to display a structure.

I have headings in the sheet going left to right with content in every column beneth each heading. The content of the cells is often very long.

I would now like to reverse the axis so the headings with colums go from top to bottom instead of left to right. I want the heading to end up in the first column and each column to be a row after each heading.

Is this possible??

I know I can wrap the lines, but I'm not interested in that.

[Roadie]

If I understand the question correctly, you want to Transpose.
Select your range, choose Copy and then PasteSpecial. Check the box for Transpose and the columns and rows will switch.

[caramba]

Thanx a bunch Roadie!!

That was exactly what I was looking for!


Cheers!!