up vote 2 down vote favorite
1
share [g+] share [fb]

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?

link|improve this question
75% accept rate
feedback

4 Answers

up vote 2 down vote accepted

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.

link|improve this answer
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 Aug 1 '11 at 20:13
You have to reapply the border, because it is possible to apply a different color to each side. . . – surfasb Aug 1 '11 at 20:58
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 Aug 2 '11 at 20:59
1  
Oh, should of gone with the obvious answer. I edited it. – surfasb Aug 2 '11 at 21:21
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 Aug 14 '11 at 0:10
show 1 more comment
feedback
up vote 0 down vote

So the answer is no. Surfasb doesn't understand the dilemma of what you are asking. You have to reapply all the borders in their varying thicknesses in the new color as you guessed. One of Excel's minor flaws.

link|improve this answer
feedback
up vote 0 down vote

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.

link|improve this answer
feedback
up vote 0 down vote

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 !

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.