Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Question about Cell Borders
I need to be able to set a default cell border style, thickness and color,
such that when the Border button on the Format toolbar is clicked, that border will be consistently applied to the selected cells. Is there any way to permanently change the border produced by the toolbar button. Thanks Kevin |
#2
|
|||
|
|||
I don't know of any way to reliably do what you're after. However, a
better solution would be to create a new toolbar button and attach a macro that you record (Tools/Macros/Record new macro) applying the border style, thickness and color that you want. In article , "Kevin" <ksorei at yahoo.com wrote: I need to be able to set a default cell border style, thickness and color, such that when the Border button on the Format toolbar is clicked, that border will be consistently applied to the selected cells. Is there any way to permanently change the border produced by the toolbar button. |
#3
|
|||
|
|||
You can change the border default color by changing the gridline color:
Tools|Options|View. Gridline color is change in lower left corner in the Window Option section at the bottom. THe border color is the same as the gridline color. Style, thickness, etc - I dont know either. "JE McGimpsey" wrote: I don't know of any way to reliably do what you're after. However, a better solution would be to create a new toolbar button and attach a macro that you record (Tools/Macros/Record new macro) applying the border style, thickness and color that you want. In article , "Kevin" <ksorei at yahoo.com wrote: I need to be able to set a default cell border style, thickness and color, such that when the Border button on the Format toolbar is clicked, that border will be consistently applied to the selected cells. Is there any way to permanently change the border produced by the toolbar button. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
up to 7 functions? | Excel Worksheet Functions | |||
Unsolvable cell naming question: Can anyone beat this one? | Excel Discussion (Misc queries) | |||
Excel question? Regarding cell formula | Excel Worksheet Functions | |||
how to create a variable column in cell reference | Excel Worksheet Functions | |||
An easy macro question and one I believe to be a little more diffi | Excel Worksheet Functions |