How to convert Columns to Rows (OR) Rows to Columns in Excel?

22May/115

The following steps explains how to convert columns to rows (OR) rows to columns in Excel Spreadsheet.

Step (1) Select the columns (OR) rows from Excel Spreadsheet.

Step (2) Copy the selected columns (OR) rows.

Step (3) Select the location in the spreadsheet where you want to paste the copied columns (OR) rows.

Step (4) Right mouse click from selected location and select Paste Special... from pop-up menu. It will display Paste Special dialog.

Step (5) Check Transpose checkbox from Paste Special dialog and Click OK button.

Step (6) It will display the copied columns as rows (OR) copied rows as columns.

This Article applies to the following Versions:

Josie
May 31st, 2011 - 12:05

That’s the best asnwer of all time! JMHO

Log in to Reply
- Azia
  August 14th, 2011 - 00:19
  
  I think you hit a blluseye there fellas!
  
  Log in to Reply
  - Charl
    August 27th, 2011 - 09:10
    
    This is way better than a brick & moartr establishment.
    
    Log in to Reply
Benon
August 14th, 2011 - 00:13

You’ve hit the ball out the park! Incerdible!

Log in to Reply
- Jayna
  August 27th, 2011 - 20:09
  
  Gosh, I wish I would have had that inforamtoin earlier!
  
  Log in to Reply