Solved

Excel 2010 - Themes are not changing anything!

Posted on 2016-08-04
6
48 Views
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?
0
Comment
Question by:brothertruffle880
  • 5
6 Comments
 
LVL 15

Expert Comment

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

Expert Comment

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

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.
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 15

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.
0
 

Author Comment

by:brothertruffle880
ID: 41753885
Hi Edward.
The worksheet is not protected.  I inherited the sheet from someone else.
0
 
LVL 15

Accepted Solution

by:
Edward Pamias earned 500 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.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

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.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

809 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