当前时间： 1970-01-01 08:00:00
分类：办公文件
评论(0)
这些Excel高阶序号技巧,全都会的请举手小伙伴们好啊，今天和大家分享几个Excel序号技巧。如下图所示，希望按照B列的部门属性，每个部门序号从1开始。=COUNTIF(B$1:B2,B2)
如下图所示，希望在对B列的部门进行筛选时，序号仍然能保持连续。=SUBTOTAL(3,B$1:B2)-1
如下图所示，要在A列输入2位序号，不足2位的以0补齐。依次单击【易用宝】→【便捷输入】→【智能填充序号】。在弹出的对话框中按需要设置序号位数，勾选“补零”：
点击[阅读原文]，了解易用宝更多亮眼功能。
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2026-05-13 08:17:10 HTTP/1.1 GET : https://www.yeyulingfeng.com/a/615977.html
- 运行时间 : 0.118900s [ 吞吐率：8.41req/s ] 内存消耗：4,820.02kb 文件加载：145
- 缓存信息 : 0 reads,0 writes
- 会话信息 : SESSION_ID=e0910c12d490eee9a2943caf4908531d
- CONNECT:[ UseTime:0.000530s ] mysql:host=127.0.0.1;port=3306;dbname=wenku;charset=utf8mb4
- SHOW FULL COLUMNS FROM `fenlei` [ RunTime:0.000655s ]
- SELECT * FROM `fenlei` WHERE `fid` = 0 [ RunTime:0.000279s ]
- SELECT * FROM `fenlei` WHERE `fid` = 63 [ RunTime:0.000238s ]
- SHOW FULL COLUMNS FROM `set` [ RunTime:0.000523s ]
- SELECT * FROM `set` [ RunTime:0.000219s ]
- SHOW FULL COLUMNS FROM `article` [ RunTime:0.000542s ]
- SELECT * FROM `article` WHERE `id` = 615977 LIMIT 1 [ RunTime:0.004456s ]
- UPDATE `article` SET `lasttime` = 1778631430 WHERE `id` = 615977 [ RunTime:0.006894s ]
- SELECT * FROM `fenlei` WHERE `id` = 64 LIMIT 1 [ RunTime:0.000316s ]
- SELECT * FROM `article` WHERE `id` < 615977 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
- SELECT * FROM `article` WHERE `id` > 615977 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000345s ]
- SELECT * FROM `article` WHERE `id` < 615977 ORDER BY `id` DESC LIMIT 10 [ RunTime:0.005517s ]
- SELECT * FROM `article` WHERE `id` < 615977 ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.004570s ]
- SELECT * FROM `article` WHERE `id` < 615977 ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.015453s ]
0.120680s
夜雨聆风
