ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to change the automatic color in object (https://www.excelbanter.com/excel-discussion-misc-queries/169933-how-change-automatic-color-object.html)

TB in DC

How to change the automatic color in object
 
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?

BoniM

How to change the automatic color in object
 
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?


TB in DC

How to change the automatic color in object
 
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?


BoniM

How to change the automatic color in object
 
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?



All times are GMT +1. The time now is 06:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com