Excel技巧：Excel表格行列互换办法总结
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">Excel文件中的表格想要行列互换，<span style="color: black;">亦</span><span style="color: black;">便是</span>行变成列、列变成行，想要实现这个操作，有两种<span style="color: black;">办法</span><span style="color: black;">能够</span>做到，<span style="color: black;">一块</span>来学习一下吧！</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>一：</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">选中表格，复制，<span style="color: black;">选取</span>一个位置，点击单元格</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="//q6.itc.cn/images01/20240923/4f5cda2ff82047998bb90e60e5eccc05.png" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">在单元格粘贴，<span style="color: black;">然则</span><span style="color: black;">这儿</span>是点击右键，点击<span style="color: black;">选取</span>性粘贴，打开对话框</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="//q9.itc.cn/images01/20240923/7f817c9e7b564241a3103972def4dc11.png" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">在对话框中，勾选上转置，点击确定</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="//q1.itc.cn/images01/20240923/eb8d2eda1d954a079e8707c60647bae3.png" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">之后<span style="color: black;">咱们</span>就<span style="color: black;">能够</span>看到表格<span style="color: black;">已然</span>从五行四列变为了四行五列，<span style="color: black;">这儿</span>需要<span style="color: black;">重视</span><span style="color: black;">有些</span>问题：</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">行引用到列、列引用到行，<span style="color: black;">这般</span>转置会失败</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">表格中有函数计算出来的值，<span style="color: black;">倘若</span>数值<span style="color: black;">再也不</span>变化的话，将单元格格式设置为数值再进行转置。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="//q0.itc.cn/images01/20240923/8f2304f861ec4cd5848f4d968532c49d.png" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>二：</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">第二个<span style="color: black;">办法</span>，需要用到函数，<span style="color: black;">咱们</span>先将表格行列互换后的范围在旁边框出来，<span style="color: black;">而后</span>输入TRANSPOSE公式，公式中是原表格的区域</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="//q5.itc.cn/images01/20240923/a908f23cdd2c43b4b977d9bd8f08426f.png" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">最后需要<span style="color: black;">同期</span>按住Ctrl + Shift + Enter来完成行列互换。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="//q2.itc.cn/images01/20240923/0a0faf1135964b55a9958b0c1b51d6b2.png" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">倘若</span>遇到了<span style="color: black;">没法</span>编辑的excel工作表，<span style="color: black;">咱们</span>先查看一下功能栏中的按钮<span style="color: black;">是不是</span>都是灰色的，<span style="color: black;">倘若</span>是，<span style="color: black;">咱们</span>只需要撤销工作表<span style="color: black;">守护</span><span style="color: black;">就可</span>正常编辑了。忘记<span style="color: black;">秘码</span><span style="color: black;">或</span>不<span style="color: black;">晓得</span><span style="color: black;">秘码</span>的<span style="color: black;">状况</span>，<span style="color: black;">能够</span><span style="color: black;">运用</span>excel辅助工具<span style="color: black;">帮忙</span><span style="color: black;">咱们</span>完成，不需要找回<span style="color: black;">秘码</span>，一键撤销<span style="color: black;">守护</span>。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="//q6.itc.cn/images01/20240923/17419ab88d35440c952e230a2a0a38a5.png" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">以上<span style="color: black;">便是</span>excel表格行列互换的两种<span style="color: black;">办法</span>，<span style="color: black;">根据</span><span style="color: black;">过程</span>操作就<span style="color: black;">能够</span>实现，<span style="color: black;">期盼</span><span style="color: black;">能够</span>在工作学习中<span style="color: black;">帮忙</span>到<span style="color: black;">大众</span>。<a style="color: black;"><span style="color: black;">返回<span style="color: black;">外链论坛： http://www.fok120.com</span>，查看<span style="color: black;">更加多</span></span></a></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">责任编辑：网友投稿</span></p>
外链发布社区 http://www.fok120.com/ 你的话语真是温暖如春，让我心生感激。
页:
[1]