EXCEL表格边框少了一条线怎么办
———————————————————————————————— 作者：
———————————————————————————————— 日期：
问题如图所示,只有一点点缺少表格边框.
![](https://wkrtcs.bdimg.com/rtcs/image?w=1280.00&md5sum=5b9dcb88f9c6b58563e6ee8733e0f05e&sign=5d5a0a0564&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=255&ipr={"t":"img","r":"r_2","w":"1280.00","h":"534.00","dataType":"png","c":"word/media/image2.png","imgOriW":1280,"imgOriH":534})
先全部选中表格,单击格式-单元格,定位到边框选项卡.把边框选项都选上(虚线的位置点击即可变位实线)
![](https://wkrtcs.bdimg.com/rtcs/image?w=1280.00&md5sum=5b9dcb88f9c6b58563e6ee8733e0f05e&sign=5d5a0a0564&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=255&ipr={"t":"img","r":"r_4","w":"1280.00","h":"598.00","dataType":"png","c":"word/media/image3.png","imgOriW":1280,"imgOriH":598})
如果不起作用,可以用一个比较巧妙的方法:
![](https://wkrtcs.bdimg.com/rtcs/image?w=1280.00&md5sum=5b9dcb88f9c6b58563e6ee8733e0f05e&sign=5d5a0a0564&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=255&ipr={"t":"img","r":"r_2","w":"1280.00","h":"755.00","dataType":"png","c":"word/media/image4.png","imgOriW":1280,"imgOriH":755})
选中那些没有边框的单元格的附近单元格,设置它们有边框,并且只有一条边框,这个边框恰好和缺少的边框挨着即可.但是不知道系统会不会认为我的J列的确有东西,打印的时候搞的左右边距不一样。当然如果只是看看，还是有了完整的边框看起来舒服。
![](https://wkrtcs.bdimg.com/rtcs/image?w=1280.00&md5sum=5b9dcb88f9c6b58563e6ee8733e0f05e&sign=5d5a0a0564&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=255&ipr={"t":"img","r":"r_2","w":"1280.00","h":"800.00","dataType":"png","c":"word/media/image5.png","imgOriW":1280,"imgOriH":800})
本文来源：https://www.2haoxitong.net/k/doc/a4b11e0a2dc58bd63186bceb19e8b8f67d1ceff6.html
文档为doc格式