当前时间： 2026-07-23 20:51:22
分类：办公文件
评论(0)
会计人 Excel 常用快捷键清单Ctrl + C / V / X 复制 / 粘贴 / 剪切Ctrl + Shift + ; 输入当前时间 记录对账时间点Alt + ↓ 下拉菜单 快速选择之前输入过的内容Ctrl + B / I / U 加粗 / 斜体 / 下划线 突出合计行Ctrl + Shift + 4 设为货币格式（¥） 金额列Ctrl + Shift + 5 设为百分比（%） 税率列Ctrl + → / ← / ↑ / ↓ 跳到数据区域边缘 快速到表尾Ctrl + Shift + → 选中到右边缘 选中整行数据Ctrl + Page Down/Up 切换工作表（标签页）会计人私藏技巧
- 一键美化表格：选中数据 → Ctrl + T 转为超级表，自动带筛选和隔行色。
- 复制时保留列宽：粘贴后按 Ctrl 再按 W → 选择“保留源列宽”。
建议：把这张表打印出来贴在电脑旁，或者设置为电脑桌面壁纸（深色模式）。每天刻意用3 个新快捷键，一周后效率明显提升。
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2026-07-23 20:59:51 HTTP/1.1 GET : https://www.yeyulingfeng.com/a/872723.html
- 运行时间 : 0.368004s [ 吞吐率：2.72req/s ] 内存消耗：4,721.07kb 文件加载：145
- 缓存信息 : 0 reads,0 writes
- 会话信息 : SESSION_ID=df3151b149fd0a7e2a9740782c76e25a
- CONNECT:[ UseTime:0.000501s ] mysql:host=127.0.0.1;port=3306;dbname=wenku;charset=utf8mb4
- SHOW FULL COLUMNS FROM `fenlei` [ RunTime:0.000666s ]
- SELECT * FROM `fenlei` WHERE `fid` = 0 [ RunTime:0.007676s ]
- SELECT * FROM `fenlei` WHERE `fid` = 63 [ RunTime:0.018901s ]
- SHOW FULL COLUMNS FROM `set` [ RunTime:0.000753s ]
- SELECT * FROM `set` [ RunTime:0.003184s ]
- SHOW FULL COLUMNS FROM `article` [ RunTime:0.000642s ]
- SELECT * FROM `article` WHERE `id` = 872723 LIMIT 1 [ RunTime:0.006296s ]
- UPDATE `article` SET `lasttime` = 1784811591 WHERE `id` = 872723 [ RunTime:0.017629s ]
- SELECT * FROM `fenlei` WHERE `id` = 64 LIMIT 1 [ RunTime:0.007305s ]
- SELECT * FROM `article` WHERE `id` < 872723 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003662s ]
- SELECT * FROM `article` WHERE `id` > 872723 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.007021s ]
- SELECT * FROM `article` WHERE `id` < 872723 ORDER BY `id` DESC LIMIT 10 [ RunTime:0.003048s ]
- SELECT * FROM `article` WHERE `id` < 872723 ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.065449s ]
- SELECT * FROM `article` WHERE `id` < 872723 ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.129232s ]
0.371281s
夜雨聆风