Borders line weight

  • Thread starter Thread starter PBS
  • Start date Start date
P

PBS

Is there any way to control the line weight that Excel uses for the border
line weights?

In particular I'd like a thinner single line. It appears to default to
about 1 pt. I'd like something equivalent to what you can do in Word, say
..25 pt.

Excel 2003

Thanks,
Paul
 
Right click on the cell or cells you want to customize the border for
Click Properties
Go to the Borders Tab
Modify at will

Hope this helps.
 
For cell borders.....Format > Cells > choose the lineweight in the Style:
window

For Objects.....Right-click on the border > Format AutoShape > Colors and
lines tab

Vaya con Dios,
Chuck, CABGx3
 
OK, that's what I'd already tried. Choosing the finest solid line there
results in an approximate 1pt wide line at print time (unless there is
another level of options that I'm not seeing). For instance, in Word you'd
select that thinnest solid line, then whether you want 1/4pt or wider. I
was hoping to get a thinner line, as with Word borders.

Thank you,
Paul
 
Maybe try changing the color of the line to light grey...........

Vaya con Dios,
Chuck, CABGx3
 
Is this what you want?
Sub borderdo()
With Selection.Borders
..LineStyle = xlContinuous
..Weight = xlMedium'xlthick'xlthin
End With
End Sub
 
Back
Top