Excel教程：一个最快捷的工资条制作办法
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_gif/XVayrImXFrNLgYP93SiczibW2ibu2fibd6Via7NYQv1XTOh7Uib6zs4abehXSiamECXF5QWzgY5IBpQhic5MqGgo5oSjpQ/640?wx_fmt=gif&wxfrom=5&wx_lazy=1&tp=webp" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_png/bePCGbRich1E0WNKTSF0wICRHBmuy34VYeBmEAeXJQN9kQzh6YHxQZ5mlWyPcMIrMRF6gxW7XRP60lr3vJl7Aiaw/640?wx_fmt=png&from=appmsg&wxfrom=5&wx_lazy=1&wx_co=1&tp=webp" style="width: 50%; margin-bottom: 20px;"></a></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><span style="color: black;"><span style="color: black;">非常多</span>小伙伴在</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 style="color: black;">平常</span>做法是VBA编程或启用宏，</span><span style="color: black;"><span style="color: black;">或</span>应用函数，</span><span style="color: black;">那有没其他的</span><span style="color: black;">的</span><span style="color: black;"><span style="color: black;">办法</span>呢？有的</span><span style="color: black;">。</span><span style="color: black;">今天</span><span style="color: black;">小爱</span><span style="color: black;">就抛砖引玉，给<span style="color: black;">大众</span>分享</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 style="color: black;">办法</span></span><span style="color: black;">（添加辅助列）</span><span style="color: black;">，<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><span style="color: black;"><span style="color: black;">咱们</span>先在</span><span style="color: black;">J</span><span style="color: black;">2、</span><span style="color: black;">J</span><span style="color: black;">3单元格手动输入1、2。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/XVayrImXFrOqiaicJn0Qib9rCMjcAPw4MicFicI6pnhKVDxFib2U1yU0EmbyKibZmHqrjQ3via0ia47snPoGSwrrI8ObHhQ/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p><span style="color: black;">然后选中</span><span style="color: black;">J</span><span style="color: black;">2</span><span style="color: black;">:J</span><span style="color: black;">3单元格区域，将鼠标<span style="color: black;">安置</span>在</span><span style="color: black;">J</span><span style="color: black;">3单元格右下角，双击向下填充。<span style="color: black;">能够</span>看到如下结果。</span>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/XVayrImXFrOqiaicJn0Qib9rCMjcAPw4MicF5iaNxWwCaFvfXpaibs7U2rXdMVr5IwEhwRKicWGBadia0el9t4OT9Nticvw/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;">选中A1:</span><span style="color: black;">I1单元格</span><span style="color: black;">，</span><span style="color: black;">按</span><span style="color: black;">ctrl+c</span><span style="color: black;">复制区域，<span style="color: black;">而后</span>点击</span><span style="color: black;">A20</span><span style="color: black;">单元格，按</span><span style="color: black;">ctrl+V</span><span style="color: black;">粘贴，</span><span style="color: black;">复制下拉A20:</span><span style="color: black;">I20单元格</span><span style="color: black;">到A35:I35单元格，</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="https://mmbiz.qpic.cn/mmbiz_gif/XVayrImXFrOqiaicJn0Qib9rCMjcAPw4MicFvpds7enyhV3tFPtqYMjQNDia1TQTpBgp70wMdC7LyPnO4HyBcAOpDHg/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=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><span style="color: black;">J</span><span style="color: black;">2</span><span style="color: black;">0</span><span style="color: black;">、</span><span style="color: black;">J</span><span style="color: black;">21</span><span style="color: black;">单元格手动输入1</span><span style="color: black;">.5</span><span style="color: black;">、2</span><span style="color: black;">.5</span><span style="color: black;">，</span><span style="color: black;"><span style="color: black;">而后</span>选中</span><span style="color: black;">J20</span><span style="color: black;">:J21</span><span style="color: black;">单元格区域，将鼠标<span style="color: black;">安置</span>在</span><span style="color: black;">J21</span><span style="color: black;">单元格右下角，双击向下填充</span><span style="color: black;">，</span><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="https://mmbiz.qpic.cn/mmbiz_png/XVayrImXFrOqiaicJn0Qib9rCMjcAPw4MicFct9FzMafaDpbq0en3pTwowojSbGDnBnKBEibrv36SIDPxnjgEo0jHbg/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;">选中数据区域A</span><span style="color: black;">2:J35</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="https://mmbiz.qpic.cn/mmbiz_png/XVayrImXFrOqiaicJn0Qib9rCMjcAPw4MicF46sKAuRpuwXCoVOmjbTplMbZNgCvPJG2vgFf97fBWZG0PuNkgVUWFw/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 style="color: black;">选取</span>“（列</span><span style="color: black;">J</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="https://mmbiz.qpic.cn/mmbiz_png/XVayrImXFrOqiaicJn0Qib9rCMjcAPw4MicFjrnHAxvOslicU8WcBeJJh8sEPDMK7AGUjYUmwlsiafjYfNZIfWlKaOng/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="https://mmbiz.qpic.cn/mmbiz_png/XVayrImXFrOqiaicJn0Qib9rCMjcAPw4MicFgLIkINiaThicBhLVNalSEcOTd0KJl8Rq2A2icuoib3iamiaHqEqiadUibBISdA/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><span style="color: black;">J</span><span style="color: black;">列，点击“<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="https://mmbiz.qpic.cn/mmbiz_jpg/XVayrImXFrOqiaicJn0Qib9rCMjcAPw4MicFX70Hjav8sNWAxTzBr1kYtldpJ7T50fKqHfbPkCmblTdJFFqrYwAuzQ/640?wx_fmt=jpeg&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><span style="color: black;">J</span><span style="color: black;">2和</span><span style="color: black;">K</span><span style="color: black;">3单元格输入1</span><span style="color: black;">,</span><span style="color: black;">选中</span><span style="color: black;">J</span><span style="color: black;">2</span><span style="color: black;">:</span><span style="color: black;">K</span><span style="color: black;">3单元格区域，<span style="color: black;">而后</span>鼠标放在</span><span style="color: black;">K</span><span style="color: black;">3单元格右下角，双击填充。<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="https://mmbiz.qpic.cn/mmbiz_png/XVayrImXFrOqiaicJn0Qib9rCMjcAPw4MicF8kzsY5XJSzCJUXTKicBwCGhwtTiaEX1d2uTALzL49qQOmvBwpdTMXkeA/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><span style="color: black;">K</span><span style="color: black;">列数据，按</span><span style="color: black;">ctrl+G</span><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="https://mmbiz.qpic.cn/mmbiz_jpg/XVayrImXFrOqiaicJn0Qib9rCMjcAPw4MicFBPLExY24l2NFSCTFdk41l71y2A0RSlfAFIkicg5YSvyflFKGh6FHttQ/640?wx_fmt=jpeg&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="https://mmbiz.qpic.cn/mmbiz_png/XVayrImXFrOqiaicJn0Qib9rCMjcAPw4MicF89vk6MdIvP8bS5KoSmQsZ91Zau8R0uZH4ROdkdyCFibpTctgV5zcP9Q/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 style="color: black;">插进</span>”。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_jpg/XVayrImXFrOqiaicJn0Qib9rCMjcAPw4MicFSlh0jL5rh455ibAiaqfmpG3VVLylPib5uUwicgFC0G4pzDQukCD4C8S7EQ/640?wx_fmt=jpeg&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="https://mmbiz.qpic.cn/mmbiz_jpg/XVayrImXFrOqiaicJn0Qib9rCMjcAPw4MicFbPvMoW4blcsu7Yb0QBCHzpr1PnRsv8HhI5nWtqb3UT31CicBTNdzribA/640?wx_fmt=jpeg&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 style="color: black;">每一个</span>表头前面都有了空行</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="https://mmbiz.qpic.cn/mmbiz_png/XVayrImXFrOqiaicJn0Qib9rCMjcAPw4MicFCzgoE3BayhEUaCthKqAMnhxlbFIrNrc6ticYMOus1qIhNyhJUas7QhA/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;">删除J列、K列，</span><span style="color: black;">工资条的做好了，</span><span style="color: black;">可用于打印出来后裁剪</span><span style="color: black;">,</span><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="https://mmbiz.qpic.cn/mmbiz_png/XVayrImXFrOqiaicJn0Qib9rCMjcAPw4MicFPcib8NezZrzq73HlJk25GtASP5nOYauqzNoS55icStWVuBFRYLf2lHVQ/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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/gC0ymMIMUyEIdH7wShyXeFke9MkyDz8uOkYwfia7zaWkh1C0UPSibO9mJbDNJBaTaibdIJjBiawBonf3T6BLp4rVOw/640?wx_fmt=png&from=appmsg&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;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_png/bePCGbRich1E0WNKTSF0wICRHBmuy34VYeZBg49eW4OBN8pSRNvjemjq1h6Hd2HX6yib6iceUm74BWTWnN9oJJgZQ/640?wx_fmt=png&from=appmsg&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;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_png/bePCGbRich1E0WNKTSF0wICRHBmuy34VYn0R0X3F7GFRZSm1e7Da4V6DpPvgSUTxia4Sgib65Y345FDI6eXhNCoPQ/640?wx_fmt=png&from=appmsg&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;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"><strong style="color: blue;"><span style="color: black;">倘若</span>还有什么需要咨询的，联系<span style="color: black;">微X</span>客服18074746783</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="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">点击阅读原文<span style="color: black;"><strong style="color: blue;"><span style="color: black;">一键登录官网，海量视频vip任意学！(可试看)</span></strong></span></span></strong></span></p>
期待更新、坐等、迫不及待等。
页:
[1]