Excel 2007 Color Change When Worksheet Copied to Another Workbook

Hello Everyone,

I am new to Excel. I have Excel 2007. When I go to copy a completed worksheet from one workbook to another, the newly copied worksheet has a completely different color scheme. I am posting a photo so you can see what I mean.

I have tried 2 ways to duplicate the worksheet from one workbook to another.

1) I hit CTRL + A, then CTRL + C, and CTRL + V ; into the other workbook

2) I also dragged the worksheet UP and held down CTRL button while I dragged it across into the other workbook.


----------------- Either way, the colors change -----------------------------

Can someone tell me why it's doing this?

Hope to hear from someone soon.

Sincerely,
Artedk12

A guess: Colour palette change?
See File|Options|Save then Choose what colors will be seen…
One more thing re your cross post at http://www.excelforum.com/excel-tip...orksheet-to-another-workbook.html#post4219081

Artedk12, for your information, you should always provide links to your cross posts.
If you have cross posted at other places, please add links to them too.
Why? Have a read of http://www.excelguru.ca/content.php?184

Thank You:

--------------------------------------------------------------------------------------------------------------------------------------------------
Thank You p45cal for that advice. It worked ! And I sincerely, appologize for the 'cross-posting' . This is my first time doing this and had no idea about how it all works. I will stick to the rules from now on.

Sincerely,
Artedk12