Whenever I draw an arrow or any object in Excel it comes out blue.
How do I change the default color for objects in Excel?

Turn on the drawing toolbar. Draw an arrow or other drawn object. Change
the formatting of the object to your preferences. With the object still
selected, click Draw on the drawing toolbar and click Set AutoShape Defaults.
Whatever formatting has been applied to the selected object will be the
default from then on - not just for line color, but including line style,
fill color, etc.


"TB in DC" wrote:

> Whenever I draw an arrow or any object in Excel it comes out blue.
> How do I change the default color for objects in Excel?

YOU ROCK!!!
Thanks
"BoniM" wrote:

> Turn on the drawing toolbar. Draw an arrow or other drawn object. Change
> the formatting of the object to your preferences. With the object still
> selected, click Draw on the drawing toolbar and click Set AutoShape Defaults.
> Whatever formatting has been applied to the selected object will be the
> default from then on - not just for line color, but including line style,
> fill color, etc.
>
>
> "TB in DC" wrote:
>
> > Whenever I draw an arrow or any object in Excel it comes out blue.
> > How do I change the default color for objects in Excel?

You're very welcome... happy to help! Thanks for the feedback.

"TB in DC" wrote:

> YOU ROCK!!!
> Thanks
> "BoniM" wrote:
>
> > Turn on the drawing toolbar. Draw an arrow or other drawn object. Change
> > the formatting of the object to your preferences. With the object still
> > selected, click Draw on the drawing toolbar and click Set AutoShape Defaults.
> > Whatever formatting has been applied to the selected object will be the
> > default from then on - not just for line color, but including line style,
> > fill color, etc.
> >
> >
> > "TB in DC" wrote:
> >
> > > Whenever I draw an arrow or any object in Excel it comes out blue.
> > > How do I change the default color for objects in Excel?