How to convert a horizontal table into a vertical table in Excel
- 王林Original
- 2020-02-29 17:11:4011955browse
First, we need to select the first cell A1, and then press the shortcut key "Ctrl A" to select the entire table. Select the entire table and press Ctrl C to copy the table.
The second step is to create a new worksheet, click on cell A1 of this new worksheet, right-click the mouse and select "Paste Special" in "Paste Special" ".
#The third step, after clicking, a new "Paste Special" dialog box will pop up. We select "Transpose" at the bottom. Then click OK.
More related tutorial recommendations: excel tutorial
The above is the detailed content of How to convert a horizontal table into a vertical table in Excel. For more information, please follow other related articles on the PHP Chinese website!
Statement：
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
Previous article：When opening a file in excel, it shows no responseNext article：When opening a file in excel, it shows no response