You could use a macro:
Option Explicit
Sub testme()
Dim myStyle As Style
For Each myStyle In ThisWorkbook.Styles
If myStyle.BuiltIn = True Then
'skip it
Else
myStyle.Delete
End If
Next myStyle
End Sub
If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
Jaylin wrote:
In Excel, when I select Format then Style, I see a lot of style names.
May I know how I can reduce the list in one step, instead of selecting and
deleting one by one.
--
Thanks a million for your time and expert advice :-)
Jaylin
*****Jaylin Message ended*******
--
Dave Peterson