asked on

how to reset cell styles?

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.

Shums Faruk

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 J

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

mrosier

ASKER

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

mrosier

ASKER

Hey Shums, I tried that .xlam but it doesn't appear in Excel anywhere after I add it

Shums Faruk

Navigate to Developer/Add-Ins, Click browse and select the .xlam file where you downloaded;

It will automatically be added in your add-ins list

mrosier

ASKER

I did that actually. It doesn't appear anywhere in my workbook as a result.

Shums Faruk

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

mrosier

ASKER

It doesn't seem to be there still

Shums Faruk

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: