View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default Deleting multiple styles at once in Excel 2003

Hi,

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

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Elardus" wrote:

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