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.

    Sincerely,
    Artedk12
    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
    Posts
    1,512
    Articles
    0
    Excel Version
    365
    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-tips...ml#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
    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.

    Sincerely,
    Artedk12

Posting Permissions

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