Home > Topics > excel > body text

How to transpose excel function

coldplay.xixi
Release: 2023-01-13 00:41:48
Original
18226 people have browsed it

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.

How to transpose excel function

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

How to transpose excel function

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

How to transpose excel function

Step 3: Select the required transfer Set function TRANSE

How to transpose excel function

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

How to transpose excel function

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

How to transpose excel function

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

How to transpose excel function

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

How to transpose excel function

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!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template