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&from=article.pc_detail&lk3s=953192f4&x-expires=1727989402&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&from=article.pc_detail&lk3s=953192f4&x-expires=1727989402&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&from=article.pc_detail&lk3s=953192f4&x-expires=1727989402&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&from=article.pc_detail&lk3s=953192f4&x-expires=1727989402&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&from=article.pc_detail&lk3s=953192f4&x-expires=1727989402&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&from=article.pc_detail&lk3s=953192f4&x-expires=1727989402&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&from=article.pc_detail&lk3s=953192f4&x-expires=1727989402&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>
页:
[1]