excel设置表头固定不动的方法如下:
工具:华硕VivoBook15x
系统:win10
软件:excel2021
1、点击选中任意单元格,依次点击【视图】-【冻结窗口】-【冻结首行】。
![](https://iknow-pic.cdn.bcebos.com/10dfa9ec8a136327b532b5a6838fa0ec09fac74c?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、返回到工作表中,用户拖动鼠标,则工作表中的表头则会保持固定的位置,不会随之移动。
![](https://iknow-pic.cdn.bcebos.com/0bd162d9f2d3572cc23deb499813632763d0c34c?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、如果要取消以上操作步骤,则鼠标依次点击【视图】-【冻结窗格】-【取消冻结窗格】。
![](https://iknow-pic.cdn.bcebos.com/a8ec8a13632762d02fe1d32ab2ec08fa503dc64c?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、返回到工作表中,则表头的位置又会随着鼠标的拖动而发生变化。
![](https://iknow-pic.cdn.bcebos.com/f603918fa0ec08fa8ddf64324bee3d6d54fbda4c?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
固定excel表头一般是在页面布局里面设置顶端标题行即可,具体操作如下:
工具/原料:Lenovo天逸510S、Windows10、Excel14931.20132
1、点击页面布局
进入到excel的软件界面,点击上方的页面布局的选项卡。
![](https://iknow-pic.cdn.bcebos.com/342ac65c103853436f920eb48113b07ecb8088c2?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、勾选打印选项
勾选工作表选项里面的打印选项,再点击下方的箭头符号。
![](https://iknow-pic.cdn.bcebos.com/023b5bb5c9ea15cebcb3699ca4003af33b87b2c2?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、选中要固定的表头
弹出设置框后,点击顶端标题行右侧的箭头,在输入框内选中你要固定的表头。
![](https://iknow-pic.cdn.bcebos.com/3b87e950352ac65c8258efe6e9f2b21192138ac2?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、点击确定按钮
再点击箭头符号返回设置框界面,点击下方的确定按钮。
![](https://iknow-pic.cdn.bcebos.com/37d3d539b6003af3b4e755f5272ac65c1138b6c2?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、点击文件选项卡
点击左上角的文件选项卡,再点击左侧导航栏里面的打印选项,这样你的表头在每页都会有了。
![](https://iknow-pic.cdn.bcebos.com/e850352ac65c1038c0234757a0119313b17e89c2?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
材料/工具:Excel2010
1、首先打开一个表格,由于没有现成的表格,现在新建一个表格,然后输入标题栏就以这个为例,方法一样
![](https://iknow-pic.cdn.bcebos.com/0823dd54564e9258bd64998c9282d158ccbf4e7b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、可以看到,现在如果要是滑动滚动条的话,标题栏就会被遮挡住,就看不到了
![](https://iknow-pic.cdn.bcebos.com/dc54564e9258d109de85b6d0df58ccbf6c814d69?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、在上面菜单栏,单击“视图”菜单栏
![](https://iknow-pic.cdn.bcebos.com/63d9f2d3572c11df5973a0416d2762d0f703c236?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、在第二行的子菜单栏有一个“冻结窗格”选项,单击“冻结窗格”
![](https://iknow-pic.cdn.bcebos.com/14ce36d3d539b600190b10d5e750352ac75cb78e?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、有三个选项,冻结拆分窗格,冻结首行,冻结首列,本文设置的是标题行,所以选择“冻结首行”单击设置
![](https://iknow-pic.cdn.bcebos.com/f3d3572c11dfa9ec7bb949756cd0f703918fc139?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、设置完成以后,就可以看到一条分界线,说明设置成功
![](https://iknow-pic.cdn.bcebos.com/4610b912c8fcc3ce5121d6519c45d688d53f20ea?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
7、也可以再次滑动滚动条,查看设置效果
![](https://iknow-pic.cdn.bcebos.com/d058ccbf6c81800a6bcf976cbf3533fa828b47ad?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)