Swapping rows and columns
 

Hey guys,

Is there a quick way to make the spreadsheet rotate so all of the rows are
columns and all of the columns are rows? There aren't any formulas on the
sheet so references shouldn't be a problem.

Swapping rows and columns
 

Try selecting the cells to rotate, then ctrl+c.
Goto Edit-Paste Special.
Select Transpose.

Regards,
Paul

"Dorn" wrote in message
...
Hey guys,

Is there a quick way to make the spreadsheet rotate so all of the rows are
columns and all of the columns are rows? There aren't any formulas on the
sheet so references shouldn't be a problem.

Swapping rows and columns
 

Select the data in the worksheet and click the copy button
Move down to an used part of the worksheet; right click in a cell in column
A and select Parte Special from the popup menu; click in the Transpose box,
click OK
Now delete the original data
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Dorn" wrote in message
...
Hey guys,

Is there a quick way to make the spreadsheet rotate so all of the rows are
columns and all of the columns are rows? There aren't any formulas on the
sheet so references shouldn't be a problem.