OpenOffice: Swap rows and columns
This practical tip shows you how to swap rows and columns in "OpenOffice".
Swap rows and columns in OpenOffice
The free software "OpenOffice" is a versatile multitool that includes, for example, a spreadsheet, word processing or database management. Proceed as follows if you want to swap rows and columns in the "OpenOffice" spreadsheet:
- Start "OpenOffice" and open the document in which you want to exchange rows and columns.
- Select all the cells you want to swap.
- Right-click on the marked area and go to "Copy".
- Now click on a free area in your table where you want to insert the table upside down.
- Go to "Edit" in the menu bar and then to "Paste Special".
- In the new window, tick the "Transpose" option at the bottom left and then confirm your setting with "OK" (see screenshot).
Another practical tip tells you how to fix columns and rows in OpenOffice.