Change Color from Defaults

November 18th, 2004 | Categories: Formatting | Tags:

Tired of the default color palette?

oldcolors

Would you prefer some of these choices?

newcolors

If you have Excel 2002 or higher the option is now available to you. Here’s how:

1. Goto Tools
2. Goto Options
3. Select the Color Tab
colortab
4. Click the color you would like to replace in the OLD color palette
5. Click Modify and select your new color, hit OK, OK

Back in your spreadhsheet you will see your newly selected color in place of the old, for instance when choosing a paint bucket color.

  1. November 19th, 2004 at 07:36
    Reply | Quote | #1

    >>If you have Excel 2002 or higher…

    This capability has been around at least since Excel 97. Also available has been the handy ability to copy palettes from one workbook to another.

  2. Mark
    November 19th, 2004 at 10:36
    Reply | Quote | #2

    Thanks Jon.