<< Click here to Goto HomePage

     
     

Monday, June 11, 2007

How to easily Transpose Rows and Columns in Excel

Columns can be transposed into rows, and rows can be transposed into columns very easily in Excel.

Note: Data from the top row of the copy area appears in the left column of the paste area, and data from the left column appears in the top row.

Here's how you can do it.

  1. Select the cells that you want to switch and click Copy.
  2. Click the upper-left cell of the paste area. The paste area must be outside the copy area.
  3. Click the arrow to the right of Paste and then click Transpose.

2 comments:

  1. Anonymous said,

    Dear Jason,

    Could you please mention the version of the MS office product (2000/XP/2003/2007) in which this feature is available..

    regards

    -Roshan

    on 7/01/2007 6:59 PM


  2. JASON S said,

    Hi Roshan,

    I have tried in Office XP and 2003. Haven't yet tried on 2007.

    Cheers!!
    Jason

    on 7/01/2007 9:47 PM