首先打开excel表格,按住ctrl连续序号。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/7a899e510fb30f24014d4d7dd895d143ac4b03fc?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/43a7d933c895d143eaa1455d63f082025baf07fc?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
右侧重新创建一个序号列,输入=subtotal,选择3。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d043ad4bd11373f0c8e8cee1b40f4bfbfaed04fc?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
输入完整公式=subtotal(3,B$2:B2)。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/72f082025aafa40f06116fa3bb64034f79f019fc?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
选中序号后,按住ctrl+enter后刷新序号,此刻连续。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/c995d143ad4bd1133a1a164c4aafa40f4afb05fc?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/e7cd7b899e510fb34dced6e9c933c895d0430cfc?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
或者在单元格中输入=ROW(A1),然后按回车键。
275excel表格中如何直接自动生成排序序号?
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9f510fb30f2442a79dd95cdbc143ad4bd01302fc?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述