当前时间： 2026-07-14 00:51:06
分类：办公文件
评论(0)
Excel中如何提取不规则合并单元格中数据在数据统计报表中，我们经常遇到不规则合并单元格，想要提取合并单元格的数据该怎么办呢？下面教给大家一种办法，主要思路是先「取消合并单元格」—「Ctrl+G定位数据」—「复制」—「粘贴」即可；或「取消合并单元格」—「Ctrl+G定位-空值」—删除空值单元格。看上面的表格，我们只想提取表格中的序号、姓名、部门和合计列。第一步，选中所有表格，点击任务栏中「合并」——「取消合并单元格」，得到如图表格。若「合计」列的数据包含公式，则在「取消合并单元格」后复制合计列，仅粘贴数值得到无公式的「合计」列。第二步，选中所需要的A、B、C、F列数据，按「Ctrl+G」定位到可见单元格（可选择数据，也可选择可见单元格），复制（Ctrl+C），然后粘贴（Ctrl+V）到相应的表格中。另外，由于我们不需要D列和E列数据，我们可先进行删除操作，之后「取消合并单元格」，再「Ctrl+G」定位到「空值」，删除空值单元格即可得到我们想要的数据表格。
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2026-07-23 05:06:29 HTTP/1.1 GET : https://www.yeyulingfeng.com/a/700054.html
- 运行时间 : 0.105730s [ 吞吐率：9.46req/s ] 内存消耗：4,655.43kb 文件加载：145
- 缓存信息 : 0 reads,0 writes
- 会话信息 : SESSION_ID=b22a669fc1c50d760fd52052fca1c57f
- CONNECT:[ UseTime:0.000625s ] mysql:host=127.0.0.1;port=3306;dbname=wenku;charset=utf8mb4
- SHOW FULL COLUMNS FROM `fenlei` [ RunTime:0.001165s ]
- SELECT * FROM `fenlei` WHERE `fid` = 0 [ RunTime:0.000395s ]
- SELECT * FROM `fenlei` WHERE `fid` = 63 [ RunTime:0.000265s ]
- SHOW FULL COLUMNS FROM `set` [ RunTime:0.000671s ]
- SELECT * FROM `set` [ RunTime:0.000219s ]
- SHOW FULL COLUMNS FROM `article` [ RunTime:0.000762s ]
- SELECT * FROM `article` WHERE `id` = 700054 LIMIT 1 [ RunTime:0.001147s ]
- UPDATE `article` SET `lasttime` = 1784754389 WHERE `id` = 700054 [ RunTime:0.007214s ]
- SELECT * FROM `fenlei` WHERE `id` = 64 LIMIT 1 [ RunTime:0.000283s ]
- SELECT * FROM `article` WHERE `id` < 700054 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000557s ]
- SELECT * FROM `article` WHERE `id` > 700054 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000537s ]
- SELECT * FROM `article` WHERE `id` < 700054 ORDER BY `id` DESC LIMIT 10 [ RunTime:0.010057s ]
- SELECT * FROM `article` WHERE `id` < 700054 ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.001787s ]
- SELECT * FROM `article` WHERE `id` < 700054 ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.002801s ]
0.107489s
夜雨聆风
