Houston, Texas

San Antonio, Texas

Course Links

training schedule
  •  Houston
  •  San Antonio
training schedule
training schedule


training schedule
training schedule
training schedule

training schedule Course

Houston Schedule
San Antonio Schedule


Better Business Bureau






Microsoft Excel TrainingMicrosoft Excel: Transpose Rows and Columns


  • Transpose Rows and Columns using Paste Special. Is your data table lay-out a bit off? Try changing your table by switching the row headings with the column headings.

By using the Paste Special feature Transpose, we can swap our Rows and Columns while ensuring that the data still matches up.

How Transpose Rows and Columns

Download Sample File: Transpose.xls

1. Open an Excel file with data layed out in a table, or use our sample file.

2. Highlight the data that you would like to transpose and copy the data (CTRL+C).


3. Click on cell where you want to paste the data.

4. Paste the data by using the Paste Special > Transpose feature.

  • Excel 2007 & 2010 Users:
    Click on the Home tab's Paste drop-down and select Transpose OR you can select Paste Special and check the Transpose option and click OK.

paste transpose

  • Excel 2003 Users:
    To access the Transpose feature, use the menu Edit > Paste Special > Transpose.

paste special transpose

4. Notice that your data has its columns and rows swapped.

transpose results



Excel Solutions Team is committed to helping you increase productivity by improving your knowledge of the tools you use everyday. Contact us at 713.589.2655 for pricing and registration information.

• Hands-On, Instructor-Led Training Courses
• Individual & Group Corporate Classes
• Fully Customizable Training Sessions
• Training at Our Location or Yours
• Professional Grade Courseware
• Full Day & Half Day Options





                                                         |   Home   |   Email Us   |   Privacy Notice   |   Site Map   |