Copying a Custom Color Palette Between Sheets in Excel

 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 "Microsoft Excel User's Guide" 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.

REFERENCES

"User's Guide," version 5.0, pages 639-640 "User's Guide 2," version 4.0, pages 193-194 "User's Guide," version 3.0, pages 558-560

KBCategory: kbusage
KBSubcategory:

Additional reference words: 2.0 2.00 2.01 2.1 2.10 2.2 2.20 2.21 3.0
3.00 4.0 4.00 5.0 5.00 Color Object

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 3, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.