Excel这6个选取性粘贴小技巧，太实用了，职场必须！
<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;">在<span style="color: black;">平常</span>工作中，<span style="color: black;">咱们</span>比较习惯<span style="color: black;">运用</span>【Ctrl+C】和【Ctrl+V】这两个快捷键进行复制粘贴内容。<span style="color: black;">然则</span>，今天跟<span style="color: black;">大众</span>分享的是WPS中6个<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>快速进行加减乘除运算</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>600</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;">先复制D2单元格中的数据（高温<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-axegupay5k/f17d46a926e944a49434c76f009054a3~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727983814&x-signature=5a30LwDRQuuA8BumOrmPvXa6484%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>
<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;">如下图所示，左侧是<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>复制过去。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/42a3e01b7bd549de9a788d6a2c09ab41~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727983814&x-signature=PR%2Fmg95pxRdlWe%2F0wj8IzXhRHbM%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;">办法</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;">第1</span>个单元格数据区域→点击【右键】选中【粘贴为数值】<span style="color: black;">就可</span>。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p26-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/a4cd13cc587e485ba7f472b36f3c7b50~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727983814&x-signature=4fm3wcDd5p4gKzWsftuPmTVfrmA%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>粘贴为公式</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>公式计算出来的，右侧的表格只需要<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;"><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;">第1</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-6w9my0ksvp/36bc702f08c546068e948fcba0bdeaec~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727983814&x-signature=Saumz9jq9QMWZEgT%2F2B8pJj6xy8%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;"><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-6w9my0ksvp/38e63faef80c485aad176bdbf6a77bfe~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727983814&x-signature=6%2FGtGVlcwE7nMFRqpxa1ntO1Hko%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;">办法</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;">第1</span>个单元格，点击【右键】选中【<span style="color: black;">选取</span>性粘贴】→在弹出的“<span style="color: black;">选取</span>性粘贴”对话框中的【运算】勾选【减】，最后点击确定<span style="color: black;">就可</span>。<span style="color: black;">这般</span>的话，结果不是0的数据<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-6w9my0ksvp/96a76196c5cf45a7b2967da77227b5e2~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727983814&x-signature=MU460xobXuu7GgNc2ZU%2BwGyw0%2Bc%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;">如下图所示，<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>性粘贴】→在弹出的“<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-6w9my0ksvp/37101e208d1248428a70750fa2e4b53f~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727983814&x-signature=BbPff1HavAQsAzq70bYU54cIkx4%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>跳过空单元格粘贴</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>，有的保持不变。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/5069d0098219401eb6a6d80eaa7eb41e~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727983814&x-signature=wNJwmrenFRxCIXhXHEraUsPMDvM%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;">办法</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>性粘贴”对话框中勾选【跳过空单元】，最后点击确定<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-6w9my0ksvp/0049d75a117243889154a95ea68c8a44~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727983814&x-signature=mz7ViCO%2FV9n2LG7WozoU4G%2FjKss%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>
你的见解真是独到，让我受益良多。 感谢楼主的分享！我学到了很多。 感谢你的精彩评论，带给我新的思考角度。 “沙发”（SF，第一个回帖的人）
页:
[1]