+ Reply to Thread
Results 1 to 2 of 2

Table Colors Change When Moving/Copying Worksheet to a New Workbook

  1. #1
    Registered User
    Join Date
    12-06-2019
    Location
    Utah
    MS-Off Ver
    Office 365
    Posts
    42

    Table Colors Change When Moving/Copying Worksheet to a New Workbook

    The new Office theme has finally hit my version of Office 365. I have begrudgingly accepted the new default font. Whatever. But I've hit a new default that I won't accept and don't know how to fix it.

    I have worksheets featuring tables and some of them have user-created formatting of those tables and their colors.

    When I Move/Copy a worksheet into its own workbook, the font changes to the new default (Aptos Narrow) and the table changes to a completely different color. GRRRRR! I created these tables in the colors that they are in for a reason.

    In my Google searches to find a fix, somebody suggested going to Page Layout>Colors>Office 2013-2022. Great! That worked! Now my table is back to its original color again. But I do this move/copy step many times a day. I refuse to do this color changing steps every single time I move/copy that sheet into its own workbook.

    Does anybody know how to stop Excel from changing any formatting when I move/copy a worksheet into its own workbook?

    Screenshots of the original file and the moved sheet are attached.
    Attached Images Attached Images

  2. #2
    Forum Expert
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    O365 32bit (Windows)
    Posts
    2,047

    Re: Table Colors Change When Moving/Copying Worksheet to a New Workbook

    You could check if the colour scheme has changed under Page Layout/Themes
    Attached Images Attached Images

+ 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. [SOLVED] Copying Sheet to New WB - Colors change?
    By NewYears1978 in forum Excel General
    Replies: 1
    Last Post: 09-13-2023, 09:43 AM
  2. Copying table to another sheet on worksheet change
    By LePig in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-22-2016, 03:07 PM
  3. Worksheet On Change Calls Sub to change Cell colors
    By sportsguy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-01-2014, 12:20 PM
  4. Replies: 3
    Last Post: 06-28-2010, 04:28 AM
  5. Replies: 3
    Last Post: 08-08-2008, 06:12 AM
  6. Replies: 5
    Last Post: 05-01-2007, 03:51 AM
  7. Replies: 2
    Last Post: 07-31-2006, 04:53 PM

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