How To Change Default Fill Color In Excel

• #1

Is in that location a way to alter the default color in the background color drib downwards box? Yellow is the default, simply I desire blueish.

...and to exist picky, I just desire the default color changed for i particular spreadsheet when it opens, not every 1 that opens.

Thanks for your assist.....

Aug 20, 2004

viii,874

111

106

• #two

Tin you show a screen shot of exactly what area or box you lot desire to change the color ?

• #3

I desire the yellow (default) colour in the drib down box to be blue when the spreadsheet showtime opens.

Aug 20, 2004

8,874

111

106

• #5

Na, those change Excel for all spreadsheets. I just desire the default blue on one particular spreadsheet.
What I desire is to pIck blue from drop down, salvage and exit and when the sheet opens again blueish should be the default (instead of always defaulting dorsum to yellowish).

Aug twenty, 2004

8,874

111

106

• #7

I want the yellow (default) color in the drop downward box to be blue when the spreadsheet commencement opens.

Hi There did you lot observe the answer to your question? I want to exercise the same and cant find the answer anywhere. Thanks

Aug 20, 2004

8,874

111

106

• #8

This tip mainly is for Word only I think Mr. Wyatts idea of using a Macro to set the color may work in Excel likewise. You may need to play with information technology to get the colour you want.
I am not likewise well versed in using macros, but this may start you in the right direction.
https://wordribbon.tips.internet/T000144_Changing_the_Default_Highlighting_Color.html

Changing the default highlight color:
On the Home tab of the ribbon, the default color for the Text Highlight tool is yellow. Larry wonders if there is a fashion to modify the default so that information technology is, instead, "No Color."

The answer depends on what you mean by "default colour." If you mean that the highlighting will be something other than xanthous (including "No Color") when you showtime start Word, then the reply is no. There is no built-in ability to specify a default colour according to this definition.

However, if your definition of "default color" ways that what Word uses the next time y'all employ the Text Highlight tool, then the answer is yes. You run across, if you apply the drop-down color selector side by side to the tool, whatever color you lot pick (including, again, "No Color") becomes the "default" color for all subsequent uses of the tool during your current session in Give-and-take.

Of course, you can change the highlight color when you starting time start Discussion by using an AutoExec macro to prepare the color. The macro using this special name, when stored in your Normal template, runs whenever you start Word, and then information technology is a great place to specify the color you lot want. Hither's how such a macro would expect:

Sub AutoExec()
Options.DefaultHighlightColorIndex = wdNoHighlight
Cease Sub

• Advertising
• Cookies Policies
• Privacy
• Term & Atmospheric condition
• About us

• This site uses cookies to help personalise content, tailor your experience and to keep you logged in if y'all register.
  By continuing to utilise this site, you lot are consenting to our use of cookies.

Source: https://forums.anandtech.com/threads/excel-2016-change-default-color-in-cell-color-drop-down-box.2496438/

Posted by: schoenbergcontly.blogspot.com

Share this post