wps序号自动填充排序:
工具/原料:联想YANGTIANS516、Windows7、wps2019
1、第一步:打开一个需要设置自动填充序号的wps表格。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/43a7d933c895d143692bc4b561f082025baf07c2?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、第二步:在序号所在单元格,输入起始序号。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d833c895d143ad4b1473665690025aafa50f06c2?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、第三步:选中序号所在单元格,选择菜单栏中的“行和列”选项。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/c995d143ad4bd113b59097a448afa40f4afb05c2?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、第四步:在“行和列”下拉菜单中,选择“填充--序列”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/72f082025aafa40f819bee4bb964034f79f019c2?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、第五步:如下图所示,弹出“序列”设置对话框。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/4afbfbedab64034fb690e290bdc379310b551dc2?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、第六步:在“序列”对话框中,勾选上“等差序列”,选择“列”,并在终止值处输入100,单击“确定”按钮。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/faedab64034f78f03856ba656b310a55b2191cc2?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
7、如下图所示,wps表格中自动填充序号设置完成。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/79f0f736afc37931d835a6bff9c4b74542a911c2?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)