Applications

Help Sections:

General

Writer

Impress

Math

Draw

Calc

Base

Basic

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 dialog, mark Paste all and Transpose.

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

Index

tables, transposing

transposing tables

inverting tables

swapping tables

columns, swap with rows

rows, swapping with columns

tables, rotating

rotating, tables

This help text is published from the OpenOffice-Help files under the Public Documentation License 1.0.