Home »  Software »  Office Suite Software

How Do I Convert Rows to Columns in Excel®

March 26, 2012  |  Difficulty: Easy

how to convert your Microsoft® Excel® columns to rows with ease.

Have you ever found yourself looking for a function in Microsoft® Excel® to turn your table and all the data over from rows to columns and vice versa? Although a function to do this does not exist, there is a way to accomplish it. By using the instructions below you can convert your Microsoft® Excel® columns to rows with ease.

Converting Rows to Columns:

  1. Launch the Microsoft® Excel® spreadsheet and open the table you want to turn over.
  2. Select all the table’s cells.
  3. Press “Ctrl+C” or right-click on the selection and choose the “Copy” option. The table will be placed in the clipboard, and now you have to place it back transposed.
  4. Right-click on any unselected cell and select “Transponse” in the “Paste options” menu. The paste options are also located in the “Home” tab. Select “Paste Options” in the “Paste” dropdown. Congratulations! You have successfully converted your Excel® table!


Most Popular Articles:

What Is the Best Backup Software for Me

Internet Security Solutions Detect Legitimate Soft

How Do I Block Internet Intruders from Spying

How Do I Choose a Data Backup Software

How Do I Install a FREE Spyware and Adware Blocker

Related Articles:

How to insert a new line, row, or column between ones that already exist

How Do I Add a Line or Column in Microsoft Excel®

how to insert a chart into a Microsoft® Excel® 2010 spreadsheet

How Do I Make a Chart in Microsoft® Excel® 2010

how to set up the universal sorting for any column in Microsoft® Excel® 2010.

How Do I Set Up Universal Sorting in Excel® 2010

How to format and merge cells in your Microsoft Excel® spreadsheet

How Do I Merge Cells in Microsoft Excel®

how to sort data in your Microsoft® Excel® 2010 spreadsheet or table

How Do I Sort a Row or Column in Microsoft® Excel®

Help Us Spread the Word!

Love us on Facebook to stay updated.

Stay aware and get our best content on health, celebrity, travel, living, career and the technologies that will change the world.