当前时间： 1970-01-01 08:00:00
分类：办公文件
评论(0)
Excel表格快速整理的小技巧如下表，左边为原始表格，内容很多，需整理为右边形式：筛选水果，即可获取相应数据。第1步： 在第一行，复制一行标题，再用IF函数获取水果。=IF(AND(B2="",A2<>""),A2,F1)
若A列有水果名称，就会直接显示，若无，则显示上一个单元格中的内容。而原表格中由于A列还混合其他内容，与水果名称相对应的B列，则刚好为空白，可利用双条件进行判断。第3步：若是高版本，可直接将内容复制至新的表格，若是低版本，可按Ctrl+G，定位可见单元格，再进行复制。先选择区域，之后插入透视表，将产地拉至行，将销量、价格拉至列。之后插入切片器，勾选水果，即可按照水果，来快速获取相应数据。以上就是今天和大家分享的Excel表格快速整理的小技巧。
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2026-05-14 09:07:45 HTTP/1.1 GET : https://www.yeyulingfeng.com/a/622632.html
- 运行时间 : 0.111659s [ 吞吐率：8.96req/s ] 内存消耗：4,580.22kb 文件加载：145
- 缓存信息 : 0 reads,0 writes
- 会话信息 : SESSION_ID=ffd16f6c4f1ad5a06fd9efd8d2df6b88
- CONNECT:[ UseTime:0.000535s ] 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.000300s ]
- SELECT * FROM `fenlei` WHERE `fid` = 63 [ RunTime:0.000242s ]
- SHOW FULL COLUMNS FROM `set` [ RunTime:0.000565s ]
- SELECT * FROM `set` [ RunTime:0.000218s ]
- SHOW FULL COLUMNS FROM `article` [ RunTime:0.000603s ]
- SELECT * FROM `article` WHERE `id` = 622632 LIMIT 1 [ RunTime:0.001525s ]
- UPDATE `article` SET `lasttime` = 1778720865 WHERE `id` = 622632 [ RunTime:0.002953s ]
- SELECT * FROM `fenlei` WHERE `id` = 64 LIMIT 1 [ RunTime:0.000236s ]
- SELECT * FROM `article` WHERE `id` < 622632 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
- SELECT * FROM `article` WHERE `id` > 622632 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.007638s ]
- SELECT * FROM `article` WHERE `id` < 622632 ORDER BY `id` DESC LIMIT 10 [ RunTime:0.001982s ]
- SELECT * FROM `article` WHERE `id` < 622632 ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.003467s ]
- SELECT * FROM `article` WHERE `id` < 622632 ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.005635s ]
0.113306s
夜雨聆风
