l14107cb 发表于 2024-10-2 15:38:19

史上最简单的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&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;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&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;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&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;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&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;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&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;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&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;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&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;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>




7wu1wm0 发表于 2024-10-28 01:03:18

“板凳”(第三个回帖的人)‌
页: [1]
查看完整版本: 史上最简单的Excel工资条制作办法(单行表头)