8个Excel常用技巧，动图演示，让你从“小白”变“大神”！
<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;"><span style="color: black;">针对</span><span style="color: black;">非常多</span>新晋职场的小伙伴<span style="color: black;">来讲</span>，<span style="color: black;">由于</span>对WPS办公软件不太<span style="color: black;">熟练</span>，遇到处理Excel数据时就手忙脚乱。今天就跟<span style="color: black;">大众</span>分享WPS中8个Excel常用技巧,动图演示，让你从“小白”变“大神”！学会后<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;">1、</span>快速<span style="color: black;">转</span>到表格最后一行</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">1、新手做法</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">经过</span>拖动上下滚动条，直到拖拽到最后一行</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/323815739e4049679239bd30d0205954~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727969978&x-signature=JMcehPaUc%2F%2FTFkaqFItLVSd0w1Y%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">2、<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;">①双击【下边框】，就<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;">第1</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>快速定位到表格最左边；</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/893682bdbaf842c680c014ea16a09a40~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727969978&x-signature=gEVsiM8Lm%2Frr4lO%2BFZqq3wFQJz4%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">2、</span>快速复制上一行内容</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">1、新手做法</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>快捷键【Ctrl+C】复制，<span style="color: black;">而后</span><span style="color: black;">经过</span>快捷键【Ctrl+V】粘贴</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">2、<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>会利用快捷键【Ctrl+D】，<span style="color: black;">首要</span>用鼠标选中下一行单元格→<span style="color: black;">而后</span>按快捷键【Ctrl+D】，就<span style="color: black;">能够</span>完成快速复制上一行内容了。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/f2f197e42c894dc8acc19592c25ce16c~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727969978&x-signature=W6dBSXijV7%2FDtcKOBLAQEI4C7hU%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">3、</span><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;">1、新手做法</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>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/0a3d372d0dc64cbcbfdc061c776aca9c~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727969978&x-signature=mdl50BYYnrucG68rrNG5bm8x5kY%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">2、<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>用快捷键【Ctrl+A】选中所有数据，<span style="color: black;">而后</span>把光标放到列表间隔处，当光标变成带<span style="color: black;">上下</span>箭头的十字型时，双击<span style="color: black;">就可</span><span style="color: black;">调节</span>到最适合的列宽</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/0a830dfef6b8454da49c917c42781360~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727969978&x-signature=DSPuGHefccY3hjEp8fixTkk7znk%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">4、</span>为表格中分散的空单元格快速填充相同内容</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">1、新手做法</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;">2、<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>快捷键【Ctrl+G】打开“定位”对话框→<span style="color: black;">选取</span>[空值]→[输入内容]→最后按组合键【Ctrl+Enter】<span style="color: black;">就可</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/c8d71c1da22a4eb4884ee07f82f693d0~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727969978&x-signature=%2FOGT4jHqwYRwpZA%2BwaAy5bp4KV0%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">5、</span>复制后的表格保持列宽不变</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">1、新手做法</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>列宽</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">2、<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>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/c3b022c0c69942b2b83fa935a9cd5419~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727969978&x-signature=RITu4kXfhQHIJdVqtRtQAPU1qLw%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">6、</span><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>”这两列调换一下位置。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">1、新手做法</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>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/72ab6d5afd25463c9a16da6104165d91~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727969978&x-signature=fU42zuTTPOCsRvG4yA90u6cMKvE%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">2、<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>】这一列放到【等级】这一列左侧，先选中【<span style="color: black;">分部</span>】这一列→按着【Shift】键→把鼠标放到单元格<span style="color: black;">上下</span>任意边框→当光标变成十字型时按住鼠标左键往左拖拽<span style="color: black;">就可</span>。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/d9ed9cf7009445f496bab3e90ad9efd1~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727969978&x-signature=t%2BbtzlOz%2Bujo6%2FmTpWKj3alR0OE%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">7、</span>快速复制一列数据</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">1、新手做法</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>再粘贴数据。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">2、<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>直接按快捷键【CTRL+R】就<span style="color: black;">能够</span>自动复制类数据了。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/c9f2c1993804483ea3d411d704736a0e~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727969978&x-signature=wDNSoYj6OiWEs4ZBdXxes7xkBz4%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">8、</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;">tel</span>成两列数据，</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/8c3f1364f83a4cb8be00ef39dd0318b3~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727969978&x-signature=Kl8z68i8ufzIKuhNkUEDTuee2OU%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">1、新手做法</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;">2、<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>会<span style="color: black;">运用</span>快捷键【Ctrl+E】（快速填充数据），<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;">第1</span>个空格）最后按一下快捷键【Ctrl+E】就<span style="color: black;">能够</span>快速拆分填充数据了。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/df21a540d1b1446399d1a0bd2a0906a4~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727969978&x-signature=RY8bjEJORSd7Dxnbi4i48SI4Omg%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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>
感谢你的精彩评论，为我的思绪打开了新的窗口。 你的话语如春风拂面，让我感到无比温暖。 你的话语如春风拂面，温暖了我的心房，真的很感谢。
页:
[1]