超快超好 快速生成工资条
点击上方“办公便签”<span style="color: black;">能够</span>订阅哦<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">工资条有木有？<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></p><p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><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></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz_png/oEa6JVrwqViagteGzvHbFQgvBamBxicibEJxPeWbKbw9uPDsZndXq7j9VnRrmHQk5oCSmHD4DEnCpOKm8y4Z37XyQ/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" 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></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz_png/oEa6JVrwqViagteGzvHbFQgvBamBxicibEJIg4h4aBaPCegLZ5ibS3taw6VgB84AuCNlAWFWOxPiaYVUZRxgTRwlQHQ/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" 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 style="color: black;">而后</span>批量选中下方空白区域，执行粘贴命令，填充至下方的空白区域，粘贴的区域要与第二组辅助列的行数保持一致。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz_png/oEa6JVrwqViagteGzvHbFQgvBamBxicibEJmcoFg2WdicdJjczXficPTaiaNLg8RPaE9DF9NOSM85B1dAyG0Yia6hEISw/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" 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 style="color: black;">按照</span>辅助列G执行表格升序<span style="color: black;">摆列</span>：点击<strong style="color: blue;">“数据→排序”</strong>命令，<span style="color: black;">选取</span>主关键字为<strong style="color: blue;">“列G”</strong>，排序<span style="color: black;">秩序</span>为<strong style="color: blue;">“升序”</strong>，点<strong style="color: blue;">“确定”</strong>排序。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz_png/oEa6JVrwqViagteGzvHbFQgvBamBxicibEJjfKF86JlToXWqnZbm1icdwJwnvfUherRBAibk3smuJxPc4seuECgIZ4A/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" 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 style="color: black;">便是</span>如图酱紫的，是不是你想要的呢？</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz_png/oEa6JVrwqViagteGzvHbFQgvBamBxicibEJLo6xKgdGTHQ8PcVGaxV5yKoRwv8ichzWvL8ouaIc5dDs0yoibmFxQCMg/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" 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;">最后删掉辅助<strong style="color: blue;">列G</strong>。打印出来后，按每两行一条剪开，就<span style="color: black;">能够</span>发给员工了。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">明白的上面的做法后，不管你遇到的工资项目有多少项，员工有多少名，都<span style="color: black;">能够</span>按这种<span style="color: black;">办法</span>一次性搞定，所需时间基本上是<span style="color: black;">同样</span>的。</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;"><img src="http://mmbiz.qpic.cn/mmbiz/oEa6JVrwqVia1ECJ28NcCvTCdlGn8l5vqKzQlzmmLqdHX6sVp5L7e1plSb1sWFia50YRMJ52r6j1IeatTIkYUHBg/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>点击下方“阅读原文”查看<span style="color: black;">更加多</span><img src="http://mmbiz.qpic.cn/mmbiz_gif/oEa6JVrwqViagteGzvHbFQgvBamBxicibEJBRYZEKmgUxMUhwnJKxszq7FpV6UEEScoeAktticbc6GnUhiaGruWYAmA/0?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1" style="width: 50%; margin-bottom: 20px;">
“板凳”（第三个回帖的人）
页:
[1]