tw4ld6 发表于 2024-10-1 15:33:41

怎么样在EXCEL表格里制作一个基本表格，制作表格的基本过程


    <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>在EXCEL表格里制作一张表格，我把它分为<strong style="color: blue;">一选二线三调四合五设置，当然这几个<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>话。</strong></p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/151b678998564721b58c4a6bd457cc89~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727970825&amp;x-signature=Fuht1FzIp5ZLG%2FYb%2BqgP0h497vs%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">一选，即<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>自己的表格是个什么样式的，多少行多少列，选定对应的区域。</p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/0eb10924fec64dd7a267f5b3b1dbf646~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727970825&amp;x-signature=m8xTsckH0tYozcTtkQa62lpXSkk%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">二线，即添加表格线</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-qvj2lq49k0/61af804ce18c4952986d5977de0d84bd~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727970825&amp;x-signature=mvn8Uc0A%2B3iIC2YXt5jhoImUNMo%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">三调，即<span style="color: black;">调节</span>单元格<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-qvj2lq49k0/ccec68263403457e86e3aee8e30d829b~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727970825&amp;x-signature=j7BL%2B9Xz6W6dCD8ZZcz%2FJqRXqt0%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">四合，即合并单元格</strong></p>
    <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-qvj2lq49k0/e37d033241eb4b40997a25a62f877994~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727970825&amp;x-signature=tXAs6Wrj4ClNSPMWlES3mmL2Y%2Bw%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">五设置，即对表格进行设置</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>对单元格<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-qvj2lq49k0/6d9aadf8cad648da8d3096aa7349184e~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727970825&amp;x-signature=5ffDeKAe5YISUuAk2s1AOkb%2BZ3s%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-qvj2lq49k0/d8d8142101624699b7e85e0e6426c1ad~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727970825&amp;x-signature=KImZCuVZOmUimKcMHT64X1cknQU%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>不要忘记随时<strong style="color: blue;"><span style="color: black;">保留</span></strong>了，否则一个意外的<span style="color: black;">出现</span>，有可能让你的心血就此白费，而悔<span style="color: black;">欠妥</span>初啊，我个人习惯是随时按下“<strong style="color: blue;">CTRL+S</strong>”键，<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-qvj2lq49k0/6197ff8dd36b4c7fb0a67f88b05ab675~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727970825&amp;x-signature=eLnw68s5wbWwrM%2F6ckLryid1T5w%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 style="color: black;">便是</span>在EXCEL表格里制作一个<span style="color: black;">基本</span>表格的基本<span style="color: black;">过程</span>，怎么样，你学会了吗？</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">爱学习的您，长按您金贵的大拇指，来个</span><strong style="color: blue;"><span style="color: black;">四连键</span></strong><span style="color: black;">吧，谢谢！</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">关注我，<span style="color: black;">连续</span>分享<span style="color: black;">更加多</span>办公软件技巧。</span></p>




4lqedz 发表于 2024-10-20 20:48:40

楼主的文章非常有意义，提升了我的知识水平。

j8typz 发表于 2024-11-6 04:41:36

感谢楼主分享，祝愿外链论坛越办越好！
页: [1]
查看完整版本: 怎么样在EXCEL表格里制作一个基本表格，制作表格的基本过程