[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now


Excel 2010 - Themes are not changing anything!

Posted on 2016-08-04
Medium Priority
Last Modified: 2016-08-19
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?
Question by:brothertruffle880
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
LVL 19

Expert Comment

by:Edward Pamias
ID: 41743086
Is the workbook protected?
LVL 19

Expert Comment

by:Edward Pamias
ID: 41743091
Check conditional formatting. There might be some rules setup that you may want to remove.
LVL 19

Expert Comment

by:Edward Pamias
ID: 41743094
If all else fails, you can copy and paste the data to a new sheet and format that one.
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

LVL 19

Expert Comment

by:Edward Pamias
ID: 41743101
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.

Author Comment

ID: 41753885
Hi Edward.
The worksheet is not protected.  I inherited the sheet from someone else.
LVL 19

Accepted Solution

Edward Pamias earned 2000 total points
ID: 41754355
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.

Featured Post

Tech or Treat!

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

649 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question