(视频)WPS表格新手入门课:表格页面布局 调整与设置
<b>视频地址1:</b>点击观看<br><br><b>视频地址2:</b>点击观看<br><br>
<b>教程难度:</b>初级<br><br>
<b>图文教程:</b><br>
<p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑; font-size: 16px;"><br></span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑; font-size: 16px;">在工作中,会遇到打印大量的数据集。</span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑; font-size: 16px;">而这些数据很多时候不一定能在打印出来的纸张上很好地呈现,因此打印前的页面效果设计极为重要。</span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑; font-size: 16px;"> </span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑; font-size: 16px;"><img src="http://res1.wpsacdm.cache.wpscdn.cn/images/bf1c4e32af6c6160ff00de2d06f18589.png" title="微信图片_20210809150042.png" alt="微信图片_20210809150042.png" style="max-width: 800px; white-space: normal;"></span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑; font-size: 16px;"><br></span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑; font-size: 16px;"><span style="font-size: 16px;">■</span>以此表格为例,依次点击「视图」-「页面布局」,</span><span style="font-family: 微软雅黑; font-size: 16px;">此时</span><span style="font-family: 微软雅黑; font-size: 16px;">工作表会以数据表格在页面中的视图形式展现。</span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑; font-size: 16px;">于此我们也可清晰可见数据在页面中的位置如何,</span><span style="font-family: 微软雅黑; font-size: 16px;">在</span><span style="font-family: 微软雅黑; font-size: 16px;">「页面布局」</span><span style="font-family: 微软雅黑; font-size: 16px;">的视图下</span><span style="font-family: 微软雅黑; font-size: 16px;">,</span><span style="font-family: 微软雅黑; font-size: 16px;">我们同样可以编辑数据。</span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑; font-size: 16px;"><br></span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑; font-size: 16px;"><img src="//res1.wpsacdm.cache.wpscdn.cn/images/96cbddc6894584e550657478b0a3e015.gif" title="1.gif" alt="1.gif" style="max-width: 800px"></span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑; font-size: 16px;"> </span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑; font-size: 16px;"><span style="font-size: 16px;">■</span>当我们点击菜单栏的「页面布局」选项卡时,提供了更多设置的选项。</span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑; font-size: 16px;">在此成绩单表格中,我们发现在一页的范围内并不能包含所有的数据。</span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑; font-size: 16px;">在这种情况下,我们可以调整「纸张方向」,纵向改成横向。</span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑; font-size: 16px;">调整了方向之后,发现已有了不小的变化,但还是有些微的数据为完全调整到一页中。</span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑; font-size: 16px;"><br></span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑; font-size: 16px;"><img src="//res1.wpsacdm.cache.wpscdn.cn/images/26eb70c99d59d7650cf9bef7a1ffcbaa.gif" title="2.gif" alt="2.gif" style="max-width: 800px"></span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑; font-size: 16px;"> </span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑; font-size: 16px;"><span style="font-size: 16px;">■</span>为了让工作表数据处于一页中,我们可以缩小列宽。</span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑; font-size: 16px;">我们可以通过调整页边距来缩小或者选中表格,拖动列与列之间的线来调整。</span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑; font-size: 16px;">现在我们就可以看到所有数据已经调整到一页上了。</span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑; font-size: 16px;"><br></span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑; font-size: 16px;"><img src="//res1.wpsacdm.cache.wpscdn.cn/images/cbe6b743d64c4734d1c2d191d9b069a7.gif" title="3.gif" alt="3.gif" style="max-width: 800px"></span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑; font-size: 16px;"> </span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑; font-size: 16px;"><span style="font-size: 16px;">■</span>若我们想一键为表格页面添加页眉、页脚,点击「添加页眉」/「添加页脚」。</span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑; font-size: 16px;">在弹出的「页面设置」界面,页眉处点击「自定义页眉」,</span><span style="font-family: 微软雅黑; font-size: 16px;">设置所需的页眉内容以及页眉所在位置就可以了。</span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑; font-size: 16px;">页脚处根据所需下拉选择样式或者点击「自定义页脚」进行设置页脚内容就可以了。</span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑; font-size: 16px;"><br></span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑; font-size: 16px;"><img src="//res1.wpsacdm.cache.wpscdn.cn/images/43a306a0a2095aa567797b70176b2ef8.gif" title="4.gif" alt="4.gif" style="max-width: 800px"></span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑; font-size: 16px;"> </span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑; font-size: 16px;"><span style="font-size: 16px;">■</span>奇偶页不同或者首页不同,根据所需情况勾选就可以了。</span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑; font-size: 16px;">若我们想返回普通视图进行编辑,依次点击「视图」-「普通」,</span><span style="font-family: 微软雅黑; font-size: 16px;">或者点击状态栏的「普通视图」就可以了。</span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑; font-size: 16px;">你学会了吗?</span></p><p><br></p><p><img src="//res1.wpsacdm.cache.wpscdn.cn/images/e7da57a87c414bd88958323f6ef9dd76.gif" title="5.gif" alt="5.gif" style="max-width: 800px"></p><p><br></p>
頁:
[1]