ikkhksvu 发表于 2024-10-2 16:30:21

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&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727988698&amp;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&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727988698&amp;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&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727988698&amp;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&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727988698&amp;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&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727988698&amp;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&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727988698&amp;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&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727988698&amp;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&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727988698&amp;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>




qzmjef 发表于 2024-10-8 21:33:07

论坛的成功是建立在我们诚恳、务实、高效、创新和团结合作基础上,我们要把这种精神传递下去。

nqkk58 发表于 昨天 01:16

你的见解独到,让我受益匪浅,期待更多交流。
页: [1]
查看完整版本: excel怎么制作表格,以值班表为例,在EXCEL里介绍怎么样建表格