Excel 2010 Just the Steps For Dummies
Book image
Explore Book Buy On Amazon

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.


About This Article

This article is from the book:

About the book author:

Diane Koers owns and operates All Business Service, a software training and consulting business formed in 1988, that services the central Indiana area. Her area of expertise has long been in the word-processing, spreadsheet, and graphics areas of computing. She also provides training and support for Peachtree Accounting Software. Diane's authoring experience includes over 40 books on topics, such as PC security, Microsoft Windows, Microsoft Office, Microsoft Works, WordPerfect, Paint Shop Pro, Lotus SmartSuite, Quicken, Microsoft Money, and Peachtree Accounting. Many of these titles have been translated into other languages, such as French, Dutch, Bulgarian, Spanish, and Greek. She has also developed and written numerous training manuals for her clients.
Diane and her husband enjoy spending their free time fishing, traveling, and playing with their four grandsons and their Yorkshire Terrier.

This article can be found in the category: