excel设置表格的大小,列宽9厘米行高4厘米, 需要先将表格默认尺寸设置为厘米,然后通过设置行高列宽数值即可实现。
方法步骤如下:
1、打开需要操作的EXCEL表格,点击左上角的“文件”,然后在文件菜单中点击“选项”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9213b07eca8065381ca4db9399dda144ac3482e7?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/9825bc315c6034a81fa9c001c5134954082376e2?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、通过Ctrl+A选中整个表格,然后点击开始选项卡中的“格式”>“行高”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/8718367adab44aed9ab0c664bd1c8701a08bfbb0?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/f11f3a292df5e0fea4adf181526034a85fdf72fc?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/8cb1cb13495409239a201afe9c58d109b2de49e0?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、输入合适的列宽数值,然后点击确定即可。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a8ec8a13632762d03816de3faeec08fa513dc602?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
7、返回EXCEL表格,发现整个表格行高列宽已设置为期望值。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/1b4c510fd9f9d72a929d6a9dda2a2834359bbbb1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)