Transpose cells in Excel

To turn a column into a row or a row into a column, for example Page Headings, you can use the Transpose function.

To use Transpose

In this example a row of text is turned into a column.

  • Select the cells in the row to be transposed
  • Choose Copy
  • Select the starting cell for your transposed list (not one of the selected cells)
  • Right mouse click, choose Paste Special
  • Choose Transpose and click OK.