}},"imageContentData":[{"title":"选择数据行","num":"1","image":"https://gimg3.baidu.com/topone/src=https://exp-picture.cdn.bcebos.com/baab2086304861434c8e60868febf6a75e0f53f1.jpg&refer=http://www.baidu.com&app=2011&size=w931&n=0&g=0n&er=404&q=100&fmt=auto&maxorilen2heic=2000000?sec=1693069200&t=2bc8e3bd8f074511db803016994cbd7d","gif":"","content":"excel表格中,选择需要冻结的前几行中的下一行,比如要冻结前4行,就选中第5行。","text":"excel表格中,选择需要冻结的前几行中的下一行,比如要冻结前4行,就选中第5行。","show":"https://exp-picture.cdn.bcebos.com/baab2086304861434c8e60868febf6a75e0f53f1.jpg"},{"title":"点击视图","num":"2","image":"https://gimg3.baidu.com/topone/src=https://exp-picture.cdn.bcebos.com/3fc72e486143d7d4d46b2c5c7da75f0f832b50f1.jpg&refer=http://www.baidu.com&app=2011&size=w931&n=0&g=0n&er=404&q=100&fmt=auto&maxorilen2heic=2000000?sec=1693069200&t=d10d92b096edf74882c18d904d680f","gif":"","content":"点击菜单栏“视图”。","text":"点击菜单栏“视图”。","show":"https://exp-picture.cdn.bcebos.com/3fc72e486143d7d4d46b2c5c7da75f0f832b50f1.jpg"},{"title":"点击冻结窗格","num":"3","image":"https://gimg3.baidu.com/topone/src=https://exp-picture.cdn.bcebos.com/31097f43d7d4483199b1de10d40f822b75ee51f1.jpg&refer=http://www.baidu.com&app=2011&size=w931&n=0&g=0n&er=404&q=100&fmt=auto&maxorilen2heic=2000000?sec=1693069200&t=821f27d10fbc3f0efb411157b1571bbd","gif":"","content":"点击视图选项中的“冻结窗格”。","text":"点击视图选项中的“冻结窗格”。","show":"https://exp-picture.cdn.bcebos.com/31097f43d7d4483199b1de10d40f822b75ee51f1.jpg"}],"consultData":{"btnText":"咨询","img":"https://gips0.baidu.com/it/u=2672280171,497272173&fm=3012&app=3012&autime=1692601995&size=b360,360","name":"互联网实用攻略","url":"https://activity.baidu.com/mbox/4a83aa9f/matrixShareSimple?payAskIMExp=1&fr=pay_zd_searchdqa_assign&trfsr=bdappdqa&uk=e8794069236f25705e79d204&cate=3CIT&resourceId=302&searchId=12138321812058969246&query=%E5%A6%82%E4%BD%95%E6%8A%8Aexcel%E7%9A%84%E5%%8D4%E8%A1%8C%E5%86%BB%E7%BB%93","introduction":"已帮助72人 1对1咨询","score":"4.5分","isFeedback":true,"dataModule":"direct_person_b","urlParams":{"type":"tc","tcUrl":"https://m.baidu.com/from=844b/bd_page_type=1/ssid=0/uid=0/pu=usm%4014%2Csz%401320_220%2Cta%40iphone___24_114.0/baiduid=F1BD74DD0C366F1BB70FB12F7BD26085/w=0_10_/t=iphone/l=1/tc?ref=www_iphone&lid=121383218120569246&order=1&fm=alop&isAtom=1&clk_info=%7B%22tplname%22:%22wenda_abstract%22%2C%22srcid%22:%2236402%22%2C%22jumpType%22:%22%22%7D&is_baidu=0&tj=9za_1_0_10_l1&wd=&eqid=a873fb606126949e1000000464e805c2&w_qd=IlPT2AEptyoA_yk57eId6hWuJSzSOa_nGpJbkKixz7s7X3IyXShcy7K&bdver=2_1&tcplug=1&dict=-1&sec=32257&di=4708e5c6ece2c225&bdenc=1&nsrc=ymSSqmJYks1v0lJAbU3gpXg93N7bymY4O/O9iVFlHXokQbDzsHDbEPRBVpRDk6AOIdP3ZjOixauIu5ms3xDognZ2gXFxFGB2vK%2BYIy2l4ciGTo2S86WYuFnYRlsoVHXxP6bN%2BrICkgtvUb/9i0EBAolU5MAnkkDKipGJEMaS/BazMriAqb4RmRCrBG68LN7taA/jIvk8oZQrsEIVk4ReoQRDLPuERD6jc9W20ENbLNSZDovz2ssVfYlEyv000coUv1%2BII8cUT1CFda1CXgdX/4/H7oTxCSBuNZGsb8lJpGY4tXz55uWKTfuV1gENHFQm9ob8cUGey%2BjTL0Gr7R0QftbzaWRNTQ9gYf8kI9tAeBNnu/bDSbqsjYrqRHmsdboF6gWLukYFn65%2BrfhffJeHbXixStpHstPobZgMvKF5j/nCmFjPibrNze2Sr6E4uoglKVhNj493ARjfHHS8kXZM8A%3D%3D","originUrl":"https://activity.baidu.com/mbox/4a83aa9f/matrixShareSimple?payAskIMExp=1&fr=pay_zd_searchdqa_assign&trfsr=bdappdqa&uk=e8794069236f25705e79d204&cate=3CIT&resourceId=36402&searchId=121383218120569246&query=%E5%A6%82%E4%BD%95%E6%8A%8Aexcel%E7%9A%84%E5%%8D4%E8%A1%8C%E5%86%BB%E7%BB%93","log":"{'e':'IlPT2AEptyoA_yixCFOxCGZb8c3JV3T5ABOSQSVC_yqn95u7gfTqXdNpX8KhVnKYHF7wdoTKgBUCcSWiOWAizBAxg4skcTJneCWstamLqcj3UM11f0Mo_cfjWycFrAnmn0wd9NNoRtBnR8-cffLpbvQ9beiTvAJfjhPZwCDQeLz_CVKdV67G7pm9MZwSCZPfW0uFsRfnfG9dHl7n2tTASY74sXRJFydcag7t73JHONTYmHIyK2unIsFREo8JAj9O_q7RAPnvlh3SE6MO87J7Lk5Q5HaYgOOII8tBWhj4mKp7UavuUgn2NIiBLxlPvASLJ0cpG0P_suxuPmlph5-nFmxYB0ajQICGDpA9EPX-vBiiLU6po7ToM0TPoS2fD1HCTd9SBqgOCHx8r8rvmdmmwZ7xNgP1gN2LTRhhPpvdn5l16n5aKVOjgVbE-7Y0giHLBl00QHGLFxST3zxOkc0FMaWK1R7DXF24mneptoiluZGDVceJRcUSwIwGlFEJ3We3hLjbHjG','c':''}","hrsf":1,"clickData":"{'clk_info':{'jumpType':''}}"}},"content":"excel想要表格冻结前几行,先选中要冻结的这几行的下一行之后,通过冻结窗格功能来实现即可。选择数据行。excel表格中,选择需要冻结的前几行中的下一行,比如要冻结前4行,就选中第5行。excel表格中,选择需要冻结的前几行中的下一行,比如要冻结前4行,就选中第5行。点击视图。点击菜单栏“视图”。点击菜单栏“视图”。点击冻结窗格。点击视图选项中的“冻结窗格”。点击视图选项中的“冻结窗格”。
小编还为您整理了以下内容,可能对您也有帮助:
excel表格冻结某一行或几行窗口的方法
在excel表格中设置冻结某一行或几行窗口的方法步骤如下:
一、首先打开需要冻结的表格,选择菜单栏里的视图,冻结工具在这个菜单下如图;
二、可以看到冻结窗格功能下有三个选项,一般表格需要冻结首行,以便浏览到下面的时候还能看到标题;
三、有时候标题有多个,例如主标题和副标题,此时需要冻结两行,把鼠标定位到需要冻结的下一行;
四、选择冻结窗格选项下拉菜单里的冻结拆分窗格选项即可。
五、此时可以看到,往下滚动的时候,前两行主标题和副标题仍然在最上面,完成!
Copyright © 2019- cjnw.cn 版权所有
违法及侵权请联系:TEL:199 18 7713 E-MAIL:2724546146@qq.com
本站由北京市万商天勤律师事务所王兴未律师提供法律服务