打开表格选中文本,将单元格格式中的对齐方式选择为两端对齐就能调整间距的大小;或者在格式中找拼写指南,设置字体的大小来调整间距的大小。
工具/原料:戴尔G3、Windows7、WPS2020
1、打开需要调整文字行间距的excel表格,选中目标单元格点击鼠标右键,选择设置单元格格式。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/f703738da977391265b690f4ea198618377ae297?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/8326cffc1e178a8269ac6a35e403738da877e897?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/b64543a98226cffcd0baaa27ab014a90f703ea97?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/a8773912b31bb05120b4a6bd247adab44bede097?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/1f178a82b9014a9024ae5328bb773912b21bee97?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、点击拼单设置,通过调整拼单字体的大小来增加或减少文字行间距的大小。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/0b55b319ebc4b7458804a283ddfc1e178b821596?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)