Format - Style list
 

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*******

Format - Style list
 

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