Excel是常用的办公编辑软件,一起看一下Excel中双行表头工资条的制作方法吧。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/4a36acaf2edda3cc39cdacb313e93901213f9273?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
材料/工具
Excel
方法
1/8
复制并粘贴工资表的表头。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/4ec2d5628535e5ddb205b14c64c6a7efce1b6273?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
2/8
在复制的表头第一列下的单元格中输入公式:=INDEX(A:A,ROW()/3+2)
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/3b292df5e0fe9925da257dc326a85edf8db17173?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
3/8
选中第一个单元格向右拖动,复制公式。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/574e9258d109b3deef96f0fbdebf6c81800a4c73?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
4/8
选中下图所示区域,鼠标移动到右下角,向下拖动复制。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/6d81800a19d8bc3ecb211259908ba61ea8d34573?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
5/8
工资条就制作完成了。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/c8177f3e6709c93dfbdb1a648d3df8dcd1005473?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
6/8
如果想要隔一行空行,那么公式改为:=INDEX(A:A,ROW()/4+3)。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/fd039245d688d43f1b8085616f1ed21b0ef43b73?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
7/8
选中表头、公式行及空行,向下拖动复制。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/0ff41bd5ad6eddc4f5cea0682bdbb6fd52663373?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
8/8
隔一行空行的工资条就完成了。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/0eb30f2442a7d9337e81f0e0bf4bd11373f00173?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述