Link on deleting excel formatting

http://excelribbon.tips.net/T012259_Deleting_Unwanted_Styles.html

Excerpt:

Removing user-defined styles is very easy, though, if you use a macro. The following macro will quickly delete the unwanted styles:

Sub StyleKill()      Dim styT As Style      Dim intRet As Integer        For Each styT In ActiveWorkbook.Styles          If Not styT.BuiltIn Then              intRet = MsgBox("Delete style '" & styT.Name & "'?", vbYesNo)              If intRet = vbYes Then styT.Delete          End If      Next styT  End Sub  

The macro needs just a little user input. Whenever the macro detects a user-defined style, you are asked if you want to delete it. Clicking on the Yes button causes the style to be removed from the workbook.

I also found this link, however, currently has my workbook locked up so we'll see.....

https://support.microsoft.com/en-us/kb/291321