方法是;以WPS操作为例:
1、首先比如做2月份的考勤,先在表格的最上面一行选中几个单元格,然后点击合并居中。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9e3df8dcd100baa1a6733bdb5710b912c8fc2e76?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、接着在左边下面两行合并单元格,写上姓名。后面跟着的第一行,合并单元格,写上日期。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a71ea8d3fd1f4134cc68791e351f95cad1c85e76?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、接着在日期的下面备注上对应的日期天数,左边姓名下方写上具体的员工名字。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/8435e5dde71190ef47a4eebfde1b9d16fdfa6076?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、在表格的后面几列,用来备注,当月员工实际出勤和请假天数,可以加一个备注,员工有特殊情况可以用来说明。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/2fdda3cc7cd98d10208b7051313fb80e7bec9076?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、在考勤表的下面一行,出勤,请假和休息用对应的符号来表示,这样员工填的时候只需要填入符号即可。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/c75c10385343fbf2b873da43a07eca8065388f76?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、员工填写完毕之后,在后面统计下每个月的出勤情况,这样简单的考勤表就做好了。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/14ce36d3d539b600389173d7f950352ac65cb776?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)