EXCEL标
行的冻结和打印
选定excel
中某个合适的单元格,从“窗口”菜单中单击“冻结窗格”,其冻结的是选定单元格上面的行和左边的列。
EXCEL标题行的冻结和打印
EXCEL的一些有用的功能:
冻结窗口(窗口),筛选(开始、数据)
Excel做几十、几百行的表格很平常。看下部的数据时看不到表格的标题行,让人搞不清每一列的天文数字究竟代表什么意思。而且正常打印输出时,只有第一页能打印出标题行,其余各页则是光秃秃的,单独
看后几页内容又让人不知所以然。我们看怎么解决这种问题。
一、让每一页都显示标题行
单击表格标题行下边那行最前端的单元格,单击“窗口”菜单?拆分,这时表格会被分割线分成上下两部分,第一部分显示为标题行,第二部分显示为表格具体数据(如图1),接着再单击“窗口”菜单?冻结窗口,
这时再试着翻页看一下,是不是每页都有标题行了(如图2)。
the moment can not solve or do not have the conditions to solve, to explain, and report to the Bureau (. Ten) the existence of false statements of work in the situation. The outlook appears deviation, did not sink in the heart, in the investigation and management of security risks, fighting rule violations and other specific work, only the data that go up, the work has been done on the surface, good, so in the statistical data and submit
注意:假如还想同时在左侧也冻结一列或几列,就应单击表格标题行下边那行从最前端数的第一或第二个……单元格,因为拆分窗口的依据是光标所在单元格。但是光标也能够在任意处进行拆分,然后再把鼠标指针指向横向或纵向分割线,待鼠标指针变成双向箭头时按住左键拖动到最终需要的地方,但假如左
侧没有冻结内容,应把纵向分割线拖到A列的左侧,也就是不进行纵向分割。(如图3)
二、让每一页打印输出后都有标题行
单击“文档”菜单?页面配置,在打开的“页面配置”对话框中,单击“工作表”选项卡,点击“顶端标题行”框后面的红色箭头按钮(如图4)打开“页面配置-顶端标题行”对话框后,接着在工作表中选择好需要在每一页都打印输出的标题行,这时“页面配置-顶端标题行”框中会现“$1:$1”,意思是第一行到第一行作为每页打印
输出时的标题行(我们也能够不选择标题行,而直接输入$1:$1,2,3……)。(如图5)
the moment can not solve or do not have the conditions to solve, to explain, and report to the Bureau (. Ten) the existence of false statements of work in the situation. The outlook appears deviation, did not sink in the heart, in the investigation and management of security risks, fighting rule violations and other specific work, only the data that go up, the work has been done on the surface, good, so in the statistical data and submit
点X或框后的红色箭头按钮退出“页面配置-顶端标题行”对话框,最后单击“确定”按钮(聪明的您是否在
这里还发现了标题列的打印方法)。这样再打印输出每一页上就都有标题行了。
the moment can not solve or do not have the conditions to solve, to explain, and report to the Bureau (. Ten) the existence of false statements of work in the situation. The outlook appears deviation, did not sink in the heart, in the investigation and management of security risks, fighting rule violations and other specific work, only the data that go up, the work has been done on the surface, good, so in the statistical data and submit