Excel 2010 - Themes not being applied to one of my worksheets.
I have a two worksheets inside of a workbook and would like to apply a theme to both of the worksheets. However, one of the sheets is not accepting the theme. How can I fix this? (See attached workbook)
my-Comparison-report.xlsx
my-Comparison-report.xlsx
ASKER
Mark:
I didn't use ANY fonts, fills borders. As you can see on the sheet, I merely did a
HomeTab/ Editing group, CLEAR button /Clear FORMATS
to reset that worksheet back to its bare minimum. i.e. basic font, color, sizes, etc.
I am utterly stumped.
I didn't use ANY fonts, fills borders. As you can see on the sheet, I merely did a
HomeTab/ Editing group, CLEAR button /Clear FORMATS
to reset that worksheet back to its bare minimum. i.e. basic font, color, sizes, etc.
I am utterly stumped.
Hello,
>> I merely did a [...] clear Formats
Exactly therein lies the problem. The cells now don't have any formatting, so theme colors won't be applied and neither will theme changes reflect.
Copy A1 to F12 on the second tab, select A1 on the first tab and use Paste Special > Formats
Now the formats are back and the colors will change if you select a different theme.
cheers, teylyn
>> I merely did a [...] clear Formats
Exactly therein lies the problem. The cells now don't have any formatting, so theme colors won't be applied and neither will theme changes reflect.
Copy A1 to F12 on the second tab, select A1 on the first tab and use Paste Special > Formats
Now the formats are back and the colors will change if you select a different theme.
cheers, teylyn
ASKER
Teylyn/Mark:
I thought when you did a clear formats, you were resetting things back to a unmolested state.
Based on what I'm reading from the two of you, clear formats is like using a "standard" color. i.e. themes will have NO effect on the cells you use the standard colors on or on the cells you do a clear formats on.
Is there a VBA term here that might serve to clarify?
1. What is the name of the cell state where you can apply a theme to a cell and the theme gets applied.
2. What is the name of the cell state that I created by clearing my formatting, or by applying a standard color? I thought clearing formatting was "resetting" the cell back to a pristine state where themes would take affect. But apparently I molested the cells in some invisible way! It seems that clearing formatting is just as invasive as setting a cell to a standard color.
I'm trying to understand the logic of cell states and their restoration to a state where themes can work
I thought when you did a clear formats, you were resetting things back to a unmolested state.
Based on what I'm reading from the two of you, clear formats is like using a "standard" color. i.e. themes will have NO effect on the cells you use the standard colors on or on the cells you do a clear formats on.
Is there a VBA term here that might serve to clarify?
1. What is the name of the cell state where you can apply a theme to a cell and the theme gets applied.
2. What is the name of the cell state that I created by clearing my formatting, or by applying a standard color? I thought clearing formatting was "resetting" the cell back to a pristine state where themes would take affect. But apparently I molested the cells in some invisible way! It seems that clearing formatting is just as invasive as setting a cell to a standard color.
I'm trying to understand the logic of cell states and their restoration to a state where themes can work
Trying to clear up some confusion with themes:
- you can see the theme colors in the color dropdown for font color or cell fill.
- if you select from one of these visible colors, you are applying a theme color.
- if you select from one of the Standard Colors or click "More colors" you are NOT applying a theme color.
- Elements formatted with theme colors will change when you change the theme
- Elements formatted with non-theme colors, i.e. "Standard colors" or via "more colors" will NOT change when you change the theme
And finally: Clearing all formats will remove any formatting from the selected elements and you end up with the default font for Excel.
cheers, teylyn
- you can see the theme colors in the color dropdown for font color or cell fill.
- if you select from one of these visible colors, you are applying a theme color.
- if you select from one of the Standard Colors or click "More colors" you are NOT applying a theme color.
- Elements formatted with theme colors will change when you change the theme
- Elements formatted with non-theme colors, i.e. "Standard colors" or via "more colors" will NOT change when you change the theme
And finally: Clearing all formats will remove any formatting from the selected elements and you end up with the default font for Excel.
cheers, teylyn
ASKER
Question: I have a worksheet with all sorts of odd changes on it which are not allowing themes to take effect. How can I take this worksheet and restore it to a state where all themes applied will take effect.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Jeepers. I didn't think there was so much to know about themes.
See last post on this thread: Issue with Themes
As a quick fix, select the upper left square on the sheet that "works" to select the entire sheet, right-click/copy, then select all on the sheet that doesn't work, right-click/paste special/format.
Now, if you change the theme, it will change on both sheets.