1,打开excel,进入开始画面。
2,打开Excel 之后,选中最上面5行单元格,需要的表格有几个项目,就选择几行。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/5bafa40f4bfbfbed4387f80268f0f736aec31ff5?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3,选中之后,就点击“自动换行”下面的“合并并居中”,这样写的标题就是在居中的位置,也会把5个单元格合并成一个单元格。再点击一下主题字体下面的框线里的“下框线”,这样就会有一个横线了;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/060828381f30e924a87d524c5c086e061c95f7f6?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/91529822720e0cf3e22e80861a46f21fbf09aaf6?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/5243fbf2b2119313ea9a31cd75380cd790238df6?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6,填充完单元格之后,就点击1和A的坐标,也就是全部选中的意思,把单元格拉高或拉宽,到想要的高度和宽度就完成了。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/bd3eb13533fa828b03fa539eed1f4134960a5af6?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
本回答被网友采纳