SEARCH

How-To Geek

How to Transpose Rows and Columns in Excel 2013

00_lead_image_using_transpose

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.

01_selecting_cells_to_transpose

Click Copy or press Ctrl + C.

02_clicking_copy

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

03_clicking_in_new_cell

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

04_selecting_paste_special

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

05_selecting_transpose

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.

06_transposed_cells

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

Get Free Articles in Your Inbox!

Join 134,000 newsletter readers

Email:

Go check your email!