打开EXCE文档,点击左上角文件--页面设置--工作表--点击顶端标题行输入框后面的彩色小图标后弹出一个小的横条输入框,然后用鼠标选中你需要的第一行整行(要几行j就选几行),这样小输入框里就有数值了,然后点击输入框最后的那个小图标,又回到了页面设置的大选框,点击确定后就好了,页面预览看看,每一页都有你需要的标题行了。这是打印需要的。如果是在电脑上看表那就要冻结窗格,你想要几行不动,你就用鼠标选中不需要动的那行下边一行的第一个格,然后点击窗口---冻结窗格,OK,搓滚轮试试看。不知道我说的这两点对你有木有帮助。
表格每页都显示表头题目的方法如下:
工具/原料:Dell游匣G15、win10、Excel2016
1、打开excel表格后,点击“页面布局”。
![](https://iknow-pic.cdn.bcebos.com/c2cec3fdfc0392452b836a9a9594a4c27d1e2575?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/9345d688d43f8794a4cec3bbc01b0ef41bd53a75?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/4610b912c8fcc3ce39f642a68045d688d43f2075?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/d788d43f8794a4c27c126cbe1cf41bd5ad6e3975?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/a686c9177f3e67092436ce6a29c79f3df8dc5575?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/3ac79f3df8dcd10049aa73b4608b4710b9122f75?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
Excel中设置好表格后,可以通过设置打印标题,每一页都自动添加表头,但是要每行都添加标题,只有用在每行后插入标题的方法:
比如将下图的工资表,做成工资条,为便查看各项金额,每个人的工资条都需要含有标题,需要采用一行间一行添加标题的方法;
![](https://iknow-pic.cdn.bcebos.com/54fbb2fb43166d2203eec674402309f79152d2b1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
在F2中插入序号1,并向下填充到最后一人;
![](https://iknow-pic.cdn.bcebos.com/738b4710b912c8fc1ef2252dfa039245d78821c9?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/622762d0f703918fe2d3ee2a573d269758eec4d4?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
在下方的序号左侧,即图中的第7行,复制--粘贴标题并下拉填充(因原表有一个标题,这里填充的量比序号少一个);
![](https://iknow-pic.cdn.bcebos.com/4034970a304e251f5e8a3718a186c9177e3e53d5?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/9358d109b3de9c826ad92a6f6a81800a18d84396?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
即可得到就一行间一行插入标题的效果,再删除F列中的辅助序号即可。
![](https://iknow-pic.cdn.bcebos.com/b64543a98226cffc0a036c52bf014a90f603ea21?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)