Borders line weight

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
 
M

Micah Chaney

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.
 
C

CLR

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
 
P

PBS

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
 
C

CLR

Maybe try changing the color of the line to light grey...........

Vaya con Dios,
Chuck, CABGx3
 
D

Don Guillett

Is this what you want?
Sub borderdo()
With Selection.Borders
..LineStyle = xlContinuous
..Weight = xlMedium'xlthick'xlthin
End With
End Sub
 
Top