Rotating Tables in Calc – LibreOffice 7.0

From The Document Foundation Wiki
Jump to: navigation, search
Other languages:
Deutsch • ‎English

This page is in Work!

Table marked
Paste Special...
Dialog: Paste Special
Table transposed


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

  1. . Select the table area to be transposed.
  2. . Select Edit ▸ Cut (Ctrl+X) or also (Ctrl+C).
  3. . Click on the cell that will become the top left cell in the result.
  4. . Select Edit ▸ Paste Special ▸ Paste Special....
  5. . In the dialog, select the "Paste All" and "Transpose" options or click on the Transpose button.

If you now click on the OK button, columns and rows will be rotated.

Further Informations

Work files

Work table

"Tabelle umkehren - transponieren.ods"

Description as document

"Tabelle umkehren - transponieren.odt"

Documentation / Manuals

You can find the Documentation / Manuals under:

Documentation / Manuals

Any questions?

For questions on this topic go to: