当前时间: 2026-06-04 10:36:26
分类:办公文件
评论(0)
Excel 序号填充,4 种方法一定要收藏!那么填充序号的方式不止一种,今天我们就一起总结一下,有遗漏的欢迎大家一起补充,一起进步💪①在A1和A2单元格分别输入数字1和2,选中 A1:A2②鼠标放到单元格右下角黑色十字(填充柄),下拉自动 1、2、3、4、5…①在A1和A2单元格分别输入数字1和2,选中 A1:A2②双击右下角十字,自动填充到 B 列最后一行数据旁。(假设B列有数据)💡若上面两种方法,下拉后全是 1和2,说明是复制填充,点右下角自动填充选项→填充序列即可。③序列产生在:列;步长 1;终止值填需要的最后序号(如 5000)→确定,一键填满5000个序号。适用:动态序号,增删行自动更新填充序号,序号永久连续不乱。①从 A1 开始编号:=ROW(A1) 下拉 →1、2、3…②从 A3 开始(跳过 2 行表头):=ROW(A1),A3 输入公式下拉,依旧从 1 开始序列填充。💡上面的A1,可以是B1、C1、D1......都不影响结果。①例如填充序列1~100,在任意需要开始填充的单元格输入公式=SEQUENCE(100),回车,1秒填充完成。输入公式=SEQUENCE(20,1,3,2),效果看下面:③自动填充序号,=SEQUENCE(COUNTA(B:B)),B列有数据,A列就会自动填充序号,B列删除数据,A列序号也会跟着删除。全选所有合并单元格,输入:=MAX($A$1:A1)+1 → Ctrl+Enter 批量填充,自动按合并块 1、2、3 编号,MAX 作用:提取上方最大序号。今天的序号填充方法就分享完毕啦,按需选用事半功倍。觉得内容有用别忘了收藏转发,下期继续解锁更多 Excel 实用小技巧!
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2026-06-04 12:35:23 HTTP/1.1 GET : https://www.yeyulingfeng.com/a/709248.html
- 运行时间 : 0.249372s [ 吞吐率:4.01req/s ] 内存消耗:4,776.16kb 文件加载:145
- 缓存信息 : 0 reads,0 writes
- 会话信息 : SESSION_ID=ad03c8266132c5ec923da6b3a2b0045e
- CONNECT:[ UseTime:0.001097s ] mysql:host=127.0.0.1;port=3306;dbname=wenku;charset=utf8mb4
- SHOW FULL COLUMNS FROM `fenlei` [ RunTime:0.001569s ]
- SELECT * FROM `fenlei` WHERE `fid` = 0 [ RunTime:0.000731s ]
- SELECT * FROM `fenlei` WHERE `fid` = 63 [ RunTime:0.003759s ]
- SHOW FULL COLUMNS FROM `set` [ RunTime:0.001363s ]
- SELECT * FROM `set` [ RunTime:0.000683s ]
- SHOW FULL COLUMNS FROM `article` [ RunTime:0.001541s ]
- SELECT * FROM `article` WHERE `id` = 709248 LIMIT 1 [ RunTime:0.001174s ]
- UPDATE `article` SET `lasttime` = 1780547724 WHERE `id` = 709248 [ RunTime:0.024026s ]
- SELECT * FROM `fenlei` WHERE `id` = 64 LIMIT 1 [ RunTime:0.000802s ]
- SELECT * FROM `article` WHERE `id` < 709248 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001171s ]
- SELECT * FROM `article` WHERE `id` > 709248 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.001146s ]
- SELECT * FROM `article` WHERE `id` < 709248 ORDER BY `id` DESC LIMIT 10 [ RunTime:0.001619s ]
- SELECT * FROM `article` WHERE `id` < 709248 ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.004492s ]
- SELECT * FROM `article` WHERE `id` < 709248 ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.019966s ]
0.253294s