用Excel制作工资条的N种简单做法，速度GET！
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_gif/a3jzy4ibVheH4jDsy3MdeBHfm7n1P4j2jW1y8SxjMv99aXJamyzBc0Rs8x3wDef1ZWV57QOYibgTMV0HDM5LsUkw/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;">博主</span>为<span style="color: black;">大众</span>讲解用Excel制作工资条的几种<span style="color: black;">办法</span>，还等什么，<span style="color: black;">一块</span>吧！</p>
<strong style="color: blue;"><span style="color: black;">制作静态工作条</span></strong>
<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>吧</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;"> <span style="color: black;">办法</span>一：</strong></span>按图提示操作（注：<span style="color: black;"><strong style="color: blue;">辅助列名<span style="color: black;">叫作</span>自己命名</strong></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/O2WqpUicg9icDVsLCltwAHlfEIdyOicbwe5ZEXibFaSpia13MC2pJ8vbJwdalFFmTlaEt2UVygT8ve1NKJYBTkPE3qw/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/O2WqpUicg9icDVsLCltwAHlfEIdyOicbwe5r3liaImF3SgMrwPwREQmB03ibwUnQB6Oiciaqkvq4lontslMRX613dDggw/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;">“序列”</strong></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/O2WqpUicg9icDVsLCltwAHlfEIdyOicbwe5icr8J8eo9RTnkk3RRMXWro3dsjmcMqP28veZsvm8IuHw4ngJ8E9RJmQ/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;"><span style="color: black;">办法</span>2：</strong></span>A隔空行制作工资条<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/O2WqpUicg9icDVsLCltwAHlfEIdyOicbwe5ChxwicKGsicg8LmUglNP59bfMeibSDeoqbLbGBE4X2GZG0dUTctXI1VOQ/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/O2WqpUicg9icDVsLCltwAHlfEIdyOicbwe5tyt0btaBmJg4jkiav9r6ODDZic3wdcG8WunPFannsHgWxUxNhL3bMYRg/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;">最后工资条生成，如下，<strong style="color: blue;"><span style="color: black;">删除辅助列</span></strong><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/O2WqpUicg9icDVsLCltwAHlfEIdyOicbwe5QUQfg6ricLibhJZrghuY4YQW4gzztaxFG2sWg2KhE3ukicYdT5scibxdGA/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;">B.<span style="color: black;"><strong style="color: blue;">隔空行制作工资条，</strong></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;"><strong style="color: blue;"><span style="color: black;">第1</span>步：</strong></span>如图交叉借用辅助列，数字随便，选中辅助列，按快捷键F5,<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_png/O2WqpUicg9icDVsLCltwAHlfEIdyOicbwe5QyQus66Zib67b12ONNEzeQ7ZVhCuJgY6960cfYGEMDRdhhsRic8xiaMpw/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;"><strong style="color: blue;"><span style="color: black;">第二步：</span></strong>在辅助列选中单元格内（如图红色区域），右击，<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_png/O2WqpUicg9icDVsLCltwAHlfEIdyOicbwe5AqShTlK7lPGpictqLCvotuk17cQkLXDbpn83HsCyctOUicLqJI1jMDHA/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;">然则</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;"><strong style="color: blue;">制作动态工资条。</strong></span></p><strong style="color: blue;"><span style="color: black;">制作动态工资条</span></strong>
<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;"><strong style="color: blue;"><span style="color: black;">第1</span>步：</strong></span>在工资表2任一单元格输入 =号，<span style="color: black;">而后</span>接着引用工资表1的A1，形成如图所示，图中$指绝对引用</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/O2WqpUicg9icDVsLCltwAHlfEIdyOicbwe5CW9Mjk5aU9vI8UK8AW3xNcYohsS99eePsTaBicyHOWvLL3UWKdVzeVw/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;">第二步：</strong></span>如图操作，图中aa仅<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_png/O2WqpUicg9icDVsLCltwAHlfEIdyOicbwe5icA5qWIX4J6s3INYNPjyVxCCYNMuExderyYTXJHTGUicicyicMnGV5nT3g/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;">第三步：</strong></span>在工资表2中操作，如图</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/O2WqpUicg9icDVsLCltwAHlfEIdyOicbwe5lcnvdsGjfNFMVCfLcMcyxlZ8k0PqMm8XIAntZibW2zHzSYeY94iaTicAQ/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;"><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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/O2WqpUicg9icDVsLCltwAHlfEIdyOicbwe5IjTcsBqHWLGJdSKMMubt022AXnNEXv3QKM7L4UQtv1ibGN7exyj9nUg/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;">更加多</span>关于Excel技巧操作的惊喜哦！</p><img src="https://mmbiz.qpic.cn/mmbiz_jpg/a3jzy4ibVheFOZTouzMm9eias94IZUiaTUWOnYK1nuL8Siaiatb7pdKrLajZ8276enEJ1ztXgRbhJC4mT589O7mibYbA/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">朱朱</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">长按识别二维码关注公众号：</p>WPS加PS自学平台<img src="https://mmbiz.qpic.cn/mmbiz_jpg/a3jzy4ibVheFOZTouzMm9eias94IZUiaTUW5P7oc93huyiaju5NEkibwjwRLibS7PJJ57vNGqeRuTWcPLy0TjOvrvZeg/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><img src="https://mmbiz.qpic.cn/mmbiz_jpg/a3jzy4ibVheFOZTouzMm9eias94IZUiaTUWIWMJPe2DPrvh64MJLQzZQZXeDRSUP58zGZmOsibq8qf6KJHia3ibcIacQ/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">长按二维码关注我</p>
你的话深深触动了我，仿佛说出了我心里的声音。 你的见解独到，让我受益匪浅，期待更多交流。 网站建设seio论坛http://www.fok120.com/
页:
[1]