How-To Geek

How to Transpose Rows and Columns in Excel 2013


You’ve setup your worksheet with all your row and column headings and you’ve entered all your data. Then, you discover that it would look better if the rows were the columns and the columns were the rows. How do you accomplish this easily?

There is an easy way to convert your rows to columns and vice versa using the Transpose feature in Excel. We’ll show you how.

Select the cells containing the headings and data you want to transpose.


Click Copy or press Ctrl + C.


Click in a blank cell on the spreadsheet. This cell will be the top, left corner of the new table of data.


Click the down arrow on the Paste button and select Paste Special from the drop-down menu.


On the Paste Special dialog box, select the Transpose check box so there is a check mark in the box and click OK.


The rows become the columns and the columns become the rows. The original set of data still exists. You can select those cells and delete the headings and data, if desired.


Isn’t that a lot easier and faster than retyping all your data?

Lori Kaufman is a freelance technical writer who likes to write geeky how-to articles to help make people's lives easier through the use of technology. She loves watching and reading mysteries and is an avid Doctor Who fan.

  • Published 11/7/13

Enter Your Email Here to Get Access for Free:

Go check your email!