当前时间： 2026-05-29 21:24:39
分类：办公文件
评论(0)
EXCEL多级下拉菜单1.先整理一级菜单;省份：①点击一级下拉菜单下面的空格；②点击数据-数据验证-任何值中取序列；③来源中等号=后面框选省份所在区域-确定，便得到一级下来菜单（省份）2.整理二级菜单的数据：①全选省、市级的数据，②点击公式-根据所选内容创建名称-只保留勾选首行-确定；③点击名称管理器，看看二级下拉菜单的内容；⑤点击二级下拉菜单下面的空格；⑥数据-数据验证-序列-来源-输入=indirect($H15);其中H15就是吉林省所处的位置，$是固定列不变，只变行-确定，既得到二级下拉菜单；3.三级下拉菜单（4-多级）和二级下拉菜单的生成，完全一样，只是把省市的数据区域，换成县区的数据区域，也一样包括公式、数据验证和indirerct函数，这里不再累赘！
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2026-05-30 22:39:11 HTTP/1.1 GET : https://www.yeyulingfeng.com/a/684282.html
- 运行时间 : 0.173637s [ 吞吐率：5.76req/s ] 内存消耗：4,676.11kb 文件加载：145
- 缓存信息 : 0 reads,0 writes
- 会话信息 : SESSION_ID=09f21173ca6e6f1eadd54237a29a8d61
- CONNECT:[ UseTime:0.001013s ] mysql:host=127.0.0.1;port=3306;dbname=wenku;charset=utf8mb4
- SHOW FULL COLUMNS FROM `fenlei` [ RunTime:0.001019s ]
- SELECT * FROM `fenlei` WHERE `fid` = 0 [ RunTime:0.000318s ]
- SELECT * FROM `fenlei` WHERE `fid` = 63 [ RunTime:0.000252s ]
- SHOW FULL COLUMNS FROM `set` [ RunTime:0.000487s ]
- SELECT * FROM `set` [ RunTime:0.000230s ]
- SHOW FULL COLUMNS FROM `article` [ RunTime:0.000678s ]
- SELECT * FROM `article` WHERE `id` = 684282 LIMIT 1 [ RunTime:0.000490s ]
- UPDATE `article` SET `lasttime` = 1780151951 WHERE `id` = 684282 [ RunTime:0.005442s ]
- SELECT * FROM `fenlei` WHERE `id` = 64 LIMIT 1 [ RunTime:0.000249s ]
- SELECT * FROM `article` WHERE `id` < 684282 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
- SELECT * FROM `article` WHERE `id` > 684282 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.003596s ]
- SELECT * FROM `article` WHERE `id` < 684282 ORDER BY `id` DESC LIMIT 10 [ RunTime:0.001238s ]
- SELECT * FROM `article` WHERE `id` < 684282 ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.000632s ]
- SELECT * FROM `article` WHERE `id` < 684282 ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.002621s ]
0.177374s
夜雨聆风
