Switching Axis

[tedsudol]

Hi,
Is there a way in Excel 97 to easily switch the axes in
an already built spreadsheet.
I built an informational form that lists the field
headings vertically, the next column would contain the
data the client would enter. The client has asked me if I
could arrange it left to right. I was wondering if there
was an easy way to switch the axis rather than redoing the
sheet. Thanks in advance for your help.

Ted Sudol

 

[DavidP]

Hi Ted

I think if youcopy then use Edit/Paste Special and check the box
marked Transpose it will give you what you want