Switching Axis

  • Thread starter Thread starter tedsudol
  • Start date Start date
T

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
 
Hi Ted

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