Excel 2010 - Themes are not changing anything!

I inherited a workbook that's very plain.  Nothing.  No graphics colors, etc.
I want to apply themes but when I try to apply them nothing happens.  No change in colors, fonts or anything.
I have a feeling a predecessor modified a style or something.
How can I reset the formatting of this sheet so that themes WILL take effect?
Who is Participating?
Edward PamiasConnect With a Mentor Team Lead RRS DeskCommented:
Did you try making it a table and then try to apply themes? Or just copy the data to a new sheet and try it.
Edward PamiasTeam Lead RRS DeskCommented:
Is the workbook protected?
Edward PamiasTeam Lead RRS DeskCommented:
Check conditional formatting. There might be some rules setup that you may want to remove.
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Edward PamiasTeam Lead RRS DeskCommented:
If all else fails, you can copy and paste the data to a new sheet and format that one.
Edward PamiasTeam Lead RRS DeskCommented:
I found a solution, which says you need to make your data a table. Once you make it a table you can go to themes and then make the change.
brothertruffle880Author Commented:
Hi Edward.
The worksheet is not protected.  I inherited the sheet from someone else.
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.