Change Color from Defaults

Automate Excel

Change Color from Defaults

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.

2 Responses

  1. Jon Peltier Says:

    >>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 Says:

    Thanks Jon.

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.