Advertisement
Online Test Banks
Score higher
See Online Test Banks
eLearning
Learning anything is easy
Browse Online Courses
Mobile Apps
Learning on the go
Explore Mobile Apps
Dummies Store
Shop for books and more
Start Shopping

Moving Excel 2010 Data from Rows to Columns and Back Again

In Excel 2010, you can transpose worksheet data if you want to change the data structure so that the row headings appear as column headings, or vice versa. Excel 2010 provides the Transpose command in the Paste drop-down menu to simplify this procedure. Follow these steps to transpose data in Excel 2010:

  1. Select the cells you want to transpose.

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

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

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

  3. 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.

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

    A menu of options appears.

  5. Choose Transpose, and then press Esc to cancel the marquee.

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

    image0.jpg
blog comments powered by Disqus
Advertisement
Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win an iPad Mini. Enter to win now!