Deleting multiple styles at once in Excel 2003

[Elardus]

I love working with styles, of which I've built up quite a few handy ones
over the years (They accumulate in my always-hidden "Personal" workbook).
However, I often inherit workbooks from others with way too many styles due
to merging of parts from other files.

I wish to find a way of choosing obsolete styles (I recently had a workbook
with about ten different "Normal" styles for instance) and deleting them at
once. The alternative is unbelievably tedious... Selecting and deleting them
one by one through the /Format/Style-menu...

Why do I want to delete the obsoltete ones? When there's a growing list of
about fifty plus and I just want to work with my own styles "Annual" or "Zero
totals" it is highly frustrating every time negotiating such a long list...

 

[Jim Cone]

My Excel add-in "Formats and Styles" will list or delete used/unused
number formats and styles in the active workbook.
(not tested on xl2007)
It may do what you want. It is free upon email request.
I ask that you use your real name and provide your geographic location.
Remove xxx from my email address: (e-mail address removed)
--
Jim Cone
Portland, Oregon USA



"Elardus" <[email protected]>
wrote in message
I love working with styles, of which I've built up quite a few handy ones
over the years (They accumulate in my always-hidden "Personal" workbook).
However, I often inherit workbooks from others with way too many styles due
to merging of parts from other files.

I wish to find a way of choosing obsolete styles (I recently had a workbook
with about ten different "Normal" styles for instance) and deleting them at
once. The alternative is unbelievably tedious... Selecting and deleting them
one by one through the /Format/Style-menu...

Why do I want to delete the obsoltete ones? When there's a growing list of
about fifty plus and I just want to work with my own styles "Annual" or "Zero
totals" it is highly frustrating every time negotiating such a long list...

 

[Elardus]

Thanks Jim. I'll email.

Elardus Maré
Perth, Western Australia

 

[Shane Devenshire]

Hi,

How do you want Excel to distinguish obsolete styles from ones that aren't?