手把手教你制作企业常用考勤表模板，一次制作，永久运用
<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 style="color: black;">状况</span>，既是员工<span style="color: black;">每日</span>上班的凭证，<span style="color: black;">亦</span>是员工领取工资的凭证。</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 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></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 style="color: black;">那样</span>，一个规范、深得领导<span style="color: black;">喜欢</span>的考勤表模板，应该具备<span style="color: black;">那些</span>特点呢？</span></span></p><span style="color: black;"><span style="color: black;">表头日期和星期<span style="color: black;">按照</span>年份、月份的变化自动更新。</span></span><span style="color: black;"><span style="color: black;">周<span style="color: black;">6、</span>周日会自动<span style="color: black;">明显</span><span style="color: black;">表示</span>，更好地区分上班日和周末节假日。</span></span><span style="color: black;"><span style="color: black;">所有单元格里面收集的数据都<span style="color: black;">能够</span><span style="color: black;">经过</span>下拉菜单填充。</span></span>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">1．随着年、月变化，自动更新日期、星期</h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">在Excel表格中搭建好考勤表框架，<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></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;">Step 01 <span style="color: black;">按照</span>考勤表内容搭建好考勤表框架，如下图所示。</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/386927be112242879b7e1c98e2a0ea24~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727979566&x-signature=u6toB3UCFE28w1IpFyrNfkyHixs%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;">Step 02 输入辅助数据。在当前工作表中估计不会用到的空白区域中输入多个年份（本例中输入年份为2015～2025）及月份数据<span style="color: black;">做为</span>辅助列，方便后面调用，如下图所示。</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/6dff1f35a8b045f89363cdac7c45b921~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727979566&x-signature=7sV9yGtwu0sS3e3TXbxv0xhbIFo%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;">Step 03 设置年份序列。<span style="color: black;">选取</span>C1单元格，单击【数据】选项卡【数据工具】组中的【数据验证】按钮，打开【数据验证】对话框，在【设置】选项卡的【<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></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/0ec9266e455c4f0cadaf18169d3cdacc~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727979566&x-signature=0e98z2T%2FPE2dRwofOeciuzYdiGg%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;">Step 04 设置月份序列。<span style="color: black;">选取</span>E1单元格，打开【数据验证】对话框，在【设置】选项卡的【<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></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p6-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/17c023d7392e46398ccd00b017b7fdcc~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727979566&x-signature=BGN5XsqAW5CGx86YTzoyRR35sqg%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;">Step 05 计算应出勤天数。<span style="color: black;">选取</span>P1单元格，输入公式【=NETWORKDAYS (DATE($C$1,$E$1,1),EOMONTH(DATE($C$1,$E$1,1),0))】，计算出所选月份应该出勤的总天数，如下图所示。</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/e466afe080a84ae7a6531273b80ed232~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727979566&x-signature=4Hq%2B7v7x57M%2BCImNhlDVe6PrEDQ%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;"><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;"><span style="color: black;"><span style="color: black;">本例中采用 NETWORKDAYS函数计算所选月份应该出勤的总天数时，用了DATE函数将C1、E1单元格和数字1转换为日期数据，<span style="color: black;">做为</span>统计工作日的<span style="color: black;">起始</span>日期；用EOMONTH函数让转换为日期的 DATE($C$1,$E$1,1)数据返回当月的最后一天，<span style="color: black;">做为</span>统计工作日的结束日期。</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;">Step 06 计算得出表格标题。在C1和E1单元格中分别<span style="color: black;">选取</span>一个年份和月份，<span style="color: black;">就可</span>在P1单元格中查看到<span style="color: black;">按照</span><span style="color: black;">刚才</span>输入公式计算出的当月考勤天数。<span style="color: black;">选取</span>A2单元格，输入公式【=TEXT(DATE (C1,E1,1),"e年M月份考勤表")】，<span style="color: black;">就可</span>在A2单元格中<span style="color: black;">按照</span>C1、E1单元格中<span style="color: black;">选取</span>的年份和月份自动<span style="color: black;">表示</span>当前工作表的名<span style="color: black;">叫作</span>，如下图所示。</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/f8a4bed37dd8430fa45be986fe51f5cf~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727979566&x-signature=LTMRyspmE6MYDlBrJ93ZgiqKFLg%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;">Step 07 计算日期序号。<span style="color: black;">选取</span>D4单元格，输入公式【=IF(MONTH(DATE ($C$1,$E$1,COLUMN(A1)))=$E$1,DATE ($C$1,$E$1,COLUMN(A1)),"")】，返回当前<span style="color: black;">选取</span>的年份和月份的<span style="color: black;">第1</span>天对应的日期序号，右击D4单元格，在弹出的快捷菜单中<span style="color: black;">选取</span>【设置单元格格式】命令，如下图所示。</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/fbcf6e9fcb7542de915eab0a35edee02~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727979566&x-signature=K3BTzsc9lQBOUVfDeLGlPM1eHTE%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;"><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;"><span style="color: black;"><span style="color: black;">公式<span style="color: black;">首要</span>用DATE函数将C1、E1单元格和<span style="color: black;">经过</span>COLUMN(A1)提取的A1单元格的列号，转换为日期数据，<span style="color: black;">而后</span>用MONTH函数提取这个组合日期的月份数，让得到的结果与E1单元格的月份数进行比较，<span style="color: black;">倘若</span>等于，就返回DATE($C$1,$E$1, COLUMN(A1))，否则返回空值。<span style="color: black;">这般</span>，后面<span style="color: black;">经过</span>复制公式，公式中的 COLUMN(A1) 就会自动进行相对位置的改变，从而实现依次返回指定月份的日期数。</span></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">Step 08 设置日期格式。打开【设置单元格格式】对话框，在【数字】选项卡的【<span style="color: black;">归类</span>】列表框中<span style="color: black;">选取</span>【自定义】选项，在【类型】文本框中输入【d】，单击【确定】按钮，如下图所示。</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p26-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/ceb916f426ea407da325c2ef2baa3923~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727979566&x-signature=Bw63B%2BKjHs0RC80kVnnL4XjOfMw%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;">Step 09 复制公式。<span style="color: black;">就可</span>让D4单元格中的日期数据仅<span style="color: black;">表示</span>为日。向右拖动填充<span style="color: black;">掌控</span>柄，复制公式到E4:AH4单元格区域，返回当前<span style="color: black;">选取</span>的年份和月份的其他天对应的日期序号，如下图所示。</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/12b40da1802a4a07adab72211b5e3b55~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727979566&x-signature=Xdg8wlBbDA7qP7hDz%2Brb1NynrII%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;">Step 10 计算日期对应的星期。<span style="color: black;">选取</span> D5单元格，输入与 D4 单元格中相同的公式【=IF(MONTH(DATE($C$1,$E$1, COLUMN(A1)))=$E$1,DATE($C$1,$E$1,COLUMN(A1)),"")】，按【Enter】键计算出结果，如下图所示。</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/de9d3ad9e57840cc9d12fdb501c8a456~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727979566&x-signature=MSAZMnTjwFAMbfV8aX8nZ%2FT%2Fpa4%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;">Step 11 复制公式。将D5单元格中的数字格式自定义为“aaa”，<span style="color: black;">就可</span>让D5单元格中的日期数据仅<span style="color: black;">表示</span>为星期中的序号。向右拖动填充<span style="color: black;">掌控</span>柄，复制公式到 E5:AH5 单元格区域，<span style="color: black;">就可</span>返回当前<span style="color: black;">选取</span>的年份和月份的其他天对应的星期序号，如下图所示。</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/afc3834134924529ab48a51ab8c32586~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727979566&x-signature=OIzXnJ4VbdMYXskU70nrscas3Pc%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">2．<span style="color: black;">明显</span>周<span style="color: black;">6、</span>周日</h1>
<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 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></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;">Step 01 <span style="color: black;">选取</span>菜单命令。<span style="color: black;">选取</span> D4:AH5单元格区域，单击【<span style="color: black;">起始</span>选项卡】【样式】组中的【<span style="color: black;">要求</span>格式】按钮，在弹出的下拉菜单中<span style="color: black;">选取</span>【新建规则】命令，如下图所示。</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/599de58086d94937b8b57c128c58060e~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727979566&x-signature=dH%2FCP1P9W2tus1fbBFT2WjsTBNg%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;">Step 02 设置<span style="color: black;">要求</span>格式。打开【新建格式规则】对话框，在【<span style="color: black;">选取</span>规则类型】列表框中<span style="color: black;">选取</span>【<span style="color: black;">运用</span>公式确定要设置格式的单元格】选项，在【为符合此公式的值设置格式】参数框中输入公式【=WEEKDAY(D4,2)=6】，单击【格式】按钮，如下图所示。</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/ecb41a09e52046c4a13153249e8d8fb6~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727979566&x-signature=DhNqt3tO01TAbFU4imFzl3OkU6A%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;">Step 03 设置单元格填充效果。打开【设置单元格格式】对话框，<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></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/227ad3946a6e478298a1683ffd2987ac~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727979566&x-signature=YudXFCVM6buMvRTAjQBHlVdy5SY%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;">Step 04 <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;">表示</span>星期天。为<span style="color: black;">保准</span>表格中的自动数据无误，<span style="color: black;">能够</span>重新设置 C1、E1 单元格中的年份和月份，并验证指定年月应出勤天数、表格标题、当月所有日期及对应的星期数<span style="color: black;">是不是</span>出错，如下图所示。</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p26-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/83acee89fc874113a2e4cb78e5e5a56d~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727979566&x-signature=yZ7BzLTkjq5wTxVu2xSpdsqVdL8%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">3．规范考勤数据</h1>
<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 style="color: black;">做为</span>辅助列的数据进行<span style="color: black;">隐匿</span>，让<span style="color: black;">全部</span>表格更加规范。</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 style="color: black;">详细</span>操作<span style="color: black;">过程</span>如下。</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;">Step 01 设置数据验证。重命名工作表名<span style="color: black;">叫作</span>为【考勤表模板】，为表格区域添加相应的边框，<span style="color: black;">选取</span>D6:AH50单元格区域，打开【数据验证】对话框，A在【设置】选项卡的【<span style="color: black;">准许</span>】下拉列表中<span style="color: black;">选取</span>【序列】选项，在【<span style="color: black;">源自</span>】参数框中输入【√,事,病,差,年,婚,迟1,迟2,迟3,旷】，单击【确定】按钮，如下图所示。</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/621d957102d541998d94b5dc7d2820f5~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727979566&x-signature=NPQQeTlJ5Fj8G724iAMZfE5jLMM%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;"><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;"><span style="color: black;"><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>标记，迟到 10 分钟以内用【迟 1】<span style="color: black;">做为</span>标记，迟到半小时以内用【迟 2】<span style="color: black;">做为</span>标记，迟到 1 小时以内用【迟 3】<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></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">Step 02 冻结表格行和列。考勤表中的数据<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>的部分。本例需要固定表格的上面 5 行和左侧 3 列数据，<span style="color: black;">选取</span> D6 单元格，单击【视图】选项卡【窗口】组中的【冻结窗格】按钮 ，在弹出的下拉列表中<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-qvj2lq49k0/dc7f984c80d2431fbb75bef81afe7f93~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727979566&x-signature=vsovMhFqHvL221RGu0O6MWem8Qw%3D" style="width: 50%; margin-bottom: 20px;"></div>
页:
[1]