聪明文档网
最新最全的文档下载
当前位置：
首页> EXCEL顶端标题行与页脚设置图文教程
EXCEL顶端标题行与页脚设置图文教程
时间：2018-06-30 22:36:17 下载该word文档
EXCEL顶端标题行与页脚设置图文教程
顶端标题行与页脚设置可以使EXCEL打印时，无论你的EXCEL表格有多少行，打印出来的每一页EXCEL表都会有固定的标题与底部。
![](https://wkrtcs.bdimg.com/rtcs/image?w=553&md5sum=5bba9f0449f40bf00211bd308cf33f22&sign=0ae91f9e17&rtcs_flag=1&rtcs_ver=3.1&l=webapp&bucketNum=28&ipr={"t":"img","w":"553","h":"82","dataType":"png","c":"word/media/image1.png","imgOriW":922,"imgOriH":137})
标题：
![](https://wkrtcs.bdimg.com/rtcs/image?w=553&md5sum=5bba9f0449f40bf00211bd308cf33f22&sign=0ae91f9e17&rtcs_flag=1&rtcs_ver=3.1&l=webapp&bucketNum=28&ipr={"t":"img","w":"553","h":"24","dataType":"png","c":"word/media/image2.png","imgOriW":916,"imgOriH":39})
页尾：
一、标题设置教程：
文件—页面设置—工作表—打印标题中顶端标题行—选择需要设定的顶端标题行区域![](https://wkrtcs.bdimg.com/rtcs/image?w=467&md5sum=5bba9f0449f40bf00211bd308cf33f22&sign=0ae91f9e17&rtcs_flag=1&rtcs_ver=3.1&l=webapp&bucketNum=28&ipr={"t":"img","w":"467","h":"341","dataType":"png","c":"word/media/image3.png","imgOriW":467,"imgOriH":341})
![](https://wkrtcs.bdimg.com/rtcs/image?w=323&md5sum=5bba9f0449f40bf00211bd308cf33f22&sign=0ae91f9e17&rtcs_flag=1&rtcs_ver=3.1&l=webapp&bucketNum=28&ipr={"t":"img","w":"323","h":"29","dataType":"png","c":"word/media/image4.png","imgOriW":323,"imgOriH":29})
打开页面设置工作表界面，如上图。
![](https://wkrtcs.bdimg.com/rtcs/image?w=335&md5sum=5bba9f0449f40bf00211bd308cf33f22&sign=0ae91f9e17&rtcs_flag=1&rtcs_ver=3.1&l=webapp&bucketNum=28&ipr={"t":"img","w":"335","h":"43","dataType":"png","c":"word/media/image5.png","imgOriW":335,"imgOriH":43})
点击顶端标题行右边按钮。
![](https://wkrtcs.bdimg.com/rtcs/image?w=546&md5sum=5bba9f0449f40bf00211bd308cf33f22&sign=0ae91f9e17&rtcs_flag=1&rtcs_ver=3.1&l=webapp&bucketNum=28&ipr={"t":"img","w":"546","h":"93","dataType":"png","c":"word/media/image7.png","imgOriW":975,"imgOriH":166})
![](https://wkrtcs.bdimg.com/rtcs/image?w=467&md5sum=5bba9f0449f40bf00211bd308cf33f22&sign=0ae91f9e17&rtcs_flag=1&rtcs_ver=3.1&l=webapp&bucketNum=28&ipr={"t":"img","w":"467","h":"50","dataType":"png","c":"word/media/image8.png","imgOriW":467,"imgOriH":50})
进入区域选择界面，选取每页需要打印出来的标题。如上图所示，选取到的地方将有虚线围绕。
选取完成后点击如上图中的上图中![](https://wkrtcs.bdimg.com/rtcs/image?w=31&md5sum=5bba9f0449f40bf00211bd308cf33f22&sign=0ae91f9e17&rtcs_flag=1&rtcs_ver=3.1&l=webapp&bucketNum=28&ipr={"t":"img","w":"31","h":"18","dataType":"png","c":"word/media/image9.png","imgOriW":31,"imgOriH":18})
按钮返回以下界面。
![](https://wkrtcs.bdimg.com/rtcs/image?w=467&md5sum=5bba9f0449f40bf00211bd308cf33f22&sign=0ae91f9e17&rtcs_flag=1&rtcs_ver=3.1&l=webapp&bucketNum=28&ipr={"t":"img","w":"467","h":"341","dataType":"png","c":"word/media/image10.png","imgOriW":467,"imgOriH":341})
点击确定后完成顶端标题行的设置。
二、页尾教程：
和顶端标题行设置类似。
文件—页面设置—页眉/页脚—自定义页脚—填写相应信息。
![](https://wkrtcs.bdimg.com/rtcs/image?w=467&md5sum=5bba9f0449f40bf00211bd308cf33f22&sign=0ae91f9e17&rtcs_flag=1&rtcs_ver=3.1&l=webapp&bucketNum=28&ipr={"t":"img","w":"467","h":"341","dataType":"png","c":"word/media/image11.png","imgOriW":467,"imgOriH":341})
进入页面设置中页眉/页脚界面如上图所示。
![](https://wkrtcs.bdimg.com/rtcs/image?w=550&md5sum=5bba9f0449f40bf00211bd308cf33f22&sign=0ae91f9e17&rtcs_flag=1&rtcs_ver=3.1&l=webapp&bucketNum=28&ipr={"t":"img","w":"550","h":"217","dataType":"png","c":"word/media/image12.png","imgOriW":663,"imgOriH":261})
点击自定义页脚，进入上图所示界面。
![](https://wkrtcs.bdimg.com/rtcs/image?w=550&md5sum=5bba9f0449f40bf00211bd308cf33f22&sign=0ae91f9e17&rtcs_flag=1&rtcs_ver=3.1&l=webapp&bucketNum=28&ipr={"t":"img","w":"550","h":"217","dataType":"png","c":"word/media/image13.png","imgOriW":663,"imgOriH":261})
按上图所示填入需要页脚显示的内容，然后点击确定完成页脚设置。
Word文档免费下载：
EXCEL顶端标题行与页脚设置图文教程
-
1个月 推荐
￥29.8
￥45每天只需1.0元 -
1天
￥9.9
￥15 -
3个月
￥59.8
￥90
选择支付方式
-
微信付款
郑重提醒：支付后，系统自动为您完成注册
