Scribd
Upload
2 views4 pages

MS Excel Transpose Function

The Transpose function in Excel allows users to switch the orientation of a range of cells, converting vertical ranges to horizontal and vice versa. It requires the range to be entered as an array using Ctrl-Shift-Enter. Alternatively, users can use the Paste Special option for a one-time transpose of values.

Uploaded by

cedubai3
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
2 views4 pages

MS Excel Transpose Function

The Transpose function in Excel allows users to switch the orientation of a range of cells, converting vertical ranges to horizontal and vice versa. It requires the range to be entered as an array using Ctrl-Shift-Enter. Alternatively, users can use the Paste Special option for a one-time transpose of values.

Uploaded by

cedubai3
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

MS Excel: Transpose Function

In Excel, the Transpose function returns a transposed range of cells. For example, a horizontal range of cells is returned if a vertical
range is entered as a parameter. Or a vertical range of cells is returned if a horizontal range of cells is entered as a parameter.

The syntax for the Transpose function is:

Transpose( range )

range is the range of cells that you want to transpose.

Note:

 The range value in the Transpose function must be entered as an array. To enter an array, enter the value and then press
Ctrl-Shift-Enter. This will place {} brackets around the formula, indicating that it is an array.

Applies To:

 Excel 2007, Excel 2003, Excel XP, Excel 2000

For Example:

Let's take a look at an example:

Based on the Excel spreadsheet above:

We've placed values in cells A1, A2, and A3, and we'd like to view these values in cells C1, D1, and E1 (transposed). To do this,
you highlight cells C1, D1, and E1, then enter the following formula:

=TRANSPOSE(A1:A3)

Then press Ctrl-Shift-Enter to create an array formula. You will notice that {} brackets will appear around the formula and the values
in cells A1, A2, and A3 should now appear in cells C1, D1, and E1.
Frequently Asked Questions

Question: In Excel, isn't it easier to use the Paste Special transpose option to do the same?

Answer: Yes, if you ONLY want to perform a one-time paste of the values, you can do the following:

Highlight the cells that you want to copy. In this example, we've highlighted cells A1:A3. Then right-click and select Copy from the
popup menu.
Then right-click on the cell where you'd like to paste the values and select Paste Special from the popup menu.

Then select the Transpose checkbox and click on the OK button.


Now when you return to your spreadsheet, you'll see that the values have been copied and transposed.

You might also like