excel虚线分割线去掉的方法如下:
操作环境:联想拯救者y7000p,Windows11,Excel2021版等。
1、打开电脑找到并点击打开excel2018新建工作表格。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/060828381f30e924673f878a42086e061c95f7f6?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/a50f4bfbfbedab64bb85567bf936afc378311e91?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/0b55b319ebc4b74583a9adadc1fc1e178a82154f?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/9345d688d43f879437a65295dc1b0ef41bd53a2b?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/8435e5dde71190ef3b7b8864c01b9d16fcfa608c?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/c83d70cf3bc79f3d7c36fe8bb4a1cd11738b29b1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)