Swapping rows and columns

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

[PCLIVE]

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

Regards,
Paul

"Dorn" <[email protected]> wrote in message
news:[email protected]...
> 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.

[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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Dorn" <[email protected]> wrote in message
news:[email protected]...
> 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.