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.

 

Posted in:
About the Author

Carol Bratt

Carol holds A+, MCP, and MOS computer certifications and is the resident DCT Office expert. She trains the staffs of small law firms in the use of Microsoft Office applications and has authored many books covering Microsoft Office as well as written articles for Infopackets, TechnoLawyer, and Digital Harbor. For more Microsoft Office tips visit Carol's Corner Office or follow Carol on FaceBook and Twitter.

There is one comment

Your email address will not be published. Required fields are marked *