Editing Records in an Excel 2007 Table
Using Drag and Drop in Excel 2007
Splitting Data into Multiple Columns in Excel 2007

Transposing Data in Excel 2007

While creating a Microsoft Office Excel 2007 worksheet, you may decide to change the data structure so that the row headings appear as column headings, or vice versa. Excel 2007 provides the Transpose command to simplify this procedure. Follow these steps to transpose data in Excel 2007:


Select the cells you want to transpose.

You can select data contained in a row, column, or a block of data.


Click the Copy command button in the Clipboard group of the Home tab.

The Transpose feature will not work if you choose Cut instead of Copy.


Click the cell where you want the transposed cells to begin.

Keep in mind that any data you paste here will automatically overwrite the data that is currently there.


Click the down arrow below the Paste command button on the Home tab.

A menu of options appears.


Choose Transpose.

Excel copies the selected cells into the new area, transposing rows into columns or columns into rows.

  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus
Comparing Two Excel 2007 Worksheets Side by Side
Annotating with Text Boxes in Excel 2007
Automatically Fix Typos and Add Text with Excel 2007's AutoCorrect Feature
Advanced Find and Replace in Excel 2007
How to Check Your Spelling in Excel 2007

Inside Dummies.com