View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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