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;"><strong style="color: blue;">Excel表格快速制作工资条</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">本节课学习怎么在Excel表格里面快速制作工资条；<span style="color: black;">首要</span>录入每位员工的工资明细。要做成<span style="color: black;">每一个</span>名字上面都有明细的格式来打印给每位员工，下面<span style="color: black;">一块</span>来学习。</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">（1）打开录入的工资明细，如下图：</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/gC0ymMIMUyF9EthtE3GDa3dTBFr1HxQ76Fs33MsbcLxWKHicaXqK5ClUbmRShD2gDYkZxib20tDpH69mgvNOVhsA/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;">（2）把鼠标放在表格任意单元格内，在菜单栏上<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>用快捷从健CTRL+T<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/gC0ymMIMUyF9EthtE3GDa3dTBFr1HxQ7ichj1OgSWVX0Cz3ytzhLmfh5zicmbYwxP08K7C6kpfdAOZpSs61ZnrXA/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;">（3）在弹出的创建表对话框中，表数据的<span style="color: black;">源自</span>会默认为整张表格（A1:I11），点击确定<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/gC0ymMIMUyF9EthtE3GDa3dTBFr1HxQ7NTxMRxxPG2abkoCI6tosTRWVs1Y0D71aHnGMBCzXbgbfx80pia6wX4w/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;">（4）<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/gC0ymMIMUyF9EthtE3GDa3dTBFr1HxQ7ricSNVGEBrfQFe7mo3Xrr6Xr4E2qsYNAdWWjJZgJiaRvBb95sIMCucwQ/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>（5）<span style="color: black;">选取</span>A2到A11单元格，按CTRL+C复制序号，按CTRL+V粘贴到A12到A21.<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/gC0ymMIMUyF9EthtE3GDa3dTBFr1HxQ7nyWQH2DtmjqE2t7gQ0EicvLmViaP7ETbHnDeDTUsjBvhUAddyq4ic9W8w/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;">(6)<span style="color: black;">选取</span>B1到I11单元格，按CTRL+C复制，<span style="color: black;">而后</span><span style="color: black;">选取</span>B12到I21单元格后，按CTRL+V粘贴。</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/gC0ymMIMUyF9EthtE3GDa3dTBFr1HxQ76by25uYxEibWIsW0y2uY9l4Xz6yopuwrGNzBMKKo7ibRVKmPHdicOgrHg/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;">(7)选中序号一列表格内任意一个单元格，在菜单栏上<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>看21行多了一行没用的工资条表头，<span style="color: black;">能够</span>把它删除掉，<span style="color: black;">由于</span><span style="color: black;">第1</span>位员工<span style="color: black;">已然</span>有了明细表头了，<span style="color: black;">因此</span>复制序号以及工资条表头的时候应该是9就够了）</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/gC0ymMIMUyF9EthtE3GDa3dTBFr1HxQ7EzbLVk0ziaIcUkhCaJIaBJfsTiaGW5ibwV6mdLmd2tPUYX5Oxnn6pLn0w/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;">（8）以上<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/gC0ymMIMUyF9EthtE3GDa3dTBFr1HxQ74HWzic18uicp0zNRl2TAvZIHzOvGib64tib5Gq2aOKHCJA71ib4uYYAbx6w/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;"><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="https://mmbiz.qpic.cn/sz_mmbiz_png/bePCGbRich1E0WNKTSF0wICRHBmuy34VYjibT1yuxWM3lOibxE6pX1mYdSYZia2iapHXurduQbw4RBB942ThFf8kgSQ/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/mmbiz_gif/0jZ2JWHnNSlcJ8Y7GkHCPjrDJITwmtI8iaUHOft6Ez8licKpk2YrLrtz89RZHWpebo5E9guekDbJNHibWBY35xfYw/640?wx_fmt=gif&wxfrom=5&wx_lazy=1&tp=webp" 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="https://mmbiz.qpic.cn/sz_mmbiz_png/bePCGbRich1GXRE1YeOr3zQjYyaH5Q9B6Jwq25D1dWAPwSc0RVZFHCq9mX8L5MppkEbDKD3iaShZkudT9FFTC9fw/640?wx_fmt=png&wxfrom=5&wx_lazy=1&wx_co=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;"><img src="https://mmbiz.qpic.cn/mmbiz_gif/XVayrImXFrOJKwvDg8o6XkaMLSCqp9nia2x0EmTJavf1ORsQbRr3GDicoCuib6y0gAYhic1glSgDjYmcX1Dz7xkZXA/640?wx_fmt=gif&wxfrom=5&wx_lazy=1&tp=webp" 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>
软文发布平台 http://www.fok120.com/ 你的留言真是温暖如春，让我感受到了无尽的支持与鼓励。 感谢你的精彩评论，带给我新的思考角度。
页:
[1]