Borders line weight

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PBS - 10 Feb 2005 23:16 GMT

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

Reply to this Message

Micah Chaney - 10 Feb 2005 23:27 GMT

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.

> Is there any way to control the line weight that Excel uses for the border
> line weights?
[quoted text clipped - 7 lines]
> Thanks,
> Paul

Reply to this Message

PBS - 10 Feb 2005 23:55 GMT

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

> Right click on the cell or cells you want to customize the border for
> Click Properties
[quoted text clipped - 14 lines]
>> Thanks,
>> Paul

Reply to this Message

CLR - 11 Feb 2005 00:07 GMT

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

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
[quoted text clipped - 23 lines]
> >> Thanks,
> >> Paul

Reply to this Message

CLR - 10 Feb 2005 23:32 GMT

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

> Is there any way to control the line weight that Excel uses for the border
> line weights?
[quoted text clipped - 7 lines]
> Thanks,
> Paul

Reply to this Message

Don Guillett - 11 Feb 2005 01:10 GMT

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

Signature

Don Guillett
SalesAid Software
donaldb@281.com

> Is there any way to control the line weight that Excel uses for the border
> line weights?
[quoted text clipped - 7 lines]
> Thanks,
> Paul

Reply to this Message