1.首先,打开excel,调整好我们想要处理的单元格的大小。以下图的单元格A1为例。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a6efce1b9d16fdfa4e0a5b95b28f8c5494ee7b63?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2.选中想要处理的单元格,右击选中“设置单元格格式”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/dc54564e9258d109441334c9d758ccbf6d814ddd?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3.在单元格格式中选中边框,可以找到添加斜线的按钮,如下图。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d058ccbf6c81800ae44a1475b73533fa828b471a?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4.好了,单元格斜线就画好了。下面,输入文字。现在文字无法很好的分布在我们划分的单元格中。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/54fbb2fb43166d22c56b88ef402309f79052d2a9?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5.现在是比较重要的一步。让姓名与成绩分布在斜线的两边。
把鼠标光标放在姓名成绩中间,然后按住alt键,再按enter键,让文字分行,按空格键使成绩移动到合适位置。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/3801213fb80e7bec85729e9a292eb9389b506b25?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6.这样就完成了excel单元格斜杠的添加和文字的添加。可以看一下效果。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b17eca8065380cd72a413f96a744ad345982816a?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)