如何把excel行列对调
1. 框选表格
框选需要的表格。
https://exp-picture.cdn.bcebos.com/1562a0b9763e21c24dd50e66e6e89a618625b15e.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1%2Fformat%2Cf_auto%2Fquality%2Cq_80
2. 点击复制
用鼠标右键点击【复制】。
https://exp-picture.cdn.bcebos.com/777f3fc2bbd6e1d095eb75d70d254193cee8af5e.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1%2Fformat%2Cf_auto%2Fquality%2Cq_80
3. 选中单元格
选中需要粘贴的单元格。
https://exp-picture.cdn.bcebos.com/bff8683e21c2bbd616d3825e116186254193ae5e.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1%2Fformat%2Cf_auto%2Fquality%2Cq_80
4. 点击选择性粘贴
用鼠标右键点击【选择性粘贴】。
https://exp-picture.cdn.bcebos.com/2083a5d6e1d06de863626993ca93cee8b004ac5e.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1%2Fformat%2Cf_auto%2Fquality%2Cq_80
5. 勾选转置
弹出窗口框，勾选【转置】。
https://exp-picture.cdn.bcebos.com/ba97ffd06de89a617c26ae2545e8b004541bad5e.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1%2Fformat%2Cf_auto%2Fquality%2Cq_80
6. 点击确定
点击右下角的【确定】。https://exp-picture.cdn.bcebos.com/e09173e89a618625ba90215e3b04541bd10faa5e.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1%2Fformat%2Cf_auto%2Fquality%2Cq_80
7. 操作完成
excel行列对调操作完成。
https://exp-picture.cdn.bcebos.com/6ca984618625419332eb5fb2df1bd10ff226ab5e.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1%2Fformat%2Cf_auto%2Fquality%2Cq_80
页:
[1]