[plug] openoffice calc question

Alex Polglaze apolglaze at book-keepingnetwork.com.au
Mon Nov 21 12:05:27 WST 2005

Senectus . wrote:
> How do you turn a row of cells with data in them into a column of cells ?
Rotating Tables (Transposing)

In OpenOffice.org Calc, there is a way to "rotate" a spreadsheet so that rows become 
columns and columns become rows.
1.Select the cell range that you want to transpose.
2.Choose Edit - Cut.
3.Click the cell that is to be the top left cell in the result.
4.Choose Edit - Paste Special.
5.In the dialogue, mark Paste all and Transpose.
If you now click OK the columns and rows are transposed.

Alex Polglaze

More information about the plug mailing list