+ 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
    10-18-2015
    Location
    Scranton, Pennsylvania
    MS-Off Ver
    2007
    Posts
    1

    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.

    Sincerely,
    Artedk12
    Name:  Worksheet-Color-change.jpg
Views: 6261
Size:  151.5 KB

  2. #2
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,404

    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.
    Regards,
    Aardigspook

    I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - 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)

Similar Threads

  1. Copy Conditional Formatting Color Scales Excel 2007
    By catbert22 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-19-2014, 07:05 PM
  2. [SOLVED] Macro for Copy/Paste from one workbook to another in Excel 2007
    By Blackjack12 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-20-2012, 07:36 PM
  3. [SOLVED] Excel 2007 VBA to search and then copy row to relevant tab in workbook
    By dave1983 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-18-2012, 04:52 AM
  4. Excel 2007 refer to rows in separate worksheet, workbook
    By CMSS in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-03-2010, 01:31 PM
  5. Replies: 2
    Last Post: 01-20-2009, 11:53 AM
  6. Replies: 2
    Last Post: 08-28-2008, 01:31 AM
  7. Excel 2007 copy/move worksheet to another workbook
    By Hoekie@work in forum Excel General
    Replies: 0
    Last Post: 06-21-2006, 02:30 AM

Bookmarks

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