当前时间： 2026-06-20 10:27:28
分类：办公文件
评论(0)
这些Excel特殊序号,你会不会?小伙伴们好啊，今天再和大家分享Office增强插件易用宝中的几个便捷操作。
如下图所示，要在A列输入2位序号，不足2位的以0补齐。依次单击【易用宝】→【便捷输入】→【智能填充序号】。在弹出的对话框中按需要设置序号位数，勾选“补零”：依次单击【易用宝】→【便捷输入】→【插入序号】。在弹出的对话框中按需要设置序号格式选项，确定即可：如下图所示，要在A列姓名前直接添加带圈的数字序号。依次单击【易用宝】→【便捷输入】→【插入序号】。在弹出的对话框中切换到【带圈序号】选项卡，按需要设置序号格式选项，确定即可：如下图所示，C列使用换行符在同一个单元格内显示为多行。要在每一行分别添加序号。依次单击【易用宝】→【便捷输入】→【插入序号】。在弹出的对话框中切换到【单元格内加序号】选项卡，按需要设置序号格式选项，确定即可：依次单击【易用宝】→【便捷输入】→【智能序号】。在弹出的对话框中按需要设置序号格式选项，确定即可：
点击[阅读原文]，了解易用宝更多亮眼功能。
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2026-06-20 19:16:02 HTTP/1.1 GET : https://www.yeyulingfeng.com/a/774010.html
- 运行时间 : 0.190663s [ 吞吐率：5.24req/s ] 内存消耗：4,664.18kb 文件加载：145
- 缓存信息 : 0 reads,0 writes
- 会话信息 : SESSION_ID=7badceb8a848b29a81ae734f8725eed1
- CONNECT:[ UseTime:0.001108s ] mysql:host=127.0.0.1;port=3306;dbname=wenku;charset=utf8mb4
- SHOW FULL COLUMNS FROM `fenlei` [ RunTime:0.001378s ]
- SELECT * FROM `fenlei` WHERE `fid` = 0 [ RunTime:0.000647s ]
- SELECT * FROM `fenlei` WHERE `fid` = 63 [ RunTime:0.000578s ]
- SHOW FULL COLUMNS FROM `set` [ RunTime:0.001040s ]
- SELECT * FROM `set` [ RunTime:0.000506s ]
- SHOW FULL COLUMNS FROM `article` [ RunTime:0.001215s ]
- SELECT * FROM `article` WHERE `id` = 774010 LIMIT 1 [ RunTime:0.000822s ]
- UPDATE `article` SET `lasttime` = 1781954162 WHERE `id` = 774010 [ RunTime:0.003454s ]
- SELECT * FROM `fenlei` WHERE `id` = 64 LIMIT 1 [ RunTime:0.004177s ]
- SELECT * FROM `article` WHERE `id` < 774010 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001105s ]
- SELECT * FROM `article` WHERE `id` > 774010 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000974s ]
- SELECT * FROM `article` WHERE `id` < 774010 ORDER BY `id` DESC LIMIT 10 [ RunTime:0.001633s ]
- SELECT * FROM `article` WHERE `id` < 774010 ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.003308s ]
- SELECT * FROM `article` WHERE `id` < 774010 ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.003162s ]
0.194682s
夜雨聆风
