Warning: Use of undefined constant title - assumed 'title' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/data/tmp/tempnews1.php on line 152 冻结窗口,详细教您如何冻结Excel表格窗口
- 分类：win7 发布时间： Warning: Use of undefined constant newstime - assumed 'newstime' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/data/tmp/tempnews1.php on line 156 2018年05月24日 17:07:00
在Excel中查看规模比较大的工作表时，都比较难比较表中的不同部分的数据，这时候我们就可以利用工作表中的冻结窗口功能来固定窗口，可是即使很多用户在使用Excel，懂得冻结窗口的用户却不多，下面，小编就来跟大家讲解冻结Excel表格窗口的技巧。
我们都知道excel这款软件的便利，它有一个特别的功能就是冻结窗口，它是为了查看报表数据方便而设计的，便于浏览数据，特别是在统计数据的时候，“冻结窗口”功能就显得尤为重要，怎么冻结excel窗口，下面，小编给大伙演示冻结Excel表格窗口的的操作流程。
如何冻结Excel表格窗口
以冻结第三行的窗口为例。
冻结电脑图解-1
鼠标点击先选中第四行，在菜单栏点击“视图”→“冻结窗格”→“冻结拆分窗格”。
Excel电脑图解-2
这样鼠标向下滚动，黑色粗线以上的单元格就固定不动了。简单来说，就是点击你需要冻结的第几行单元格的下一行。
冻结窗口电脑图解-3
如果想把该项设置取消，同样在菜单栏点击“视图”，然后是“冻结窗格”→“取消冻结窗格”，这样刚才的设置就取消了。
表格电脑图解-4
如果想冻结窗口的某几行某几列窗口，鼠标向下滚动时这些行和列怎样都固定不动呢?
下面我们就以冻结第九行第C列的窗口为例。鼠标点击选中D10单元格，在菜单栏点击“视图”→“冻结窗格”→“冻结拆分窗格”。也就是说，点击你需要冻结的第几行第几列单元格的下一行下一列单元格的交集。
冻结窗口电脑图解-5
冻结窗口后，鼠标向下滚动，箭头所指直线以上的单元格就固定不动了。
Excel电脑图解-6
同样，把滚动条往右再往下拖，可以看到框线所指位置固定不动。
冻结电脑图解-7
如果我们想把这些设置取消，同样在菜单栏点击“视图”，然后是“冻结窗格”→“取消冻结窗格”，这样刚才的设置就取消了。
表格电脑图解-8
以上就是冻结Excel表格窗口的的操作方法了，相信看完之后对大家一定有所帮助。
上一篇：
Warning: Use of undefined constant classid - assumed 'classid' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/data/tmp/tempnews1.php on line 211
Warning: Use of undefined constant tbname - assumed 'tbname' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/data/tmp/tempnews1.php on line 211
Warning: Use of undefined constant id - assumed 'id' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/data/tmp/tempnews1.php on line 212
Warning: Use of undefined constant title - assumed 'title' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/data/tmp/tempnews1.php on line 217
清理系统垃圾,详细教您要怎么样清理系统垃圾
下一篇：
Warning: Use of undefined constant classid - assumed 'classid' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/data/tmp/tempnews1.php on line 222
Warning: Use of undefined constant tbname - assumed 'tbname' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/data/tmp/tempnews1.php on line 222
Warning: Use of undefined constant id - assumed 'id' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/data/tmp/tempnews1.php on line 223
Warning: Use of undefined constant title - assumed 'title' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/data/tmp/tempnews1.php on line 228
tracert,详细教您tracert命令使用详解
猜您喜欢
- 手把手教你如何安装win7系统..2019/01/05
- 小编教你设置win7管理员权限..2017/10/10
- 浅析Win7系统下的wmi控件及它的功能作..2021/01/16
- 如何优化笔记本win7系统性能：实用技巧..2024/07/19
- gtx590,详细教您网速很快打开网页很慢..2018/03/21
- 主编教您电脑怎么显示文件..2019/03/01
相关推荐
-
Warning: Use of undefined constant islast - assumed 'islast' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/t_functions.php on line 296
Warning: Use of undefined constant tbname - assumed 'tbname' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/t_functions.php on line 305
Warning: Use of undefined constant modid - assumed 'modid' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/t_functions.php on line 306
Warning: Use of undefined constant yhid - assumed 'yhid' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/t_functions.php on line 307
Warning: Use of undefined constant classid - assumed 'classid' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/t_functions.php on line 673
Warning: Use of undefined constant bname - assumed 'bname' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/t_functions.php on line 673
Warning: Use of undefined constant classid - assumed 'classid' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/t_functions.php on line 673
Warning: Use of undefined constant bname - assumed 'bname' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/t_functions.php on line 673
Warning: Use of undefined constant classid - assumed 'classid' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2418
Warning: Use of undefined constant wburl - assumed 'wburl' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2418
Warning: Use of undefined constant classid - assumed 'classid' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2423
Warning: Use of undefined constant listdt - assumed 'listdt' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2423
Warning: Use of undefined constant classid - assumed 'classid' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2428
Warning: Use of undefined constant classurl - assumed 'classurl' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2428
Warning: Use of undefined constant newsurl - assumed 'newsurl' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2434
Warning: Use of undefined constant classid - assumed 'classid' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2434
Warning: Use of undefined constant classpath - assumed 'classpath' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2434
Warning: Use of undefined constant classid - assumed 'classid' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2436
Warning: Use of undefined constant bname - assumed 'bname' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2436
Warning: Use of undefined constant classid - assumed 'classid' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2439
Warning: Use of undefined constant bname - assumed 'bname' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2439
- 怎么重装系统win7 2019-07-13 Warning: Use of undefined constant classid - assumed 'classid' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/t_functions.php on line 673 Warning: Use of undefined constant bname - assumed 'bname' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/t_functions.php on line 673 Warning: Use of undefined constant classid - assumed 'classid' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/t_functions.php on line 673 Warning: Use of undefined constant bname - assumed 'bname' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/t_functions.php on line 673 Warning: Use of undefined constant classid - assumed 'classid' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2418 Warning: Use of undefined constant wburl - assumed 'wburl' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2418 Warning: Use of undefined constant classid - assumed 'classid' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2423 Warning: Use of undefined constant listdt - assumed 'listdt' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2423 Warning: Use of undefined constant classid - assumed 'classid' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2428 Warning: Use of undefined constant classurl - assumed 'classurl' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2428 Warning: Use of undefined constant newsurl - assumed 'newsurl' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2434 Warning: Use of undefined constant classid - assumed 'classid' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2434 Warning: Use of undefined constant classpath - assumed 'classpath' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2434 Warning: Use of undefined constant classid - assumed 'classid' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2436 Warning: Use of undefined constant bname - assumed 'bname' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2436 Warning: Use of undefined constant classid - assumed 'classid' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2439 Warning: Use of undefined constant bname - assumed 'bname' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2439
- 细说微软账号如何注册 2019-04-03 Warning: Use of undefined constant classid - assumed 'classid' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/t_functions.php on line 673 Warning: Use of undefined constant bname - assumed 'bname' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/t_functions.php on line 673 Warning: Use of undefined constant classid - assumed 'classid' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/t_functions.php on line 673 Warning: Use of undefined constant bname - assumed 'bname' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/t_functions.php on line 673 Warning: Use of undefined constant classid - assumed 'classid' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2418 Warning: Use of undefined constant wburl - assumed 'wburl' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2418 Warning: Use of undefined constant classid - assumed 'classid' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2423 Warning: Use of undefined constant listdt - assumed 'listdt' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2423 Warning: Use of undefined constant classid - assumed 'classid' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2428 Warning: Use of undefined constant classurl - assumed 'classurl' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2428 Warning: Use of undefined constant newsurl - assumed 'newsurl' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2434 Warning: Use of undefined constant classid - assumed 'classid' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2434 Warning: Use of undefined constant classpath - assumed 'classpath' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2434 Warning: Use of undefined constant classid - assumed 'classid' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2436 Warning: Use of undefined constant bname - assumed 'bname' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2436 Warning: Use of undefined constant classid - assumed 'classid' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2439 Warning: Use of undefined constant bname - assumed 'bname' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2439
- 制作win7 ghost安装u盘方法 2017-08-23 Warning: Use of undefined constant classid - assumed 'classid' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/t_functions.php on line 673 Warning: Use of undefined constant bname - assumed 'bname' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/t_functions.php on line 673 Warning: Use of undefined constant classid - assumed 'classid' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/t_functions.php on line 673 Warning: Use of undefined constant bname - assumed 'bname' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/t_functions.php on line 673 Warning: Use of undefined constant classid - assumed 'classid' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2418 Warning: Use of undefined constant wburl - assumed 'wburl' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2418 Warning: Use of undefined constant classid - assumed 'classid' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2423 Warning: Use of undefined constant listdt - assumed 'listdt' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2423 Warning: Use of undefined constant classid - assumed 'classid' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2428 Warning: Use of undefined constant classurl - assumed 'classurl' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2428 Warning: Use of undefined constant newsurl - assumed 'newsurl' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2434 Warning: Use of undefined constant classid - assumed 'classid' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2434 Warning: Use of undefined constant classpath - assumed 'classpath' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2434 Warning: Use of undefined constant classid - assumed 'classid' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2436 Warning: Use of undefined constant bname - assumed 'bname' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2436 Warning: Use of undefined constant classid - assumed 'classid' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2439 Warning: Use of undefined constant bname - assumed 'bname' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2439
- Windows7官网科普：如何安全升级系统，保.. 2024-10-13 Warning: Use of undefined constant classid - assumed 'classid' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/t_functions.php on line 673 Warning: Use of undefined constant bname - assumed 'bname' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/t_functions.php on line 673 Warning: Use of undefined constant classid - assumed 'classid' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/t_functions.php on line 673 Warning: Use of undefined constant bname - assumed 'bname' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/t_functions.php on line 673 Warning: Use of undefined constant classid - assumed 'classid' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2418 Warning: Use of undefined constant wburl - assumed 'wburl' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2418 Warning: Use of undefined constant classid - assumed 'classid' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2423 Warning: Use of undefined constant listdt - assumed 'listdt' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2423 Warning: Use of undefined constant classid - assumed 'classid' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2428 Warning: Use of undefined constant classurl - assumed 'classurl' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2428 Warning: Use of undefined constant newsurl - assumed 'newsurl' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2434 Warning: Use of undefined constant classid - assumed 'classid' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2434 Warning: Use of undefined constant classpath - assumed 'classpath' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2434 Warning: Use of undefined constant classid - assumed 'classid' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2436 Warning: Use of undefined constant bname - assumed 'bname' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2436 Warning: Use of undefined constant classid - assumed 'classid' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2439 Warning: Use of undefined constant bname - assumed 'bname' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2439
- UAC怎么关闭,详细教您怎么关闭UAC.. 2018-09-25 Warning: Use of undefined constant classid - assumed 'classid' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/t_functions.php on line 673 Warning: Use of undefined constant bname - assumed 'bname' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/t_functions.php on line 673 Warning: Use of undefined constant classid - assumed 'classid' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/t_functions.php on line 673 Warning: Use of undefined constant bname - assumed 'bname' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/t_functions.php on line 673 Warning: Use of undefined constant classid - assumed 'classid' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2418 Warning: Use of undefined constant wburl - assumed 'wburl' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2418 Warning: Use of undefined constant classid - assumed 'classid' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2423 Warning: Use of undefined constant listdt - assumed 'listdt' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2423 Warning: Use of undefined constant classid - assumed 'classid' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2428 Warning: Use of undefined constant classurl - assumed 'classurl' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2428 Warning: Use of undefined constant newsurl - assumed 'newsurl' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2434 Warning: Use of undefined constant classid - assumed 'classid' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2434 Warning: Use of undefined constant classpath - assumed 'classpath' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2434 Warning: Use of undefined constant classid - assumed 'classid' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2436 Warning: Use of undefined constant bname - assumed 'bname' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2436 Warning: Use of undefined constant classid - assumed 'classid' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2439 Warning: Use of undefined constant bname - assumed 'bname' (this will throw an Error in a future version of PHP) in /data/www.zhuangjiba.com/web/e/class/connect.php on line 2439
- 处理win764位和32位有什么区别.. 2019-05-11
