How to swap (transpose) rows and columns in Excel 2013

How to swap (transpose) rows and columns in Excel 2013

Imagine that you styled all the row and column headings, entered all the data into an Excel worksheet, and then found that the table would look better if it was turned upside down, i.e. upside down. swap rows and columns. What to do in such a situation?

In Excel, there is an easy way to convert rows to columns and vice versa using the Transpose (Transpose). Next, we’ll show you how.

  1. Select the cells containing the headers and data you want to transpose.How to swap (transpose) rows and columns in Excel 2013
  2. Push command Copy (Copy) or keyboard shortcut Ctrl + C.How to swap (transpose) rows and columns in Excel 2013
  3. Select an empty cell on the sheet. This cell will be the top left corner of your new table.How to swap (transpose) rows and columns in Excel 2013
  4. From the command dropdown menu paste (Paste) select item paste Special (Special insert).How to swap (transpose) rows and columns in Excel 2013
  5. In the dialog box paste Special (Paste Special), check box Transpose (Transpose) and press OK.How to swap (transpose) rows and columns in Excel 2013
  6. Rows and columns will be swapped. The original data will be preserved. You can select and delete them if you wish.How to swap (transpose) rows and columns in Excel 2013

Agree that transposing a range is easier than typing the entire table again.

Leave a Reply