How to transpose excel function

How to transpose excel function: First select the required transpose function TRANSE and click OK; then select the matrix that needs to be transposed and hold down "Ctrl Shift Enter" at the same time; finally again Press and hold "Ctrl Shift Enter" at the same time.

The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

How to transpose excel function:

Step 1: Select the area to be used to generate the transposed result

Step 2: Click on fx pointed by the red arrow in the above picture, the function selection box below will pop up

Step 3: Select the required transfer Set function TRANSE

Step 4: After clicking "OK", enter the following interface

Step 5: Click the icon pointed by the red arrow in the picture above, and select the matrix that needs to be transposed

Step 6: Press and hold "Ctrl Shift Enter" at the same time, return to the following Interface

Step 7: Press and hold "Ctrl Shift + Enter" at the same time again to get the transposition result

Related learning recommendations: excel tutorial

The above is the detailed content of How to transpose excel function. For more information, please follow other related articles on the PHP Chinese website!