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.

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.

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

6. 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.
7. If you do not see that, as an alternative step, you can right-click an empty cell and select Paste Special.

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

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