Excel 2010 - What's the difference between STYLES and THEMES

They both control colors and fonts and borders.
What can one feature do that the other cannot?
brothertruffle880Asked:
Who is Participating?
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Connect With a Mentor Microsoft MVP ExcelCommented:
Hello,

Themes are applied to the whole spreadsheet and affect the color palette, fonts and effects. Styles are used to control the look of cells or individual areas of the sheet and include formatting aspects like fill, border, font size, etc.

cheers, teylyn
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
For example: with the default theme selected, open the Styles drop-down on the Home Ribbon and look at the options.

There are styles for headings, accents, number formats.

When you change the Theme, you will see different colors displayed in the accents section of the styles drop-down. Other aspects of the styles remain the same, e.g. the fact that a heading has a bottom border or the output style has a border all around.

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.