1、打开需要清理的 excel 文件，按键盘 alt+F11 进入 vb 编辑界面2、点击文件导入“删除模板 delstyls.bas”,关闭窗口3、点击“视图” “宏”“查看宏”4、点击执行，等待清除完毕。调整格式即可“删除模板 delstyls.bas”代码：Attribute VB_Name = “DelStyls“Sub DelStyls()Dim s As StyleDim i_s As Longi_s = ThisWorkbook.Styles.CountOn Error Resume NextApplication.ScreenUpdating = FalseFor Each s In ThisWorkbook.StylesIf Not s.BuiltIn Then s.DeleteNextApplication.ScreenUpdating = TrueMsgBox “共删除“ & i_s - ThisWorkbook.Styles.Count & “个单元格格式，还剩“ & ThisWorkbook.Styles.Count & “个！“, 64, “删除完毕“End Sub
