当前时间： 2026-06-10 10:54:21
分类：办公文件
评论(0)
Excel提效必备:向下填充Ctrl+DCtrl+D是Excel里向下填充的快捷键，是 Excel 提效核心快捷键之一，能解决我们日常90%的批量填充问题。操作效果：把选中区域的内容、公式、格式，一次性复制到区域内下方单元格。1、通常我们可以先Ctrl+C，然后Ctrl+V。3、直接选中要填充的单元格（上一行有内容的区域可选可不选），按Ctrl+D即可。中间有空白行，也不影响Ctrl+D的向下填充功能。（有内容的单元格要一起选中）学会Ctrl+D，工作中用这个快捷键来代替Ctrl+C，然后Ctrl+V。小小的改动，就可以事半功倍，这下摸鱼的时间又增加啦😄Excel里面还有哪些快捷键小技巧，欢迎大家补充~
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2026-06-12 02:20:30 HTTP/1.1 GET : https://www.yeyulingfeng.com/a/735749.html
- 运行时间 : 0.176976s [ 吞吐率：5.65req/s ] 内存消耗：4,696.00kb 文件加载：145
- 缓存信息 : 0 reads,0 writes
- 会话信息 : SESSION_ID=ced4180b725d51b5d652fbae47fc15c1
- CONNECT:[ UseTime:0.001038s ] mysql:host=127.0.0.1;port=3306;dbname=wenku;charset=utf8mb4
- SHOW FULL COLUMNS FROM `fenlei` [ RunTime:0.001810s ]
- SELECT * FROM `fenlei` WHERE `fid` = 0 [ RunTime:0.000739s ]
- SELECT * FROM `fenlei` WHERE `fid` = 63 [ RunTime:0.000637s ]
- SHOW FULL COLUMNS FROM `set` [ RunTime:0.001651s ]
- SELECT * FROM `set` [ RunTime:0.000716s ]
- SHOW FULL COLUMNS FROM `article` [ RunTime:0.001738s ]
- SELECT * FROM `article` WHERE `id` = 735749 LIMIT 1 [ RunTime:0.000991s ]
- UPDATE `article` SET `lasttime` = 1781202030 WHERE `id` = 735749 [ RunTime:0.001831s ]
- SELECT * FROM `fenlei` WHERE `id` = 64 LIMIT 1 [ RunTime:0.000648s ]
- SELECT * FROM `article` WHERE `id` < 735749 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001342s ]
- SELECT * FROM `article` WHERE `id` > 735749 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.001093s ]
- SELECT * FROM `article` WHERE `id` < 735749 ORDER BY `id` DESC LIMIT 10 [ RunTime:0.002297s ]
- SELECT * FROM `article` WHERE `id` < 735749 ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.003011s ]
- SELECT * FROM `article` WHERE `id` < 735749 ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.003307s ]
0.178670s
夜雨聆风
