Excel中设置好表格后,可以通过设置打印标题,每一页都自动添加表头,但是要每行都添加标题,只有用在每行后插入标题的方法:
比如将下图的工资表,做成工资条,为便查看各项金额,每个人的工资条都需要含有标题,需要采用一行间一行添加标题的方法;
![](https://video.ask-data.xyz/img.php?b=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://video.ask-data.xyz/img.php?b=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://video.ask-data.xyz/img.php?b=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://video.ask-data.xyz/img.php?b=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://video.ask-data.xyz/img.php?b=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://video.ask-data.xyz/img.php?b=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)