Excel中字体的行间距操作方法如下:
准备的资料:Excel软件,部分练习素材文字
先来看看调整前与调整后的对比图吧,如图1所示。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/6a600c338744ebf802957af0d1f9d72a6159a71c?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
比如一个单元格中输入了3行文字(换行时按Alt + Enter键),文字间的行距显得很挤,我们选中单元格,然后点击右键选择单元格格式,如图2所示。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/1f178a82b9014a90278e5872a1773912b21bee49?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/7aec54e736d12f2ef6c9b0af47c2d56284356834?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
然后通过拖动控制线把单元格的空间拉大,效果就会显示出来,如图4所示。根据您能接受的行间距适当拖动控制线就OK了。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b2de9c82d158ccbf1966acf511d8bc3eb0354122?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
注意事项:快捷键是两个一起按的,不是一个个按的.切记.