当前时间： 2026-06-11 13:01:10
分类：办公文件
评论(0)
Excel冻结窗格(秒懂)表格中遇到，信息比较多的时候，
如何查看信息
更快捷？
更方便？
比如下图，向下移动，表头就看不到
不方便查看
excel有个功能叫【冻结窗格】
帮你解决这个问题，超级简单
只需要三步，
那么安排~！
第一步：选择【视图】
第二步：选择要冻结的位置（图中选的为C3）
第三步：选择【冻结窗格】
标红的位置是冻结的位置
左右拖动，上下拖动，都不会动
这样方便看横向和纵向的信息
看图
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2026-06-12 01:36:11 HTTP/1.1 GET : https://www.yeyulingfeng.com/a/739221.html
- 运行时间 : 0.083400s [ 吞吐率：11.99req/s ] 内存消耗：4,586.99kb 文件加载：145
- 缓存信息 : 0 reads,0 writes
- 会话信息 : SESSION_ID=ced4180b725d51b5d652fbae47fc15c1
- CONNECT:[ UseTime:0.000432s ] mysql:host=127.0.0.1;port=3306;dbname=wenku;charset=utf8mb4
- SHOW FULL COLUMNS FROM `fenlei` [ RunTime:0.000753s ]
- SELECT * FROM `fenlei` WHERE `fid` = 0 [ RunTime:0.000293s ]
- SELECT * FROM `fenlei` WHERE `fid` = 63 [ RunTime:0.000269s ]
- SHOW FULL COLUMNS FROM `set` [ RunTime:0.000567s ]
- SELECT * FROM `set` [ RunTime:0.000213s ]
- SHOW FULL COLUMNS FROM `article` [ RunTime:0.000569s ]
- SELECT * FROM `article` WHERE `id` = 739221 LIMIT 1 [ RunTime:0.000449s ]
- UPDATE `article` SET `lasttime` = 1781199371 WHERE `id` = 739221 [ RunTime:0.001231s ]
- SELECT * FROM `fenlei` WHERE `id` = 64 LIMIT 1 [ RunTime:0.000455s ]
- SELECT * FROM `article` WHERE `id` < 739221 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000582s ]
- SELECT * FROM `article` WHERE `id` > 739221 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000563s ]
- SELECT * FROM `article` WHERE `id` < 739221 ORDER BY `id` DESC LIMIT 10 [ RunTime:0.001034s ]
- SELECT * FROM `article` WHERE `id` < 739221 ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.002588s ]
- SELECT * FROM `article` WHERE `id` < 739221 ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.000869s ]
0.085157s
夜雨聆风
