Change border color of multiple cells in Excel 2010?

While it is easy to change the font color and fill color of multiple cells at once in Excel 2010, I can't find a way to do this with border colors. Is this possible?

user72923

Posted 2011-08-01T19:43:32.640

Reputation: 867

AFAIK, you can't universally change the border color as you can with fill color. (In spite of the few answers that attempt to claim otherwise.) Why this is the case is beyond me... – b1nary.atr0phy – 2015-04-15T06:34:24.603

Answers

Yeah, just multiselect the cells and click the borders button o the Main Tab. On the menu, select Line color and have at it.

edit

Forgot about the obvious answer. Format Painter.

surfasb

Posted 2011-08-01T19:43:32.640

Reputation: 21 453

Format painter is going to be just as tedious unless your border locations are the same in every single cell. – b1nary.atr0phy – 2015-04-15T06:26:37.113

Thanks for the suggestion. This doesn't work for me though. It changes the line color for future border changes, but it does nothing to the border color of the selected cells. Any idea what I'm doing wrong here? – user72923 – 2011-08-01T20:13:08.840

You have to reapply the border, because it is possible to apply a different color to each side. . . – surfasb – 2011-08-01T20:58:57.847

So the answer is "no" then right? Because you cannot select multiple cells and change the color of all existing border to, say, red. Is that correct? – user72923 – 2011-08-02T20:59:18.153

1Oh, should of gone with the obvious answer. I edited it. – surfasb – 2011-08-02T21:21:59.990

The answer is yes - change the line colour, then apply the borders you want (eg all outside borders, or just bottom or whatever you want) – AdamV – 2011-08-14T00:10:18.243

This does not work as I cannot change border colour to anything that is different than gridlines colour specified under the File>Options>Advanced>Gridlines color. I wonder why is the colour option in there if it in fact, doesn't work? – None – 2012-04-19T18:02:24.543

I got the answer, found it myself, On the menu, select Line color, then you'll see a pencil, click on a cell then press ctrl and drag the pencil trough the desired cells. Check it by yourself !

franko_camron

Posted 2011-08-01T19:43:32.640

Reputation: 121

That only changes the color of one single border via click, dragging with the pencil is actually just draws new borders. – b1nary.atr0phy – 2015-04-15T06:32:56.183

It can be done:

File
Options
Advanced
Scroll down to "Display options for this worksheet"
Gridline color
Choose your color

ALL gridlines that you previously applied will change to the new color at once, WITHOUT losing your gridline formatting!

Amy

Source:

https://www.extendoffice.com/documents/excel/864-excel-change-border-color.html#way1

Amy

Posted 2011-08-01T19:43:32.640

Reputation: 1

I know this is an old question, but it may help others.

Select the cells you want to have a border.
Right click in the highlighted cell area.
Select "Format Cells".
Click on the "Border" tab.
Underneath the "Line Style" you will see the option for "Color" which will affect your selected cells.

The steps above are how I create ALL of my borders when I am creating forms. Once you play with it a couple of minutes, it becomes second nature and is very quick and easy. Hope this helps!

PS - I should also mention that this works for Excel 2007, but it has been the same for previous versions so I will assume it is the same for the 2010 version, or at least very close.

Rayzer

Posted 2011-08-01T19:43:32.640

Reputation: 1

-1

Press alt H B I and select the border color you like. The Excel sheet will show odd dots over the page. Just press Esc and border whatever content in the usual manner.

The default color of your borders would have changed to the one you had selected.

This will remain as your default border color until you close the Excel sheet.

To return back to the default "Black color", repeat the above step and choose "Black" color.

Amey

Posted 2011-08-01T19:43:32.640

Reputation: 1

this doesn't work. please check your Answer – Malachi – 2012-10-19T21:55:26.663