Excell 2010: How to set/reset the default color for cell borders

**batman** · 08-11-2012, 03:16 PM

I apply cell borders often; the line color has always been black. Yesterday I selected a small range and changed the border around that specific range to a medium blue (could have been any color). Now, much to my dismay, that blue has become the default color for all borders in all workbooks. So far nothing I do in the Border tab of Format Cells, or anything else, reverts the default to black. There's no apparent way that I can find to set or reset the color. Can someone show me the secret? Thanks in advance.

**shg** · 08-11-2012, 03:53 PM

Click the dropdown on the Borders button (in the Font group), select Line Color ...

**batman** · 08-11-2012, 04:23 PM

Thanks sgh, that sure did the trick. I had seen that action in the drop down, but I assumed it applied strictly to the Draw Borders group, which I assume is freehand bordering, so I didn't try it.