Results 1 to 3 of 3

Thread: Excel 2007 Color Change When Worksheet Copied to Another Workbook

  1. #1

    Question Excel 2007 Color Change When Worksheet Copied to Another Workbook

    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.

    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Worksheet-Color-change.jpg 
Views:	9 
Size:	35.4 KB 
ID:	4031  

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Excel Version
    A guess: Colour palette change?
    See File|Options|Save then Choose what colors will be seen
    One more thing re your cross post at

    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
    Last edited by p45cal; 2015-10-19 at 01:12 AM.

  3. #3

    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.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts