ARCHIVED: In Microsoft Excel, how do I turn a row into a column or vice versa?
In an Excel worksheet, you can use the Paste Special function to cut and paste data from a row to a column or from a column to a row:
- Select the data cells you want to switch. You can select the whole
row or column if you wish.
- In Office 2010 or 2007, in the
Hometab, in the "Clipboard" section, selectCopy.In earlier versions, from the
Editmenu, selectCopy. - Select the upper left cell of the paste area. The paste area must
be outside the area containing the data you want to switch. For
example, if you are switching data in a column in cells A1 through A5,
the paste area cannot overlap with any cells in A1 through A5. One
possibility in that case is to use B1 through F1 for the paste area;
to do that, you would select cell B1.
- In Excel 2010 or 2007, from the
Hometab, see the "Clipboard" section. Click the arrow below "Paste", and then choosePaste special.In earlier versions, from the
Editmenu, selectPaste Special. - The
Paste Specialdialog box will open. SelectTranspose, and then clickOK.
The information in this document is adapted from the Excel help files.
This is document akwu in domain all.
Last modified on July 03, 2012.
Last modified on July 03, 2012.
