+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 Color changes when I copy a worksheet to another workbook:

  1. #1
    Registered User
    Join Date
    Scranton, Pennsylvania
    MS-Off Ver

    Unhappy Excel 2007 Color changes when I copy a worksheet 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 picture of this to show you 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.

    Name:  Worksheet-Color-change.jpg
Views: 5783
Size:  151.5 KB

  2. #2
    Forum Expert
    Join Date
    Primarily NL, sometimes UK
    MS-Off Ver

    Re: Excel 2007 Color changes when I copy a worksheet to another workbook:

    Hi, welcome to the forum.

    It looks like there are two different colour palettes in use. The palette in use is changed on the 'Page Layout' tab - the 'Colors' button is on the left-hand-side in the 'Themes' section. (It might also be a different 'Theme' - on the same tab.)

    To keep the source colours, select what you want to copy, then right-click where you want it to go and select 'Paste Special'. In the window which pops up, select 'All using Source Theme' and click OK.
    Alternatively, paste as normal then before you do anything else look at the bottom right of the range you just pasted, where you'll see a little button with a picture of the clipboard and (Ctrl). Click this and then click 'Keep Source Formatting' (the top right button, with a paintbrush and some red dots).

    Hope that helps.

    My internet connection can be intermittent, so sometimes I may not reply quickly to questions. Sorry - it's not personal and I will reply eventually.
    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
    If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
    You don't need to give me rep if I helped, but a thank-you is nice.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1