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!