Change the color palette in a workbook

Show All

Hide All

In Excel 2010, you can give a professional look to a spreadsheet by applying an Office document theme. Read an article or try Office 2010!

When you change a color in a workbook palette, any element formatted with that color is changed throughout the entire workbook.

Change a color in a color palette

1. Switch to the workbook that contains the color palette you want to change.
2. On the Tools menu, click Options, and then click the Color tab.
3. Click the color you want to change, and then click Modify.
4. Do one or more of the following:
• To replace the selected color on the palette with a different standard color, click the Standard tab, and then click the color you want.
• To change the hue or another aspect of the selected color, click the Custom tab, and then change the options.

 Notes 

• To restore the default color palette, click Reset on the Color tab.
• If you copy an object or cells with a custom color to another workbook, the custom color is replaced by the color in the corresponding position on the other workbook's color palette. To retain the custom color, either copy the customized color palette to the other workbook or change the corresponding color in the workbook.
• To replace the default color palette in new workbooks, change the color palette in the default workbook template (default workbook template: The Book.xlt template that you create to change the default format of new workbooks. Excel uses the template to create a blank workbook when you start Excel or create a new workbook without specifying a template.) or in the custom template you use to create workbooks.

Copy a color palette to another workbook

1. Open the workbook that contains the color palette you want to copy.
2. Switch to the workbook that you want to copy the color palette to.
3. On the Tools menu, click Options, and then click the Color tab.
4. In the Copy colors from box, click the workbook that contains the color palette you want to copy, and then click OK.