• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Apply different Themes to different sheets in a worksheet

Vivek D

Member
When we apply a theme in Excel it applies it to the entire workbook. Can we apply it to only 1 specific sheet and maybe apply another theme to another sheet within the same workbook?
 
Which type of theme you are talking about... Is that office Theme ?? or any other. If it is office theme, it will apply not only in excel but also in other office products like word,outlook,access etc...
If you want to put a theme for different sheets, you can select sheet background option, It will apply what ever you choose like photos, colors etc. In this case you can apply different types of themes for different sheets.

I hope you got my point...
 
Which type of theme you are talking about... Is that office Theme ?? or any other. If it is office theme, it will apply not only in excel but also in other office products like word,outlook,access etc...
If you want to put a theme for different sheets, you can select sheet background option, It will apply what ever you choose like photos, colors etc. In this case you can apply different types of themes for different sheets.

I hope you got my point...

I should have been more specific. I was referring to the Themes under Page Layout. See image below.

Themes.png
 
Theme..
the word is self-descripting itself..
when you want.. a same similarity within your slide, get-to-gether-party, Window's Color scheme or in worksheets.. we use the word THEME..

avoid using themes in this sccenario
 
Theme..
the word is self-descripting itself..
when you want.. a same similarity within your slide, get-to-gether-party, Window's Color scheme or in worksheets.. we use the word THEME..

avoid using themes in this sccenario

Well I was expecting this response when I asked the question but thought I'd ask anyway.

I have 2 different sheets that show similar set of charts but for 2 different kinds of information so wanted 2 different color schemes to help clearly differentiate them. I liked one particular color scheme from 1 theme and another color scheme from another so wanted to know if there was a way to do it without manually assigning the colors.
 
Back
Top