How can I transpose text in Excel?

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Topics » How can I transpose text in Excel?

How can I transpose text in Excel?

Most often, data in Excel is entered in columns. Sometimes, however, you may wish to use a column of data and place it into a row so that the data goes across the sheet as opposed to going down the sheet.

Excel provide a very simple solution called Transpose.

First of all select the data you wish to transpose, copy the selected range then select a blank cell which will be the starting point for the paste (your paste region cannot start in the same cell as your copy region).

Now click the paste drop down arrow and click the tranpose button which is found in the 2007 and 2010 versions (for earlier versions use the Edit menu, Paste Special then select Tranpose and click OK). Your data will now appear in a row starting from the cell you chose to begin the paste.

This method saves an amazing amount of time. If the transpose solution wasn't available then you would have had to copy then paste each individual cell in the list.

Related forum posts:

Paste special

Would like a recap on the Paste Special function

Read forum post


shrinking lots of coulumns and enlarging text

Eg if you have 50+ columns and only 3 rows, is there a way to get this printed on to an A3 sheet at a readable size... i hope that makes sense

Read forum post



Training courses


Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Server loaded in 0.05 secs.

✓ w3speedster