https://jingyan.baidu.com/article/59a015e36d0752f7948865e3.html
按Alt+F11键,打开VBE编辑器,菜单栏点击 [插入]--> [模块]
(此操作得20分钟)
Sub deleteStyles()
Dim s As Style
On Error Resume Next
For Each s In ThisWorkbook.Styles
If Not s.BuiltIn Then s.Delete
Next
MsgBox "所有讨厌的自定义格式都删除啦!"
End Sub
彻底毁灭:
把excel保存为.rar或者.zip后,双击打开,删除xl里的styles.xml,再改回.xlsx