Format - Style list

[Jaylin]

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.

 

[Dave Peterson]

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