排班表怎么做美观又大方？

可以通过使用EXCEL来建立表格，然后通过设定颜色对应的日期和人员来进行排班级，具体的设计操作方法如下：

1、打开EXCEL表格，点击上方的页面布局，将该文件设置未横向，在文件上方输入该排班表的表头。

/iknow-pic.cdn.bcebos.com/6159252dd42a2834f19f7c7654b5c9ea15cebf96"target="_blank"title=""class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/6159252dd42a2834f19f7c7654b5c9ea15cebf96?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="/6159252dd42a2834f19f7c7654b5c9ea15cebf96"/>

2、用鼠标选出33个单元格，点击右键选择列宽，将列宽设置为4。

/iknow-pic.cdn.bcebos.com/f9198618367adab4cb13503e84d4b31c8601e488"target="_blank"title=""class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/f9198618367adab4cb13503e84d4b31c8601e488?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="/f9198618367adab4cb13503e84d4b31c8601e488"/>

3、选中表头以后，点击上方的合并并居中按钮。

/iknow-pic.cdn.bcebos.com/cdbf6c81800a19d8a2b5ce783cfa828ba61e461c"target="_blank"title=""class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/cdbf6c81800a19d8a2b5ce783cfa828ba61e461c?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="/cdbf6c81800a19d8a2b5ce783cfa828ba61e461c"/>

4、将第一个和第二个单元格合并以后输入日期文字。

/iknow-pic.cdn.bcebos.com/37d3d539b6003af3f700691d3a2ac65c1038b611"target="_blank"title=""class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/37d3d539b6003af3f700691d3a2ac65c1038b611?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="/37d3d539b6003af3f700691d3a2ac65c1038b611"/>

5、在日期下面输入员工的姓名。

/iknow-pic.cdn.bcebos.com/622762d0f703918f3f7688b75e3d269759eec42c"target="_blank"title=""class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/622762d0f703918f3f7688b75e3d269759eec42c?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="/622762d0f703918f3f7688b75e3d269759eec42c"/>

6、再在日期数字下面输入周一、周二等。

/iknow-pic.cdn.bcebos.com/f31fbe096b63f624d3718c7e8844ebf81a4ca39b"target="_blank"title=""class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/f31fbe096b63f624d3718c7e8844ebf81a4ca39b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="/f31fbe096b63f624d3718c7e8844ebf81a4ca39b"/>

7、再将后面的两个单元格合并以后输入出勤和休息用来统计员工的当月出勤情况。

/iknow-pic.cdn.bcebos.com/4afbfbedab64034f1e55777ba0c379310a551d36"target="_blank"title=""class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/4afbfbedab64034f1e55777ba0c379310a551d36?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="/4afbfbedab64034f1e55777ba0c379310a551d36"/>

8、选中下图所示为区域，点击填充表格颜色，选择一个填充色进行填充。

/iknow-pic.cdn.bcebos.com/30adcbef76094b364a14ae90accc7cd98c109dcd"target="_blank"title=""class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/30adcbef76094b364a14ae90accc7cd98c109dcd?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="/30adcbef76094b364a14ae90accc7cd98c109dcd"/>

9、将该表格中输入数据的单元格选中以后，点击上方的田字格标志，选择所有框线。

/iknow-pic.cdn.bcebos.com/8326cffc1e178a82cac1caddf903738da877e8ca"target="_blank"title=""class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/8326cffc1e178a82cac1caddf903738da877e8ca?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="/8326cffc1e178a82cac1caddf903738da877e8ca"/>

10、然后在需要设置排班的人员对应的日期进行勾选以表示上班，则该排班表就已经制作完成了。

/iknow-pic.cdn.bcebos.com/8d5494eef01f3a292ba761b39625bc315c607c5b"target="_blank"title=""class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/8d5494eef01f3a292ba761b39625bc315c607c5b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="/8d5494eef01f3a292ba761b39625bc315c607c5b"/>

11、为了后续便于数据统计可以在表格最后面出勤和休息里面输入该员工的当月出勤情况。

/iknow-pic.cdn.bcebos.com/060828381f30e924335f284c43086e061c95f7d0"target="_blank"title=""class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/060828381f30e924335f284c43086e061c95f7d0?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="/060828381f30e924335f284c43086e061c95f7d0"/>

注意事项：

该排班表的制作还可以根据实际情况再添加其他相关信息，如制表人、请假等信息即可。