以下图2007版EXCEL为例,要让文档打印时每一页都显示标题行(第1和第2行)
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/caef76094b36acaf3439ecab71d98d1000e99c8f?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
1、打开2007版EXCEL表格,在菜单栏找到“页面布局”→“页面设置”
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/3c6d55fbb2fb4316b7d91f2d2da4462308f7d3a7?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/96dda144ad345982a2d481c501f431adcbef840e?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/eaf81a4c510fd9f9277a313e282dd42a2834a47c?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/d009b3de9c82d15886413de68d0a19d8bd3e42a1?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/730e0cf3d7ca7bcbe9c6a078b3096b63f624a82c?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/ae51f3deb48f8c54a0b7a27837292df5e0fe7f04?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/18d8bc3eb13533facd58f579a5d3fd1f40345bfe?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
7、点击打印预览后,我们进入打印预览观看效果图,如下图我们可以看到第2页也显示了标题行
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/cc11728b4710b912a01e90a9cefdfc039345228d?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
本回答被网友采纳