98.1 % recommend us More live stats... RSS feeds What's this? All hints and tips:

Hints and tips home » Excel hints and tips » Transpose text

Transpose text

You can transpose any range of cells, turning the columns into rows and the rows into columns. Just follow these steps:

Select the range.

Click the Copy button on the Standard toolbar to copy it to the Clipboard.

Select a cell outside of the range you copied.

Select Paste Special from the Edit menu.

In the Paste Special dialog box, click Transpose, then OK.

Added by Meenesh on 3rd October 2006

More Excel hints and tips, like:

• Hide columns in an Excel 2010 Worksheet
• Customize the toolbar in Excel 2010
• Separate the year from a date