Rotating Tables in Calc – LibreOffice 7.0
This page is in Work!
The video shows how you can make columns into rows and rows into columns in a table in Calc and links to this page here, which provides more information and details.
This description is based on the Help of LibreOffice:
This description refers to the version LibreOffice 7.0 under Windows 10.
Link to the Video
Link to the Video (in German [DE]): Tabelle drehen - Spalten und Zeilen tauschen
Rotating tables (transpose)
You have already started your table and now you realize it would be better if you could swap rows and columns.
No problem, you can help by rotating tables (transposing).
To rotate the table and swap columns and rows
LibreOffice Calc offers the possibility to rotate spreadsheets so that rows become columns and columns become rows.
This is called "transposing".
- . Select the table area to be transposed.
- . Select ▸ (Ctrl+X) or also (Ctrl+C).
- . Click on the cell that will become the top left cell in the result.
- . Select ▸ ▸ .
- . In the dialog, select the "Paste All" and "Transpose" options or click on the button.
If you now click on thebutton, columns and rows will be rotated.
Description as document
Documentation / Manuals
You can find the Documentation / Manuals under:
For questions on this topic go to: