Swapping rows and columns

D

Dorn

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.
 
P

PCLIVE

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

Regards,
Paul
 
B

Bernard Liengme

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
 
Top