Skip to main content
Mail a PDF copy of this page to:
(Your email address will not be added to a mailing list)
Show menu Show menu



Allows to convert rows to columns and columns to rows.

Using the Transpose command you can switch the orientation of data, either in a selected area, or in the complete spreadsheet.

Data from the top row of the area to transpose will appear in the left column of the transposed area, and data from the left column will appear in the top row.

When you want to transpose only a particular area of the spreadsheet, you first select this area with the mouse. In this case, the number of rows and the number of columns of the selected area must be equal (while selecting, this can be checked in the status bar).