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><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/89eafd797ea34c769e1d799560206deb~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727984708&x-signature=3Q57DhfX5fx9OYjgky1JnqLYQjo%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>想要制作成工资条。</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>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/611c00c2e526451eaf47a0139fc69b7f~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727984708&x-signature=Qs%2B2rRPnYGc7fhdZhliAExPpUQ8%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">在辅助列中，输入序号，下拉填充至表格底部，为要制作工资条的人员先排个序。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/6fba7925067d4fe790eac65287d551f5~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727984708&x-signature=Og4yt%2FGgjrosHAoMrl6uoLlZ7Bo%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 style="color: black;">（快捷键ctrl+c）</span></span><span style="color: black;">所有</span>序号，粘贴<span style="color: black;"><span style="color: black;">（快捷键：ctrl+v）</span></span>到下方表格。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p26-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/7b345878152f46fcaf03933a716715d6~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727984708&x-signature=FXiwN%2F5fCQYY4rqrGlAMep4GnE0%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">选中表头复制，粘贴到下方表格。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/873d651f597f4132a85ba6a4f7ed17ee~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727984708&x-signature=XiFo3hvyLYQ6PH3lJX%2BpqvmBXHA%3D" style="width: 50%; margin-bottom: 20px;"></div>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p9-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/c7935c1f96ed471380112be34759f9ba~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727984708&x-signature=VWeSg23rCzORxtOPOhwUnDrsLfM%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">选中粘贴后的表头，ctrl+d，向下填充。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/e5918873bae44cb7a9fc1b1e30b58db4~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727984708&x-signature=72XLzS2O8WbUSJQLsjg3yPyuBeI%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">点击辅助列的序号。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/c1100682fccb412a984d35408d1c5137~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727984708&x-signature=ZipxqP0Pd1kUNI1sXCt35gxjuDc%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>选项卡】--【排序】--【升序】</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/f081c3bb383247808c2ef4868dc894f9~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727984708&x-signature=2o%2FdNo8rfb6QdRqY8PHVqhbiFy8%3D" style="width: 50%; margin-bottom: 20px;"></div>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/844e7545370d4498a00c9772ba2d47f2~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727984708&x-signature=OtHvaAoOn%2B7jUXR8mJbkF9LmXlk%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>。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">选中辅助列，鼠标右击，点击删除，工资条完工。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/1941b3a28ada47f7b0919093d2f05f93~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727984708&x-signature=3HaefbMHg3NNUWPvLMscOVTzl08%3D" style="width: 50%; margin-bottom: 20px;"></div>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/3303c5eda3cc45718999a52907ede02b~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727984708&x-signature=lsL2U6G9nwvZXgXaT%2Frw2cdqvRY%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 style="color: black;">今天的分享到此结束，<span style="color: black;">连续</span>更新中，如有问题<span style="color: black;">能够</span>私信<span style="color: black;">或</span>评论区留言。</span></span></p>
这篇文章真的让我受益匪浅，外链发布感谢分享！
页:
[1]