How to delete styles, delete styles, delete stubborn formating styles in Excel

Downloading Excel files online will be a lot when it comes to situations where there are many unexpected styles in Formating Style. So you want to delete the Style but there are many stubborn Formating Styles that cannot be deleted.

How to delete styles, delete styles, delete stubborn formating styles in Excel Picture 1

The following article shares to you 3 ways to delete Style in Excel, please follow along.

Method 1: Delete Style manually

This method only applies to a small number of Style to delete, you do the following:

On the Excel file interface to delete the style, select Home -> Cell Styles.

How to delete styles, delete styles, delete stubborn formating styles in Excel Picture 2

Formating Style appear , you want to delete any Style, right-click the Style and select Delete .

How to delete styles, delete styles, delete stubborn formating styles in Excel Picture 3

Method 2: Delete Style using VBA code

With an Excel file with many Formating Styles, this way will help you automatically delete all styles on the Excel file, you do the following:

Step 1: On the Excel file to delete the stubborn Formating Style, select Developer -> Visual Basic or press Alt + F11 to open the Microsoft Visual Basic for Application window .

How to delete styles, delete styles, delete stubborn formating styles in Excel Picture 4

Step 2 : In this window, select Insert -> Module.

How to delete styles, delete styles, delete stubborn formating styles in Excel Picture 5

Step 3: Copy the code below and paste it into the code editor, then turn off the window

Visual Basic. Sub StyleKill () Dim styT As Style Dim intRet As Integer On Error Resume Next For Each styT In ActiveWorkbook.Styles If Not styT.BuiltIn Then If styT.Name <> "1" Then styT.Delete End If Next styT End Sub

How to delete styles, delete styles, delete stubborn formating styles in Excel Picture 6

Step 4 : Select Developer -> Macros or select Review -> Macros to open the Macro dialog box.

How to delete styles, delete styles, delete stubborn formating styles in Excel Picture 7

Step 5 : Double-click on the StyleKill to run the Module to remove Formating Style.

How to delete styles, delete styles, delete stubborn formating styles in Excel Picture 8

Then you check again by selecting Home -> Cell Styles , you will see the Styles have been erased.

How to delete styles, delete styles, delete stubborn formating styles in Excel Picture 9

Method 3: Delete Style by deleting on Style.xml file

Note: If your computer does not display the format of the file, then you set the display format. If you do not know how to display, go to File Explorer, select View -> Options.

How to delete styles, delete styles, delete stubborn formating styles in Excel Picture 10

The Folders Options dialog box appears, select the View tab , in the Advanced settings you uncheck the box before the Hide extensions for known file types line and click OK .

How to delete styles, delete styles, delete stubborn formating styles in Excel Picture 11

So you have unhidden the file format on the computer, next you perform the following steps:

Step 1 : Open the Excel .xlsx file (or .xls) and then press the F12 key to open the Save As window , save the new file in .xlsm format as shown below.

How to delete styles, delete styles, delete stubborn formating styles in Excel Picture 12

Step 2 : Go to the directory containing the .xlsm file you just saved, edit the .xlsm format to .zip format. Rename message appears, select Yes .

How to delete styles, delete styles, delete stubborn formating styles in Excel Picture 13

Step 3 : Double click to open the zip file, next select the xl folder .

How to delete styles, delete styles, delete stubborn formating styles in Excel Picture 14

Step 4 : Open the styles.xml file with Notepad.

How to delete styles, delete styles, delete stubborn formating styles in Excel Picture 15

Step 5 : Here you use the search feature (Ctrl + F) and navigate to the code

How to delete styles, delete styles, delete stubborn formating styles in Excel Picture 16

Step 6 : Replace the code with the next code you save styles.xml file.

How to delete styles, delete styles, delete stubborn formating styles in Excel Picture 17

Step 7 : As soon as you save and close the styles.xml file , on the winrar folder of the Excel file that you are opening will appear that the modified styles.xml file appears , select Yes and close the .zip file.

How to delete styles, delete styles, delete stubborn formating styles in Excel Picture 18

Step 8: Convert the file from .zip format to .xlsm

How to delete styles, delete styles, delete stubborn formating styles in Excel Picture 19

You open the Excel file, appear We found a problem with some content . you choose Yes . So you see the results, then save the format .xlsx or .xls arbitrary.

How to delete styles, delete styles, delete stubborn formating styles in Excel Picture 20