史上最简单的Excel工资条制作办法（单行表头）
<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 style="color: black;">此时</span>，</span>HR<span style="color: black;">主管让我过去，打开了一张表格：这是</span>3<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;"><img src="http://mmbiz.qpic.cn/mmbiz/k6kCsib3eJMxoDCvSgChvEtyEia1XyIhQicweEItNnJDNG9KKepIfMsKjjo8Jica8M6nPBm4qH4qyPrkPLOtrxOByQ/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">图</span><span style="color: black;"> 1‑2</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 style="color: black;">针对</span>双行表头的明细表，<span style="color: black;">由于</span>太麻烦都是直接忽略，<span style="color: black;">此刻</span>让我一时想<span style="color: black;">处理</span>办法，这个还真有点为难。我可是</span>Excel<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;">HR<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 style="color: black;">就可</span>。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">Step 01<span style="color: black;">如</span><span style="color: black;">图</span> 1‑3<span style="color: black;">所示，复制</span>A<span style="color: black;">列的编号，单击</span>A22<span style="color: black;"><span style="color: black;">亦</span><span style="color: black;">便是</span>最后一个编号下面的<span style="color: black;">第1</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/k6kCsib3eJMxoDCvSgChvEtyEia1XyIhQicgKicp3LXr26lmbTvvibQBlxuscefTy18erLVYnNFpLozwG937Cfy8AicQ/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><a style="color: black;"><span style="color: black;">图</span> </a><span style="color: black;">1‑3</span><span style="color: black;">粘贴编号</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">Step 02 <span style="color: black;">如</span><span style="color: black;">图</span> 1‑4<span style="color: black;">所示，复制表头</span>B2:Q2<span style="color: black;">，<span style="color: black;">选取</span>区域</span>B22:Q40<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/k6kCsib3eJMxoDCvSgChvEtyEia1XyIhQicuLQbQW39A29ZgOFLCaNEguLiad4MgBu0BPTS7eRHYFxcujlv412FgMg/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><a style="color: black;"><span style="color: black;">图</span></a><span style="color: black;">1‑4</span><span style="color: black;">粘贴表头</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">Step 03 <span style="color: black;">如</span><span style="color: black;">图</span> 1‑5<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/k6kCsib3eJMxoDCvSgChvEtyEia1XyIhQicHQqL1bnzicUd09SmRzajWFEicFSic7Q8icozO8ZaicU6bM6ezmVV3KK53sQ/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><a style="color: black;"><span style="color: black;">图</span></a><span style="color: black;">1‑5</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>3<span style="color: black;">步就<span style="color: black;">容易</span>完成，如</span><span style="color: black;">图</span> 1‑6<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/k6kCsib3eJMxoDCvSgChvEtyEia1XyIhQick6MRdKce7AwPptxz5o3F0VQG4dbJ5bKOOUEhZ9RkdDUOQ6FJgWv9ug/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><a style="color: black;"><span style="color: black;">图</span></a><span style="color: black;">1‑6</span><span style="color: black;">工资条</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">HR<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></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 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;">1、<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;">2、<span style="color: black;">用</span>VBA<span style="color: black;">生成工资条，还得跟她解释什么是</span>VBA<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;">3、<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 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;">公众号ID:exceljiaocheng</p><img src="http://mmbiz.qpic.cn/mmbiz/7CibAcfrHMDnicfv1cBibrJUqOiaS0OW8D0mDBZmHe7zq1F26pSP3d7ibStBsuwLgiaCrglqaCtHrK2k6rrDUOosiaOHg/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">部落窝教育</span><span style="color: black;">升职加薪，走上人生巅峰</span><span style="color: black;">关注一下又不会怀孕</span><img src="http://mmbiz.qpic.cn/mmbiz/k6kCsib3eJMwkVp4EbAZckia0A6CmlSrmggVUFCUGK7tlvYZdcqLRSs3yNf4j5P8OG1O2Cfrt8slY8Pwf1npzynw/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;"><span style="color: black;">长按二维码可扫描关注</span></p>
“板凳”（第三个回帖的人） 祝福你、祝你幸福、早日实现等。
页:
[1]