Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I change the thickness of a bottom boarder in Excel 2002?
In Word you can change the thickness of the line used in boarders - but I can
not change the thickness in Excel. Is there any way to do this? Thanks. |
#2
|
|||
|
|||
try
Sub bottomborder() ActiveCell.Borders(xlEdgeBottom).Weight = xlThick 'xlmedium or xlthin End Sub -- Don Guillett SalesAid Software "Dawn" wrote in message ... In Word you can change the thickness of the line used in boarders - but I can not change the thickness in Excel. Is there any way to do this? Thanks. |
#3
|
|||
|
|||
Thanks! Where do I put that info?
"Don Guillett" wrote: try Sub bottomborder() ActiveCell.Borders(xlEdgeBottom).Weight = xlThick 'xlmedium or xlthin End Sub -- Don Guillett SalesAid Software "Dawn" wrote in message ... In Word you can change the thickness of the line used in boarders - but I can not change the thickness in Excel. Is there any way to do this? Thanks. |
#4
|
|||
|
|||
Dawn,
If you're using the toolbar buttons for borders, you have only the choices there, including the thicknesses. For custom bordering, try Format - Cells - Borders. The general approach is to work that dialog box from right to left: Select the line styles, thicknesses, etc,. you want in the right side, then click in the left side to apply the current line style to the cells. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Dawn" wrote in message ... In Word you can change the thickness of the line used in boarders - but I can not change the thickness in Excel. Is there any way to do this? Thanks. |
#5
|
|||
|
|||
When I open up Format - Cells - Borders, there is no where in there to choose
the line thickness. There is a styles, which gives me one thickness of each type of line style - where can I choose the thickness? "Earl Kiosterud" wrote: Dawn, If you're using the toolbar buttons for borders, you have only the choices there, including the thicknesses. For custom bordering, try Format - Cells - Borders. The general approach is to work that dialog box from right to left: Select the line styles, thicknesses, etc,. you want in the right side, then click in the left side to apply the current line style to the cells. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Dawn" wrote in message ... In Word you can change the thickness of the line used in boarders - but I can not change the thickness in Excel. Is there any way to do this? Thanks. |
#6
|
|||
|
|||
Oh - it's a macro isn't it. Thanks.
"Don Guillett" wrote: try Sub bottomborder() ActiveCell.Borders(xlEdgeBottom).Weight = xlThick 'xlmedium or xlthin End Sub -- Don Guillett SalesAid Software "Dawn" wrote in message ... In Word you can change the thickness of the line used in boarders - but I can not change the thickness in Excel. Is there any way to do this? Thanks. |
#7
|
|||
|
|||
Dawn,
I guess I was overoptimistic in my description. There are some line styles presented in more than one thickness (the solid line), and variants of the dashed line in varying thicknesses, but no independent thickness selection, per se. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Dawn" wrote in message ... When I open up Format - Cells - Borders, there is no where in there to choose the line thickness. There is a styles, which gives me one thickness of each type of line style - where can I choose the thickness? "Earl Kiosterud" wrote: Dawn, If you're using the toolbar buttons for borders, you have only the choices there, including the thicknesses. For custom bordering, try Format - Cells - Borders. The general approach is to work that dialog box from right to left: Select the line styles, thicknesses, etc,. you want in the right side, then click in the left side to apply the current line style to the cells. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Dawn" wrote in message ... In Word you can change the thickness of the line used in boarders - but I can not change the thickness in Excel. Is there any way to do this? Thanks. |
#9
|
|||
|
|||
Hi Don,
Yes, I saw your post. I was giving Dawn a non-macro way to do borders. I've not been able use a macro to get a combination of line style and line thickness that isn't already one of the combinations in the Format - Cells - Borders dialog box. Is that what you're saying? I admit to not trying very thoroughly, though. :) For example, the second one down on the right one gives: With Selection.Borders(xlEdgeTop) .LineStyle = xlSlantDashDot .Weight = xlMedium But if I try to get the xlSlantDashDot style in xlThick (which isn't an available combination in the dialog box): With Selection.Borders(xlEdgeTop) .LineStyle = xlSlantDashDot .Weight = xlThick .... it reverts to a solid line, as if it's xlContinuous. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Don Guillett" wrote in message ... Earl, Did you see my post? Sub bottomborder() ActiveCell.Borders(xlEdgeBottom).Weight = xlThick 'xlmedium or xlthin End Sub -- Don Guillett SalesAid Software "Earl Kiosterud" wrote in message ... Dawn, I guess I was overoptimistic in my description. There are some line styles presented in more than one thickness (the solid line), and variants of the dashed line in varying thicknesses, but no independent thickness selection, per se. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Dawn" wrote in message ... When I open up Format - Cells - Borders, there is no where in there to choose the line thickness. There is a styles, which gives me one thickness of each type of line style - where can I choose the thickness? "Earl Kiosterud" wrote: Dawn, If you're using the toolbar buttons for borders, you have only the choices there, including the thicknesses. For custom bordering, try Format - Cells - Borders. The general approach is to work that dialog box from right to left: Select the line styles, thicknesses, etc,. you want in the right side, then click in the left side to apply the current line style to the cells. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Dawn" wrote in message ... In Word you can change the thickness of the line used in boarders - but I can not change the thickness in Excel. Is there any way to do this? Thanks. |
#10
|
|||
|
|||
Earl,
In xl2002, I couldn't find a way to make a thick border without using the macro I supplied. -- Don Guillett SalesAid Software "Earl Kiosterud" wrote in message ... Hi Don, Yes, I saw your post. I was giving Dawn a non-macro way to do borders. I've not been able use a macro to get a combination of line style and line thickness that isn't already one of the combinations in the Format - Cells - Borders dialog box. Is that what you're saying? I admit to not trying very thoroughly, though. :) For example, the second one down on the right one gives: With Selection.Borders(xlEdgeTop) .LineStyle = xlSlantDashDot .Weight = xlMedium But if I try to get the xlSlantDashDot style in xlThick (which isn't an available combination in the dialog box): With Selection.Borders(xlEdgeTop) .LineStyle = xlSlantDashDot .Weight = xlThick ... it reverts to a solid line, as if it's xlContinuous. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Don Guillett" wrote in message ... Earl, Did you see my post? Sub bottomborder() ActiveCell.Borders(xlEdgeBottom).Weight = xlThick 'xlmedium or xlthin End Sub -- Don Guillett SalesAid Software "Earl Kiosterud" wrote in message ... Dawn, I guess I was overoptimistic in my description. There are some line styles presented in more than one thickness (the solid line), and variants of the dashed line in varying thicknesses, but no independent thickness selection, per se. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Dawn" wrote in message ... When I open up Format - Cells - Borders, there is no where in there to choose the line thickness. There is a styles, which gives me one thickness of each type of line style - where can I choose the thickness? "Earl Kiosterud" wrote: Dawn, If you're using the toolbar buttons for borders, you have only the choices there, including the thicknesses. For custom bordering, try Format - Cells - Borders. The general approach is to work that dialog box from right to left: Select the line styles, thicknesses, etc,. you want in the right side, then click in the left side to apply the current line style to the cells. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Dawn" wrote in message ... In Word you can change the thickness of the line used in boarders - but I can not change the thickness in Excel. Is there any way to do this? Thanks. |
#11
|
|||
|
|||
Don,
Isn't it the second from the bottom, right column, of Format - Cells - Borders? I get the same results as with your macro. XL2002 -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Don Guillett" wrote in message ... Earl, In xl2002, I couldn't find a way to make a thick border without using the macro I supplied. -- Don Guillett SalesAid Software "Earl Kiosterud" wrote in message ... Hi Don, Yes, I saw your post. I was giving Dawn a non-macro way to do borders. I've not been able use a macro to get a combination of line style and line thickness that isn't already one of the combinations in the Format - Cells - Borders dialog box. Is that what you're saying? I admit to not trying very thoroughly, though. :) For example, the second one down on the right one gives: With Selection.Borders(xlEdgeTop) .LineStyle = xlSlantDashDot .Weight = xlMedium But if I try to get the xlSlantDashDot style in xlThick (which isn't an available combination in the dialog box): With Selection.Borders(xlEdgeTop) .LineStyle = xlSlantDashDot .Weight = xlThick ... it reverts to a solid line, as if it's xlContinuous. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Don Guillett" wrote in message ... Earl, Did you see my post? Sub bottomborder() ActiveCell.Borders(xlEdgeBottom).Weight = xlThick 'xlmedium or xlthin End Sub -- Don Guillett SalesAid Software "Earl Kiosterud" wrote in message ... Dawn, I guess I was overoptimistic in my description. There are some line styles presented in more than one thickness (the solid line), and variants of the dashed line in varying thicknesses, but no independent thickness selection, per se. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Dawn" wrote in message ... When I open up Format - Cells - Borders, there is no where in there to choose the line thickness. There is a styles, which gives me one thickness of each type of line style - where can I choose the thickness? "Earl Kiosterud" wrote: Dawn, If you're using the toolbar buttons for borders, you have only the choices there, including the thicknesses. For custom bordering, try Format - Cells - Borders. The general approach is to work that dialog box from right to left: Select the line styles, thicknesses, etc,. you want in the right side, then click in the left side to apply the current line style to the cells. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Dawn" wrote in message ... In Word you can change the thickness of the line used in boarders - but I can not change the thickness in Excel. Is there any way to do this? Thanks. |
#12
|
|||
|
|||
Yes, It is but I guess my problem came when I couldn't get it it do it. I
went back just now and selected the thick BEFORE selecting the bottom border and THEN it worked. It SHOULD work regardless of which you select first. Oh well. -- Don Guillett SalesAid Software "Earl Kiosterud" wrote in message ... Don, Isn't it the second from the bottom, right column, of Format - Cells - Borders? I get the same results as with your macro. XL2002 -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Don Guillett" wrote in message ... Earl, In xl2002, I couldn't find a way to make a thick border without using the macro I supplied. -- Don Guillett SalesAid Software "Earl Kiosterud" wrote in message ... Hi Don, Yes, I saw your post. I was giving Dawn a non-macro way to do borders. I've not been able use a macro to get a combination of line style and line thickness that isn't already one of the combinations in the Format - Cells - Borders dialog box. Is that what you're saying? I admit to not trying very thoroughly, though. :) For example, the second one down on the right one gives: With Selection.Borders(xlEdgeTop) .LineStyle = xlSlantDashDot .Weight = xlMedium But if I try to get the xlSlantDashDot style in xlThick (which isn't an available combination in the dialog box): With Selection.Borders(xlEdgeTop) .LineStyle = xlSlantDashDot .Weight = xlThick ... it reverts to a solid line, as if it's xlContinuous. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Don Guillett" wrote in message ... Earl, Did you see my post? Sub bottomborder() ActiveCell.Borders(xlEdgeBottom).Weight = xlThick 'xlmedium or xlthin End Sub -- Don Guillett SalesAid Software "Earl Kiosterud" wrote in message ... Dawn, I guess I was overoptimistic in my description. There are some line styles presented in more than one thickness (the solid line), and variants of the dashed line in varying thicknesses, but no independent thickness selection, per se. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Dawn" wrote in message ... When I open up Format - Cells - Borders, there is no where in there to choose the line thickness. There is a styles, which gives me one thickness of each type of line style - where can I choose the thickness? "Earl Kiosterud" wrote: Dawn, If you're using the toolbar buttons for borders, you have only the choices there, including the thicknesses. For custom bordering, try Format - Cells - Borders. The general approach is to work that dialog box from right to left: Select the line styles, thicknesses, etc,. you want in the right side, then click in the left side to apply the current line style to the cells. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Dawn" wrote in message ... In Word you can change the thickness of the line used in boarders - but I can not change the thickness in Excel. Is there any way to do this? Thanks. |
#13
|
|||
|
|||
Don,
That dialog (Border) works kind of backward. You have to select your line style and color in the right side, then apply it in the left (bottom, left, outline, etc.). When you click in the left side, it applies whatever's currently selected in the right side. It's not clear, and backwards. As we say when driving through a small town, and trying to make sense of the road signs "Ya gotta live there." -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Don Guillett" wrote in message ... Yes, It is but I guess my problem came when I couldn't get it it do it. I went back just now and selected the thick BEFORE selecting the bottom border and THEN it worked. It SHOULD work regardless of which you select first. Oh well. -- Don Guillett SalesAid Software "Earl Kiosterud" wrote in message ... Don, Isn't it the second from the bottom, right column, of Format - Cells - Borders? I get the same results as with your macro. XL2002 -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Don Guillett" wrote in message ... Earl, In xl2002, I couldn't find a way to make a thick border without using the macro I supplied. -- Don Guillett SalesAid Software "Earl Kiosterud" wrote in message ... Hi Don, Yes, I saw your post. I was giving Dawn a non-macro way to do borders. I've not been able use a macro to get a combination of line style and line thickness that isn't already one of the combinations in the Format - Cells - Borders dialog box. Is that what you're saying? I admit to not trying very thoroughly, though. :) For example, the second one down on the right one gives: With Selection.Borders(xlEdgeTop) .LineStyle = xlSlantDashDot .Weight = xlMedium But if I try to get the xlSlantDashDot style in xlThick (which isn't an available combination in the dialog box): With Selection.Borders(xlEdgeTop) .LineStyle = xlSlantDashDot .Weight = xlThick ... it reverts to a solid line, as if it's xlContinuous. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Don Guillett" wrote in message ... Earl, Did you see my post? Sub bottomborder() ActiveCell.Borders(xlEdgeBottom).Weight = xlThick 'xlmedium or xlthin End Sub -- Don Guillett SalesAid Software "Earl Kiosterud" wrote in message ... Dawn, I guess I was overoptimistic in my description. There are some line styles presented in more than one thickness (the solid line), and variants of the dashed line in varying thicknesses, but no independent thickness selection, per se. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Dawn" wrote in message ... When I open up Format - Cells - Borders, there is no where in there to choose the line thickness. There is a styles, which gives me one thickness of each type of line style - where can I choose the thickness? "Earl Kiosterud" wrote: Dawn, If you're using the toolbar buttons for borders, you have only the choices there, including the thicknesses. For custom bordering, try Format - Cells - Borders. The general approach is to work that dialog box from right to left: Select the line styles, thicknesses, etc,. you want in the right side, then click in the left side to apply the current line style to the cells. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Dawn" wrote in message ... In Word you can change the thickness of the line used in boarders - but I can not change the thickness in Excel. Is there any way to do this? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel | |||
Excel 2003 back to Excel 2002 | Excel Discussion (Misc queries) | |||
Macro in Excel 2002 to save a workbook to a FTP location | Excel Discussion (Misc queries) | |||
How do I change my default browser from MS Excel 2002. Links cur. | Excel Discussion (Misc queries) | |||
How do I change my default browser from MS Excel 2002. Links cur. | Excel Discussion (Misc queries) |