当前时间： 1970-01-01 08:00:00
分类：办公文件
评论(0)
Excel表格中如何保证序号自动变化在制表时，尤其数据量较大时，为了增加数据可读性，通常会在表格最左侧加一列序号列。如下图：但是在制表过程中，如果需要删除某一行数据，序号会变得不连续，这时候就需要反复重新编码，比较麻烦。比如在A3单元格输入row（），括号内不用写任何内容，则直接返回A3所在行号：3。但是序号必然是从1开始计数，就需要在row()基础上，减去前面标题行一共占了几列，或者看减多少最后可以等于1。3-2=1，所以我们在row()后面加上“-2”。这时候再去删除任意一列，序号都会自动按顺序填充好。有问题留言区交流
关注狸子，一起进步
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2026-04-13 17:47:56 HTTP/1.1 GET : https://www.yeyulingfeng.com/a/523043.html
- 运行时间 : 0.090728s [ 吞吐率：11.02req/s ] 内存消耗：4,963.71kb 文件加载：145
- 缓存信息 : 0 reads,0 writes
- 会话信息 : SESSION_ID=38f7e4857b10496a3229e03e3fed904d
- CONNECT:[ UseTime:0.000606s ] mysql:host=127.0.0.1;port=3306;dbname=wenku;charset=utf8mb4
- SHOW FULL COLUMNS FROM `fenlei` [ RunTime:0.000815s ]
- SELECT * FROM `fenlei` WHERE `fid` = 0 [ RunTime:0.000301s ]
- SELECT * FROM `fenlei` WHERE `fid` = 63 [ RunTime:0.000247s ]
- SHOW FULL COLUMNS FROM `set` [ RunTime:0.000488s ]
- SELECT * FROM `set` [ RunTime:0.000203s ]
- SHOW FULL COLUMNS FROM `article` [ RunTime:0.000544s ]
- SELECT * FROM `article` WHERE `id` = 523043 LIMIT 1 [ RunTime:0.000342s ]
- UPDATE `article` SET `lasttime` = 1776073676 WHERE `id` = 523043 [ RunTime:0.003491s ]
- SELECT * FROM `fenlei` WHERE `id` = 64 LIMIT 1 [ RunTime:0.000300s ]
- SELECT * FROM `article` WHERE `id` < 523043 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000738s ]
- SELECT * FROM `article` WHERE `id` > 523043 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000434s ]
- SELECT * FROM `article` WHERE `id` < 523043 ORDER BY `id` DESC LIMIT 10 [ RunTime:0.002295s ]
- SELECT * FROM `article` WHERE `id` < 523043 ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.004059s ]
- SELECT * FROM `article` WHERE `id` < 523043 ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.001640s ]
0.092401s
夜雨聆风
