![](https://i-blog.csdnimg.cn/blog_migrate/2c7ab85f9e3cc1c095f8e23f90559c84.png)
You’ve set up a worksheet, when you realize it would look better if the rows and columns were reversed. There’s no need to re-enter all that data. Just use Excel’s Transpose feature.
您已经建立了一个工作表,当您意识到将行和列颠倒后看起来会更好。 无需重新输入所有数据。 只需使用Excel的转置功能。
Select the cells containing the headings and data you want to transpose.
选择包含要转置的标题和数据的单元格。
![](https://i-blog.csdnimg.cn/blog_migrate/47ffa9623b94491f5ec2313336e8f8d7.png)
Click the “Copy” button or press Ctrl+C to copy the selected cells.
单击“复制”按钮或按Ctrl + C复制所选的单元格。
![](https://i-blog.csdnimg.cn/blog_migrate/1528b57e008705a1d6750f7134f3274b.png)
Click a blank cell where you want to copy the transposed data. The cell you select becomes the top, left corner of whatever you’re copying.
单击要复制转置数据的空白单元格。 您选择的单元格将成为您要复制的内容的左上角。
![](https://i-blog.csdnimg.cn/blog_migrate/3a081e1f52ba2636b514fff6c1476a0c.png)
Click the down arrow under the “Paste” button, and then click the “Transpose” button on the dropdown menu.
单击“粘贴”按钮下的向下箭头,然后单击下拉菜单上的“移调”按钮。
![](https://i-blog.csdnimg.cn/blog_migrate/ad8a82a97258aea2efc1ccd9935da185.png)
Just like that, your rows become columns and your columns become rows—complete with any formatting you’d already applied to the original selection.
就像这样,您的行变成了列,而您的列变成了行-完成所有已经应用于原始选择的格式。
![](https://i-blog.csdnimg.cn/blog_migrate/c6a03edb069cdb44c63cdb4c489d0825.png)
Note that your original, pre-transposed data still exists. You can select those cells again, and delete them if you want.
请注意,原始的,预先转置的数据仍然存在。 您可以再次选择这些单元格,然后根据需要将其删除。
It’s a quick trick, but it sure is a lot quicker and easier than retyping all your data and formatting those rows again.
这是一个快速的技巧,但是与重新键入所有数据并再次格式化这些行相比,它肯定会更快,更轻松。
翻译自: https://www.howtogeek.com/howto/12366/convert-a-row-to-a-column-in-excel-the-easy-way/