Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Microsoft Office Excel
Search
Search
 
Check for updates: (c) Microsoft
Office downloads
 
 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Email this linkEmail this link Printer-Friendly VersionPrinter-Friendly Version Bookmark and ShareShare
Change the color palette in a workbook
 

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

ShowChange 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

ShowCopy 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.
advertisement