打印EXCEL文件使每页都有标题,需要在页面设置中设置“打印标题行”。
具体操作步骤如下:
1、打开需要设置的EXCEL文档,在页面布局工具栏中找到页面设置一项,点击上面的“打印标题”。
/iknow-pic.cdn.bcebos.com/7dd98d1001e93901f789204f75ec54e736d1963c"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/7dd98d1001e93901f789204f75ec54e736d1963c?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/7dd98d1001e93901f789204f75ec54e736d1963c"/>
2、在“顶端标题行”后面的文本输入框中输入$1:$1(即设置首行为标题行,也可根据需要设置其他行),然后点击右下方的“确定”按钮。
/iknow-pic.cdn.bcebos.com/7acb0a46f21fbe09f4c66e6565600c338744ad23"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/7acb0a46f21fbe09f4c66e6565600c338744ad23?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/7acb0a46f21fbe09f4c66e6565600c338744ad23"/>
3、返回表格,通过快捷键“Ctrl+P”打开“打印预览”,在打印预览中翻到后面页面可发现已成功打印每一页的标题行。
/iknow-pic.cdn.bcebos.com/f7246b600c3387444f9f820d5f0fd9f9d72aa06d"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/f7246b600c3387444f9f820d5f0fd9f9d72aa06d?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/f7246b600c3387444f9f820d5f0fd9f9d72aa06d"/>