Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

Rotating Tables (Transposing)

In Office 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 box, mark Paste all and Transpose.

If you now click OK the columns and rows are transposed.