How to change the automatic color in object

T

TB in DC

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?
 
B

BoniM

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.
 
T

TB in DC

YOU ROCK!!!
Thanks
BoniM said:
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.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 default line color 8
Change Color of cell 3
Color of Filter Arrows in Excel 1
How to change the default text color in Excel 2000? 1
How do I change the default font color in Excel? 2
Windows 7 Default page color for e-mail (Outlook) 1
Conditional Formating with Icon set - How to change the color 3
Changing arrow color on the auto filter 1

Top