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>为你分享职场办公软件<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;">微X</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>还需要给<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>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-axegupay5k/2a51fd17ef814e27afe8bc6b3d74c521~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727984692&x-signature=5kmbfeR4ZGS28gZh6Us2rLO2R%2Fo%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 style="color: black;">办法</span>：</span></strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">1、先建一个辅助列，<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/74f0a45e95474c288a54315a1792cef8~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727984692&x-signature=qXiJRu82taHkyrGfzL3rmvgLTM0%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>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/ce61f1102b8f45e8a44818d8bd413f74~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727984692&x-signature=pJFto8Yy%2FUwfGlSQ1Kx1h76MEvo%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">3、再单击任意一个序号单元格，在【<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/88c4e298ab8f4faeae304be2fac412d9~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727984692&x-signature=dvmQaju03E8Ddrqk%2BvcRYZmbZDA%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>有什么问题欢迎关注留言，期待与你的每一次互动，让<span style="color: black;">咱们</span><span style="color: black;">一起</span>成长！</p>
外链发布社区 http://www.fok120.com/ 这篇文章真的让我受益匪浅，外链发布感谢分享！ “板凳”（第三个回帖的人）
页:
[1]