excel怎么制作表格，以值班表为例，在EXCEL里介绍怎么样建表格
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">利用EXCEL制作表格，是学习EXCEL表格操作的基本功，<span style="color: black;">亦</span>是一项<span style="color: black;">基本</span>操作，<span style="color: black;">怎样</span>在EXCEL表格里创建表格，下面以一份值班表为例介绍<span style="color: black;">怎样</span>在EXCEL里创建表格。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">演示环境：荣耀MagicBook 16 Pro，Windows 11，Microsoft Office 专业<span style="color: black;">加强</span>版2019 WORD2403</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">在EXCEL里创建表格的<span style="color: black;">过程</span>：</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">首要</span>，<span style="color: black;">咱们</span>在创建表格之前，要做到心中有数，脑中规划表格的大概样式，手中移动鼠标选中表格所需要的行列数。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-axegupay5k/d3ee687eb0a649399af28f8a353097c8~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727988698&x-signature=%2B6%2FVmF0ewnSVcTqrcxQI36T5d28%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">点击菜单栏上“<span style="color: black;">起始</span>-字体-边框”，下拉<span style="color: black;">选取</span>“所有框线”。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/c2be1ee3cd6541fe9c15fb8e33c5e3f5~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727988698&x-signature=OdS5jy9VDMJjjVcmugXdGiR1LuA%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">选中区域添加了横竖表格框线。点击左侧表格的行号，整行选中，上下移动，<span style="color: black;">调节</span>表格的行高。<span style="color: black;">倘若</span>是<span style="color: black;">调节</span>单行的行高，则选中一行，<span style="color: black;">倘若</span>是<span style="color: black;">调节</span>多行的行高，则选中多行，多行高度一致，<span style="color: black;">倘若</span>行高<span style="color: black;">区别</span>，则需要分行<span style="color: black;">调节</span>高度。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/54a75897ba2943f68303235093f44ae0~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727988698&x-signature=p7S85l5OcLg0xO3kUnEdf7LbMtc%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">一样</span>地，点击列标题，<span style="color: black;">上下</span>移动<span style="color: black;">调节</span>表格的列宽，选中一列，<span style="color: black;">调节</span>一列，选中多列，多列<span style="color: black;">同期</span><span style="color: black;">调节</span>列宽，且宽度<span style="color: black;">同样</span>，<span style="color: black;">倘若</span>每列的宽度不<span style="color: black;">同样</span>，则分列<span style="color: black;">调节</span>。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/f47f4eab7468406fbdd0d2e875682565~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727988698&x-signature=5Q3hiocbxg%2B6xYxE1Ol9jXJ6vFs%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">倘若</span>需要合并单元格，则选中需要合并的多个单元格，点击菜单栏上“<span style="color: black;">起始</span>-对齐方式-合并后居中”，下拉<span style="color: black;">选取</span>“合并单元格”。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/29c30829391b4fe8a392d43afdce0deb~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727988698&x-signature=GSQe5aj64Z8LMcKGJxp5cyfWi9s%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">倘若</span>表格内需要添加斜线，制作斜线表头，选中单元格，在键盘上按下“CTRL+1”打开“设置单元格格式”窗口，点击边框标签，单击“斜线”样式，点击确定，选中单元格添加了对应的斜线。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/065929b464884b4ba3828cc604a0a0c1~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727988698&x-signature=OkouyhP53eNVYESfHEV2mVkWJJo%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">空白表格创建好后，<span style="color: black;">能够</span>在单元格内输入标题文字、表头文字等。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/776038a6bde64f2182b993d5765b9dff~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727988698&x-signature=xj%2FO3HRJWa7qvc83Ya2LlI%2BMOOg%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">选中表格里的文字，点击菜单栏上“<span style="color: black;">起始</span>-对齐方式”，<span style="color: black;">选取</span>一种对齐方式，如图所示，<span style="color: black;">这儿</span><span style="color: black;">选取</span>了居中对齐，表头标题文字设置为居中。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/0abffedecce84f92a372f71dba75413c~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727988698&x-signature=R2xajDfpxehtGwMZqx4DMUMYTz4%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">此刻</span>，一张简单的值班表就制作完<span style="color: black;">成为了</span>。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">EXCEL里<span style="color: black;">能够</span>创建多种样式的表格，但创建表格的<span style="color: black;">过程</span>却大体相同，而以上的<span style="color: black;">过程</span><span style="color: black;">亦</span>并不分先后<span style="color: black;">次序</span>，<span style="color: black;">基本</span><span style="color: black;">办法</span><span style="color: black;">把握</span>好后，<span style="color: black;">亦</span>就自然能千变万化。</p>
论坛的成功是建立在我们诚恳、务实、高效、创新和团结合作基础上，我们要把这种精神传递下去。 你的见解独到，让我受益匪浅，期待更多交流。 一看到楼主的气势，我就觉得楼主同在社区里灌水。 感谢你的精彩评论，带给我新的思考角度。 你说得对，我们一起加油，未来可期。 论坛的成功是建立在我们诚恳、务实、高效、创新和团结合作基础上，我们要把这种精神传递下去。 一看到楼主的气势，我就觉得楼主同在社区里灌水。
页:
[1]