We help IT Professionals succeed at work.

how to reset cell styles?

2,718 Views
Last Modified: 2017-03-09
Hello! I have what is probably a stupid issue to struggle with. I have an issue where I cannot reset the cell style back to default in the attached file. I have tried importing customization from another new file which is fine, but this file in particular will not change no matter what I do. It is just this file, anything other files have different styles. Can I reset this to default somehow? I am using Excel 2010.
Comment
Watch Question

ShumsManaging Director/Excel VBA Developer
CERTIFIED EXPERT
Distinguished Expert 2018

Commented:
To clean up workbooks that already contain several styles, you can use third-party tools.

Remove Styles

The link was reference in a Microsoft KB article. See item 3 in Resolution
Professor JMicrosoft Excel Expert
CERTIFIED EXPERT
Top Expert 2014

Commented:
the best way is using the free tool XLStylesTool you can download from here if you have windows 10, it is available for free in window store.

if you want to use the VBA then here is the link from Microsoft

Author

Commented:
Sorry, folks, I should have mentioned this is for Windows 7 pro

Author

Commented:
Hey Shums, I tried that .xlam but it doesn't appear in Excel anywhere after I add it
ShumsManaging Director/Excel VBA Developer
CERTIFIED EXPERT
Distinguished Expert 2018

Commented:
Navigate to Developer/Add-Ins, Click browse and select the .xlam file where you downloaded;
RemoveStyleIt will automatically be added in your add-ins list
RemoveStyle

Author

Commented:
I did that actually. It doesn't appear anywhere in my workbook as a result.
ShumsManaging Director/Excel VBA Developer
CERTIFIED EXPERT
Distinguished Expert 2018

Commented:
Go to home tab and chec, it will show you how many style you have:
RemoveStyle

Author

Commented:
It doesn't seem to be there still

pictured
ShumsManaging Director/Excel VBA Developer
CERTIFIED EXPERT
Distinguished Expert 2018

Commented:
Untick and tick again, then go to home it will be visible on your ribbon, if not then customize ribbon and select all command and look for RemoveStyle:
RemoveStyle
Microsoft Excel Expert
CERTIFIED EXPERT
Top Expert 2014
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Hey JimJam, which item on that page do I take?

Author

Commented:
hey Shum, I did that and don't have it anywhere still including the customize option:

ribbon choices

Author

Commented:
Hey JimJam,
I used the Silverlight version (the web browser application option), and that tool worked perfectly! Thanks!

Author

Commented:
Shum gave me good effort and option, but it just wasn't happening on my computer
Professor JMicrosoft Excel Expert
CERTIFIED EXPERT
Top Expert 2014

Commented:
You are welcome.

I am glad I was able to help

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.