Microsoft KB Archive/68497

{| = Copying a Custom Color Palette Between Sheets in Excel =
 * width="100%"|

Last reviewed: November 3, 1994

Article ID: Q68497 The information in this article applies to:
 * Microsoft Excel for Windows, versions 3.0, 4.0

SUMMARY
After you have customized your color palette and then used the new colors on an object, cell, or chart, the colors do not transfer if you copy the object and paste it to a new sheet.

MORE INFORMATION
Page 560 of the &quot;Microsoft Excel User's Guide&quot; states that when you copy an object with a custom color from one document to another, the number of the color on the color palette is copied with the object.

To copy the colors to the new sheet also, choose the Color Palette command from the Options menu of the receiving sheet and then choose Copy Colors From. The Copy Colors From drop down list will show all open and unhidden sheets. Choosing one of these sheets will then copy its color palette to the active sheet.

In version 5.0 of Microsoft Excel, if you are copying between sheets within the workbook, the colors copy correctly. To copy the color palette to another workbook, from the Tools menu choose Options, then select the Color tab. Enter the name of the file from which you want to copy in the Copy Colors From list box. You can also choose from files that are listed in the dropdown list.