当前时间： 2026-08-01 02:08:13
分类：办公文件
评论(0)
想准时下班,一定要学这5个经典Excel小技巧如果是直接复制，隐藏行也会被粘贴出来，此时，只需在选取之后，按Alt+; ，选中可见单元格，再复制粘贴，隐藏行就会去掉了。鼠标依次点击：数据 - 有效性（验证) - 序列 - 在下方框中，输入以逗号分隔的字符串。小技巧：将工作表的多行内容，使用逗号连在一起，只需使用：=区域，再按F9转为值，之后再替换“，”为逗号，即可完成。选取数据区域之后，按CTRL+G定位，依次选择：定位条件 -空值，再删除行即可。如果使用公式法换行，可使用substitute函数，将空格替换为换行符（char(10))。之后公式所在的单元格设置为自动换行。=SUBSTITUTE(C2," ",CHAR(10))依次选择：视图 - 冻结窗格 - 冻结首行，即可锁定第一行不动。（若是冻结2，则选取第3行 - 窗口 - 冻结窗口）
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2026-08-11 12:39:16 HTTP/1.1 GET : https://www.yeyulingfeng.com/a/881855.html
- 运行时间 : 0.213444s [ 吞吐率：4.69req/s ] 内存消耗：4,611.13kb 文件加载：145
- 缓存信息 : 0 reads,0 writes
- 会话信息 : SESSION_ID=246e9dee3e520d0652a35244d0d0ad3c
- CONNECT:[ UseTime:0.001173s ] mysql:host=127.0.0.1;port=3306;dbname=wenku;charset=utf8mb4
- SHOW FULL COLUMNS FROM `fenlei` [ RunTime:0.001442s ]
- SELECT * FROM `fenlei` WHERE `fid` = 0 [ RunTime:0.000684s ]
- SELECT * FROM `fenlei` WHERE `fid` = 63 [ RunTime:0.000651s ]
- SHOW FULL COLUMNS FROM `set` [ RunTime:0.001298s ]
- SELECT * FROM `set` [ RunTime:0.000553s ]
- SHOW FULL COLUMNS FROM `article` [ RunTime:0.001424s ]
- SELECT * FROM `article` WHERE `id` = 881855 LIMIT 1 [ RunTime:0.006453s ]
- UPDATE `article` SET `lasttime` = 1786423156 WHERE `id` = 881855 [ RunTime:0.008694s ]
- SELECT * FROM `fenlei` WHERE `id` = 64 LIMIT 1 [ RunTime:0.000640s ]
- SELECT * FROM `article` WHERE `id` < 881855 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001136s ]
- SELECT * FROM `article` WHERE `id` > 881855 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.001070s ]
- SELECT * FROM `article` WHERE `id` < 881855 ORDER BY `id` DESC LIMIT 10 [ RunTime:0.001416s ]
- SELECT * FROM `article` WHERE `id` < 881855 ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.002007s ]
- SELECT * FROM `article` WHERE `id` < 881855 ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.004371s ]
0.217109s
夜雨聆风
