【5】Excel边框线添加边框线
1)1/6个私藏绝技:Excel条件格式与函数公式的完美结合/1 http://www.360doc.com/content/20/1117/17/68428570_946345217.shtml
1.1/自动添加边框线
【4】VBA边框线加边框线实线实边框线
1/VBA给选中区域加边框线实线
Sheets("s").Select
Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
'Application.CutCopyMode = False
Selection.Borders(xlDiagonalDown).LineStyle = xlNone '给粘贴的有数据区域加实线
Selection.Borders(xlDiagonalUp).LineStyle = xlNone
With Selection.Borders(xlEdgeLeft)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlThin
End With
With Selection.Borders(xlEdgeTop)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlThin
End With
With Selection.Borders(xlEdgeBottom)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlThin
End With
With Selection.Borders(xlEdgeRight)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlThin
End With
With Selection.Borders(xlInsideVertical)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlThin
End With
With Selection.Borders(xlInsideHorizontal)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlThin
End With
【2】Excel单元格线设置单元格边框线设置
3/Excel中这6个操作技巧不容错过,让你的工作更加得心应手 http://www.360doc.com/content/21/0308/20/9641682_965851055.shtml
2)excel表格虚线怎么去掉
https://jingyan.baidu.com/article/ed2a5d1f962e6a09f7be175a.html
1)如何使单元格线变细
http://wenda.tianya.cn/question/268e53f31808e022
·选定你要使其变细的单元格,点击鼠标右键,选择“设置单元格格式,”弹出一个对话框,选择“边框”按钮,里边有线条样式,选择你想要的线条分别点击在边框的四周,就OK了
1)http://www.360doc.com/edit/writeartnew.aspx
1、自动添加边框线
这一功能是小编当年使用的第一个条件格式,适用于表格每天要添加数据,然后再添加边框线。我们可以利用条件格式功能,当输入数据后自动给表格添加上边框线。
选中需要设置的C3:M8单元格区域,依次点击【开始】-【条件格式】-【新建规则】-【使用公式确定要设置格式的单元格】
输入公式:=$C3<> ""
再点击【格式】-【边框】-【外边框】,最后点击【确定】直到返回工作区。
操作及效果动图如下:
联系客服