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

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:

  • Microsoft Office Excel 2003

5 comments for “How to convert Columns to Rows (OR) Rows to Columns in Excel?

  1. May 31, 2011 at 12:05 PM

    That’s the best asnwer of all time! JMHO

    • August 14, 2011 at 12:19 AM

      I think you hit a blluseye there fellas!

      • August 27, 2011 at 9:10 AM

        This is way better than a brick & moartr establishment.

  2. August 14, 2011 at 12:13 AM

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

    • August 27, 2011 at 8:09 PM

      Gosh, I wish I would have had that inforamtoin earlier!

Leave a Reply