When I draw a line in Excel 2007 the color is blue. How do I change the
default color to black?

Put the mouse over the line. Right click, choose format shape, choose line
colour.

Cheers Willy



"Gregb" wrote:

When I draw a line in Excel 2007 the color is blue. How do I change the
default color to black?

On Sun, 18 Jan 2009 14:36:01 +0530, Gregb
wrote:

When I draw a line in Excel 2007 the color is blue. How do I change the
default color to black?

If you want to change the default line color so each new line you draw on
the worksheet is the same color, do this:

1. Draw the blue line
2. Set the color to black
3. Right click the line and select "Set as default line"

Now all new lines that you draw will be black.

Note that the color change will only be applicable to that workbook.

--
Thanks,
Victor

Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

Hi, Sorry I couldn't get you to the "exact" instructions but after you copy
and paste this link follow the instructions from where you see "Excel"
written in gold color text. I just tried it out and it's easy. You're just
basically changing the default theme (sort of like changing the old default
template in XL 2003). I'm glad I tried it because I changed mine so now all
my new workbooks automatically contain the look I want! Good Luck!

http://office.microsoft.com/client/h...10 0648351033

Thanks Sherry, I will try it! Why should such a simple thing be so complicated?

"sherry" wrote:

Hi, Sorry I couldn't get you to the "exact" instructions but after you copy
and paste this link follow the instructions from where you see "Excel"
written in gold color text. I just tried it out and it's easy. You're just
basically changing the default theme (sort of like changing the old default
template in XL 2003). I'm glad I tried it because I changed mine so now all
my new workbooks automatically contain the look I want! Good Luck!

http://office.microsoft.com/client/h...10 0648351033

The problem with this suggestion if, for example, if you draw a arrowhead
line and then change the color and "set as default" every line you draw
thereafter is a black arrowhead line, i.e. you cannot draw a line without an
arrowhead! When you set as a default how do you unset it? I cannot work that
out too.

"Victor Lobo" wrote:

On Sun, 18 Jan 2009 14:36:01 +0530, Gregb
wrote:

When I draw a line in Excel 2007 the color is blue. How do I change the
default color to black?

If you want to change the default line color so each new line you draw on
the worksheet is the same color, do this:

1. Draw the blue line
2. Set the color to black
3. Right click the line and select "Set as default line"

Now all new lines that you draw will be black.

Note that the color change will only be applicable to that workbook.

--
Thanks,
Victor

Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

Greg - I hope you did in fact copy that link because clicking on it won't
work; it had a break in it. I copied and pasted and it worked. If you did
it already, were you successful?
--
sherry


"Gregb" wrote:

Thanks Sherry, I will try it! Why should such a simple thing be so complicated?

"sherry" wrote:

Hi, Sorry I couldn't get you to the "exact" instructions but after you copy
and paste this link follow the instructions from where you see "Excel"
written in gold color text. I just tried it out and it's easy. You're just
basically changing the default theme (sort of like changing the old default
template in XL 2003). I'm glad I tried it because I changed mine so now all
my new workbooks automatically contain the look I want! Good Luck!

http://office.microsoft.com/client/h...10 0648351033

On Jan 21, 12:38*am, Gregb wrote:
The problem with this suggestion if, for example, if you draw a arrowhead
line and then change the color and "set as default" every line you draw
thereafter is a black arrowhead line, i.e. you cannot draw a line without an
arrowhead! When you set as a default how do you unset it? I cannot work that
out too.



"Victor Lobo" wrote:
On Sun, 18 Jan 2009 14:36:01 +0530, Gregb *
wrote:

When I draw a line in Excel 2007 the color is blue. How do I change the
default color to black?

If you want to change the default line color so each new line you draw on *
the worksheet is the same color, do this:

* *1. Draw the blue line
* *2. Set the color to black
* *3. Right click the line and select "Set as default line"

Now all new lines that you draw will be black.

Note that the color change will only be applicable to that workbook.

--
Thanks,
Victor

Using Opera's revolutionary e-mail client:http://www.opera.com/mail/- Hide quoted text -

- Show quoted text -

Hi

You can undo it, by right-clickingFormat ShapeLine
Settingschanging the arrow settings (no arrow)
And setting that line as default.

I guess if you need to change only the color you can do that by
setting the "simple" line as default instead of an arrow line.

Thanks,
Victor

Hi Sherry

I copied and pasted it and worked. Thanks.

Greg

"sherry" wrote:

Greg - I hope you did in fact copy that link because clicking on it won't
work; it had a break in it. I copied and pasted and it worked. If you did
it already, were you successful?
--
sherry


"Gregb" wrote:

Thanks Sherry, I will try it! Why should such a simple thing be so complicated?

"sherry" wrote:

Hi, Sorry I couldn't get you to the "exact" instructions but after you copy
and paste this link follow the instructions from where you see "Excel"
written in gold color text. I just tried it out and it's easy. You're just
basically changing the default theme (sort of like changing the old default
template in XL 2003). I'm glad I tried it because I changed mine so now all
my new workbooks automatically contain the look I want! Good Luck!

http://office.microsoft.com/client/h...10 0648351033