l14107cb 发表于 2024-10-2 16:44:01

Excel里怎么样制作斜线表头,教你两个快速制作的办法,一看就懂


    <div style="color: black; text-align: left; margin-bottom: 10px;">
      <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>。</p>
      <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>来<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;"><strong style="color: blue;"><span style="color: black;">1、</span>单条斜线</strong></p>
      <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">1、打开你的Excel数据表,先在需要制作斜线的表格中输入需要的文字信息,<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/pgc-image/2e79ad91da724414a5e4d3cf58e640c3~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727989402&amp;x-signature=o3dyIocy6OCF7alNdxjC7%2BEEjA0%3D" style="width: 50%; margin-bottom: 20px;"></div>
      <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">2、输入好信息之后,将鼠标移到两个名<span style="color: black;">叫作</span>中间,按下快捷键【Alt+Enter】进行强制换行。</p>
      <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/1aabf9eaa2dc4e0d82201e2e3f18237f~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727989402&amp;x-signature=qycM1XE2hGHa75RV%2BTgTlCShAZU%3D" style="width: 50%; margin-bottom: 20px;"></div>
      <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">3、换行好了之后,将鼠标移到<span style="color: black;">第1</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/pgc-image/ff87ba0bd951485bb2927112a5bf1861~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727989402&amp;x-signature=IrNMAm%2FNS52gVutciKPkDfsn8lc%3D" style="width: 50%; margin-bottom: 20px;"></div>
      <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">4、弄好之后就选中这个表格,鼠标右键,<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/pgc-image/b3bdf6c02ef54801bdde8dd1aa0462e1~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727989402&amp;x-signature=lFMDSpe8HlSMAUryaQeaEzaabho%3D" style="width: 50%; margin-bottom: 20px;"></div>
      <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">5、就<span style="color: black;">这般</span>,表格里面的斜线就自动填充好了。</p>
      <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/527951999bdc4e909719e595f8b30b54~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727989402&amp;x-signature=GtlZjcGeICHcp6Zg2OsfrvQOuso%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>是用快捷键【Alt+Enter】进行强制换行,<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/pgc-image/bf28179f18a64221a4276d9c67955e2b~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727989402&amp;x-signature=gUyrkfZ%2F0Gw%2FI%2FXdlVN96xd7YIc%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/pgc-image/0565b7d6734945f1b97cef537ad0a359~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727989402&amp;x-signature=cPd%2BpVQUha19qdMU6SytNngqKOo%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>你们学会了吗?</p>
    </div>




j8typz 发表于 2024-10-3 21:18:27

回顾历史,我们感慨万千;放眼未来,我们信心百倍。

1fy07h 发表于 4 天前

在遇到你之前,我对人世间是否有真正的圣人是怀疑的。
页: [1]
查看完整版本: Excel里怎么样制作斜线表头,教你两个快速制作的办法,一看就懂