弹出菜单。
1、鼠标在表格的第一行或者第二行任意单元格上右键,弹出快捷菜单。
2、在快捷菜单中选择排列方式或单元格格式,点击保护单元格。
3、在弹出的对话框中,取消勾选锁定和隐藏,点击确定按钮。
4、再次右键单元格,选择格式单元格,在弹出的对话框中选择对齐,将垂直对齐改为顶端对齐,即可显示表格头。
1、打开表格以后,如果预览一下要打印的表格,会出现如下图的情况,在第二页是没有表头的。
![](https://iknow-pic.cdn.bcebos.com/32fa828ba61ea8d30f8efb9e910a304e241f58f8?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
![](https://iknow-pic.cdn.bcebos.com/6159252dd42a2834a70eb9915db5c9ea14cebf84?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
![](https://iknow-pic.cdn.bcebos.com/738b4710b912c8fcca547957fa039245d7882180?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、下面说说让第二页自动带上表头的方法,打开表格后,先在工具栏中找到“文件”命令按钮,点击这个按钮。
![](https://iknow-pic.cdn.bcebos.com/7a899e510fb30f2465606399ce95d143ac4b03b5?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、在弹出的命令菜单中找到“页面设置”命令,点击这个命令。
![](https://iknow-pic.cdn.bcebos.com/d1a20cf431adcbefc5a3f19caaaf2edda2cc9f91?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、接着就会出现页面设置对话框,在对话框中先找到图一中“工作表”命令按钮,点击这个按钮,再找到第二幅图中的“顶端标题行”,鼠标点击这个命令后面的方框。
![](https://iknow-pic.cdn.bcebos.com/a044ad345982b2b77f74b65e37adcbef77099b45?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
![](https://iknow-pic.cdn.bcebos.com/6f061d950a7b02081929b07b64d9f2d3562cc84c?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、接着鼠标选择表头,就会出现如下图的情况,然后回车确定就行了。
![](https://iknow-pic.cdn.bcebos.com/b64543a98226cffc21003128bf014a90f603ea06?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
![](https://iknow-pic.cdn.bcebos.com/4b90f603738da9777f6e08b1b651f8198718e3e3?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、最后再预览一下,就会发现在第二页上自动带上表头了。
![](https://iknow-pic.cdn.bcebos.com/3ac79f3df8dcd100b88376bb748b4710b9122f08?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
1、如果“顶端标题行”选项呈灰色,很可能是之前点击打开了【打印】选项。
![](https://iknow-pic.cdn.bcebos.com/f636afc379310a55fa364a88a74543a9822610bf?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、然后点击了【打印】选项中的【页面设置】,这里的页面设置中“顶端标题行”选项就呈灰色。
![](https://iknow-pic.cdn.bcebos.com/42a98226cffc1e17daad184d5a90f603738de9b8?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、这时可以点击图示的返回按钮返回Excel主界面。
![](https://iknow-pic.cdn.bcebos.com/8b82b9014a90f60327a2083b2912b31bb051edb8?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、点击打开【页面布局】选项卡。
![](https://iknow-pic.cdn.bcebos.com/3812b31bb051f819dc379736cab44aed2e73e7b8?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、点击【页面布局】选项卡中的【打印标题】。
![](https://iknow-pic.cdn.bcebos.com/b21c8701a18b87d643503f63170828381f30fdb8?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、这时的“顶端标题行”选项就正常了。
![](https://iknow-pic.cdn.bcebos.com/b999a9014c086e0673baab3712087bf40ad1cbb8?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)