excel

The Transpose Feature in Excel 2013

Transposing (i.e., swapping columns, rows, etc.) is an old trick in Excel and I am happy to report that it is still available to you in Excel 2013!

As you will see in my screenshot below, I have a worksheet in Excel that is vertical in orientation, using a column style.

Vertical-Layout

  1. So go ahead, and create your own worksheet so you call follow along.
  2. Now we can move forward and change the same worksheet into a horizontal row style.
  3. From your worksheet, select the cells you would like to change.
  4. Now, right-click and select Copy.

Copy

  1. Next, right-click in any empty cell and select Paste Options | Transpose as shown below.

Paste-Special1

  1. One of the special features of Excel 2013 is it will show you a preview of what your paste will look like before confirming the action.
  2. If you do not see that, as an alternative step, you can right-click an empty cell and select Paste Special.

paste-special

  1. You can now from it’s window, check the Transpose box.
  2. Click OK.

Transpose

You will now see your data has been transposed to a new layout style.

 

1 thought on “The Transpose Feature in Excel 2013”

  1. Jason Shuffield

    Thanks Carol for this article I think excel is a great tool. Sometimes I need a little help figuring out where they move features when they change versions. Plus you know how to explain it clearly. Keep them coming ­čÖé

Comments are closed.

Scroll to Top

WHY NOT SUBSCRIBE TO OUR NEWSLETTER?

Get great content like this delivered to your inbox!

It's free, convenient, and delivered right to your inbox! We do not spam and we will not share your address. Period!