如何在MS Excel中将列转置为行 [英] How to transpose a column into a row in ms excel
本文介绍了如何在MS Excel中将列转置为行的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我试图在MS Excel工作表中将一列转置为行,该怎么办?我们有执行此操作的命令吗?请帮助我.谢谢.
I am trying to transpose a column into row in ms excel sheet.How can I do that? Do we have any command for doing this?Please help me.Thank you.
推荐答案
复制要转置的数据单击要开始转置数据的单元格(行A的列?)单击主菜单,然后单击粘贴箭头(更多选项)然后选择转置"
Copy the data you want to transpose click on the cell you want the transposed data to start in (column A in the row?) click on the Home menu, then on the paste arrow (for more options) Then choose Transpose
这是您想要的还是正在寻找VBA解决方案?
Is this what you want or is there a VBA solution you are looking for?
这篇关于如何在MS Excel中将列转置为行的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文